ora-28001: the password has expired 解决
ora-28001: the password has expired
cause: the users account has expired and the password needs to be changed
action: change the password or contact the dba
程序连接db服务器时报错：
13-04-22 17:32:15 [error] com.sohu.game.main {main.java:102} - 统计失败：
java.sql.sqlexception: ora-28001: the password has expired
at oracle.jdbc.dbaccess.dberror.throwsqlexception(dberror.java:134)
at oracle.jdbc.ttc7.ttioer.processerror(ttioer.java:289)
at oracle.jdbc.ttc7.o3log.receive2nd(o3log.java:496)
解决方法：
查看帐号的信息：
sql> select username,account_status,lock_date,expiry_date,password,created from dba_users where username=upper('xxx ');
username account_st lock_date expiry_date created
-------------------- ---------- -------------------- ------------------- ------------------------------ -------------------
xxx expired 2013-04-22 14:44:43 2012-10-17 14:20:15
查看帐号的password_life_time设置：
sql> select * from dba_profiles where profile like '%xxx%';
profile resource_name resource limit
------------------------------ -------------------------------- -------- ----------------------------------------
pf_xxx password_life_time password default
查看系统profile文件的默认设置：
sql> select * from dba_profiles where profile like '%default%';
profile resource_name resource limit
------------------------------ -------------------------------- -------- ----------------------------------------
default password_life_time password 180
设置了用户的password_life_time，默认为180天；
修改用户的password_life_time限制：
sql> alter profile default limit password_life_time unlimited;
profile altered.
重新设置用户的密码：
sql> alter user xxx identified by xxx;
user altered.
sql> select username,account_status,lock_date,expiry_date,password,created from dba_users where username=upper('xxx');
username account_st lock_date expiry_date created
-------------------- ---------- -------------------- ------------------- ------------------------------ -------------------
xxx open 2012-10-17 14:20:15
帐号状态恢复正常。
注意：
因为这个帐号是应用程序在使用的，不能更换密码，所在在使用alter user...identified by的时候，需要使用这个帐号当前的密码进行操作。
在centos 6.4下安装oracle 11gr2(x64)
oracle 11gr2 在vmware虚拟机中安装步骤
debian 下 安装 oracle 11g xe r2
本文永久更新链接地址：
，