ORA-28001 causes the personnel Web APP not to be useful

Recently, personnel feedback, personnel web App bad use, the server has been restarted.

Into the server, view Tomcat LOGS, and find oar-28001 errors. After Baidu, use the following link in method two to solve the problem.

Oracle error, ORA-28001: password has expired

oracle11g The default password expiration limit when creating a user is 180 days (that is, 6 months) and the user cannot log on if the user password has not been modified for more than 180 days.
Oracle Corporation has introduced this default feature in 11G for database security by default, but this default feature is easily overlooked by DBAs or developers, which can occur if the password has not been modified for 180 days.

Method one (PL/SQL):

1	SELECT * FROM dba_profiles WHERE profile=‘DEFAULT‘AND resource_name=‘PASSWORD_LIFE_TIME‘

12345678

<br>查询密码的有效期设置，LIMIT字段是密码有效天数。<br><br>在密码将要过期或已经过期时可通过如下语句进行修改密码，密码修改后该用户可正常连接数据库。<br>ALTER USER 用户名 IDENTIFIED BY 密码 ; 如果想去除180天的密码生存周期的限制可通过如下SQL语句将其关闭 ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED如上SQL语句将口令有效期默认值180天修改成了“无限制”。但是出于数据库安全性考虑，不建议将PASSWORD_LIFE_TIME值设置成UNLIMITED

Method Two (cmd command):

123	（1）在CMD命令窗口中输入：        sqlplus 用户名/密码@数据库本地服务名 as sysdba;（如：sqlplus scott/[email protected] assysdba;）

123	（2）查看用户的proifle是哪个，一般是default：　　 sql>SELECT username,PROFILE FROM dba_users;

123	（3）查看对应的概要文件(如default)的密码有效期设置：　　 sql>SELECT * FROM dba_profiles s WHERE s.profile=‘DEFAULT‘AND resource_name=‘PASSWORD_LIFE_TIME‘;

12345

(4) profile (e.g. default ) is changed from the default 180 days to "unrestricted":              sql>alter profile DEFAULT LIMIT password_life_time UNLIMITED;   After modification, the database does not need to be restarted and takes effect immediately.

1234567

（5）修改后，还没有被提示ORA-28002警告的用户账号不会再碰到同样的提示;而已经被提示的用户账号必须再改一次密码，举例如下：　　 $sqlplus / as sysdba 　　 sql>alter user 用户名 identified by <原来的密码> account unlock; ----不用换新密码注意：oracle11g启动参数resource_limit无论设置为false还是true，密码有效期都是生效的，所以必须通过以上方式进行修改。

ORA-28001 causes the personnel Web APP not to be useful