Error code: ORA-28032
Description: Your password has expired and the database is set to read-only
Cause:
Your password expired and needs to be changed before your login request can be processed. Because the database is currently open in read-only mode, the password change operation cannot be performed on this database.
Your password expired and needs to be changed before your login request can be processed. Because the database is currently open in read-only mode, the password change operation cannot be performed on this database.
How
to modify password life time in oracle for resolving above error. The following statement modifies the profile:
Action:
Log in to the primary database to change your password, then retry your login request at the standby database.
Log in to the primary database to change your password, then retry your login request at the standby database.
SQL> ALTER PROFILE DEFAULT LIMIT password_life_time UNLIMITED;
No comments:
Post a Comment