ORACLE11G account password expires and cannot be entered in SYSDBA identity sqlplus

" Phenomenon "

When the system is running suddenly unable to enter the system, through the FF browser debugging, found that the cause of the error is "Ora-28001:the password has expired" is the Oracle account password expires.

"Cause /Trigger factor"

through the Baidu query is due to the new features of oracle11g, oracle11g when creating a user default password expiration limit is 180 days (that is, 6 months), if more than 180 days the user password has not been modified, the user cannot log on. 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.

"Solutions"

1>cmd Enter the DOS system and enter "Sqlplus/nolog".

2> has sysdba identity connection, enter "Conn/as sysdba".

3> See which user's proifle is, typically the default input "select Username,profile from Dba_users;" NOTE: The SQL statement needs to be added ";".

4> view The password expiration settings for the specified profile, such as default. Enter "select * from Dba_profiles s WHERE s.profile= ' DEFAULT ' and resource_name= 'password_life_time';".

        5> The password is valid from the default 180 days modified to "unlimited" input "alter profile DEFAULT limit  password_ Life_time  unlimited ; ". You should be able to enter the system after the modification.
                6> Repeat step 4 to see that the password expiration date has been modified to UNLIMITED.

" resolution process "

The "ERROR:ORA-12560:TNS: Protocol Adapter error occurred" during the 2nd step of the "solution" execution. "

This issue resolves the process:

1> First make sure that the listener and the instance are up and running.

2> setting environment variable: oracle_sid= "instance name", Oracle_name=oracle installation Address (example: E:\app\ZHANGZHEN\product\11.2.0\dbhome_1), need to restart the instance and listen. or execute "Set oracle_sid= instance name" in DOS

3> follow the 3rd step of the solution.