database's docs

6.2.0 ora-28001 the password has expired


1. ora-28001错误解决

原因是oracle 11g中用户的默认有效期是180天,过期之后会自动锁定账号。解决方法很简单,将过期时间改成无限,重新激活老账号就行。

sqlplus /nolog
SQL> connect / as SYSDBA
Connected.

SQL> SELECT username, account_status FROM dba_users WHERE ACCOUNT_STATUS LIKE '%EXPIRED%';

SQL> ALTER USER system IDENTIFIED BY system;         
User altered.

SQL> ALTER USER system ACCOUNT UNLOCK;
User altered.

SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
Profile altered.

将system换成你的用户