ORA-28001: the password has expired
sqlplus /nolog
sqlplus /nolog
SQL> connect / as SYSDBA
Connected.
--------------------------------------------------------------------------------------------------------------------------
check "PASSWORD_LIFE_TIME" by
Sql > select * from dba_profiles;
Set to Never expire
Sql> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
Then reset the password of locked user
Sql > select * from dba_profiles;
Set to Never expire
Sql> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
Then reset the password of locked user
Sql> alter user myuser identified by mynewpassword account unlock;
--------------------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment