ORA-28001 Error Resolution method

ora-28001:the Password has expired

Cause:the user "s account has expired and the password needs to be changed

Action:change the password or contact the DBA

Program Connection DB server times error:

13-04-22 17:32:15 [ERROR] com.sohu.game.Main {main.java:102}-Statistic failed:

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)

Workaround:

To view account information:

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

To view the Password_life_time settings for your account:

Sql> SELECT * from dba_profiles where profiles like '%xxx% ';

Profile Resource_name RESOURCE LIMIT

------------------------------ -------------------------------- -------- ----------------------------------------

Pf_xxx password_life_time PASSWORD DEFAULT

To view the default settings for the system profile file:

Sql> SELECT * from dba_profiles where profiles like '%default% ';

Profile Resource_name RESOURCE LIMIT

------------------------------ -------------------------------- -------- ----------------------------------------

DEFAULT Password_life_time PASSWORD 180

Set the user's password_life_time, the default is 180 days;

To modify the user's password_life_time limit:

sql> alter profile DEFAULT limit Password_life_time unlimited;

Profile altered.

To reset a user's password:

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

Account status returned to normal.

Attention:

Because this account is the application in use, cannot change the password, where the use of Alter user...identified by, you need to use the current password to operate the account.

This column more highlights: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/