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.
321 views last month, 13 views today