Oracle 11g default profile default Enable Password Expiration 180 days ORA-28001 error handling

Oracle 11g default profile default Enable Password Expiration 180 days ORA-28001 error handling Problem description: the customer reported that the client could not connect when logging on to the application. Environment: AIX 5.3 + Oracle 11gR2 solution: remotely Telnet to the Database Host. After sqlplus/as sysdba is connected, the operation is normal, indicating that the database server should be normal, then the client with sqlplus to connect to the database prompts password Expiration error: ORA-28001: the password has expired, the original password expired. Analysis: in Oracle versions earlier than 11g, the default profile has no password expiration restrictions. In Oracle 11g, the default profile enables the password expiration time to be 180 days. You can remove this restriction. Query the Password Expiration settings of the default profile.

Select * from dba_profileswhere profile = 'default' and resource_name = 'password _ LIFE_TIME ';

 

Set the default profile password to never expire. It takes effect immediately and does not need to be restarted.

Alter profile default limit password_life_time unlimited;

 

You need to change the password that has expired. You can use the same password. If you log on to sqlplus, you will be prompted to change the password.

Alter user username identified by password;