Oracle密码过期

原因
是由于oracle11g中默认在default概要文件中设置了“PASSWORD_LIFE_TIME=180天”所导致。

解决方案

[oracle@slave01 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on 星期三 6月 28 17:08:13 2017

Copyright (c) 1982, 2009, Oracle.  All rights reserved.


连接到: 
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
#查看默认配置，确定默认是180天
SQL> select * from dba_profiles where profile='DEFAULT' and resource_name='PASSWORD_LIFE_TIME';

PROFILE
--------------------------------------------------------------------------------
RESOURCE_NAME
--------------------------------------------------------------------------------
RESOURCE_TYPE
------------------------
LIMIT
--------------------------------------------------------------------------------
DEFAULT
PASSWORD_LIFE_TIME
PASSWORD
180
#对默认配置进行修改
SQL> alter profile default  limit password_life_time unlimited;  

配置文件已更改

SQL> commit;

提交完成。
#再查看设置
SQL> select * from dba_profiles where profile='DEFAULT' and resource_name='PASSWORD_LIFE_TIME';

PROFILE
--------------------------------------------------------------------------------
RESOURCE_NAME
--------------------------------------------------------------------------------
RESOURCE_TYPE
------------------------
LIMIT
--------------------------------------------------------------------------------
DEFAULT
PASSWORD_LIFE_TIME
PASSWORD
UNLIMITED
#进行以上步骤之后需要改变密码，否则还会出现password has expired异常
SQL> alter user pjptusr identified by pjptusr
  2  ;

用户已更改。
#如果账号被锁住，则需要解锁命令
SQL> alter user XXXUSER identified by oracle account unlock;