XTY的小站
记录技术笔记和技术博客

6.2.0 ora-28001 the password has expired

25 Aug 2017

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换成你的用户