Site icon IT Tutorial

ORA-28011: the account will expire soon; change your password now

Hi,

Sometimes You can get “ORA-28011: the account will expire soon; change your password now ” error.

 

Details of error are as follows.

ORA-28011: the account will expire soon; change your password now
Cause: The user’s account is marked for expiry; the expiry period is unlimited.
Action: Change the password or contact the DBA.

 

 

 

To solve this error, you should change the user’s password manually as follows.

SQL> alter user <username> identified by <password>;



SQL> alter user mehmet identified by deveci;

User altered.

 

And set an explicit value for the PASSWORD_GRACE_TIME as follows.

SQL> alter profile default limit password_grace_time 4;
Profile 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