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

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/