Site icon IT Tutorial

ORA-28007: the password cannot be reused

Hi,

Sometimes You can get “ORA-28007: the password cannot be reused ” error.

 

Details of error are as follows.

ORA-28007: the password cannot be reused

Cause: The password cannot be reused for the specified number of days or for the specified nunmber of password changes

Action: Try the password that you have not used for the specified number of days or the specified number of password

changes Refer to the password parameters in the CREATE PROFILE statement

SQL> alter user mehmet identified by deveci
     *
ERROR at line 1:
ORA-28007: the password cannot be reused

 

 

You can set different password that you used, but if you don’t want to change it you can modify PASSWORD_REUSE_TIME.

 

To solve this error, you can set the PASSWORD_REUSE_TIME parameter to UNLIMITED.

SQL>  alter profile default limit PASSWORD_REUSE_TIME UNLIMITED;
 
Profile altered.

or You can set it any value as follows.

 

SQL> alter profile default limit PASSWORD_REUSE_TIME 360;

Profile altered.

Then you can use the same password again.

SQL> alter user mehmet identified by deveci;
 
User altered.

 

Do you want to learn Oracle Database for Beginners, then read the following articles.

https://ittutorial.org/oracle-database-19c-tutorials-for-beginners/

Exit mobile version