ORACLE11G User name password 180 days expiration processing

A password expiration issue occurs with the following methods:
1: First login to the console for verification, WebLogic with the JDBC test, you can verify the database connectivity. At the same time the application log should appear with the ORA-28002 password expiration error prompt.
2: You can also log in to the database, using the original user connection attempt conn Username/mima. The password expiration prompt for ORA-28002 will also appear.

Here's how:
11g Oracle default password 180 days expired policy, need to modify the following, in a node to do the line, do not restart, immediate effect
The following actions are performed using the database administrator account.
#1: The query confirmation policy, if a 180-day word appears, indicates that there is a default configuration: (You can also use dba_users to try to view)
Sqlplus/as SYSDBA
SELECT * from Dba_profiles where profile= ' DEFAULT ' and resource_name= ' password_life_time ';

#2: Modifying Configuration policies
Alter profile default limit Password_life_time UNLIMITED;
After the modification, perform the above query operation, verify that the results are unlimited.


3: Reset Password (if oracle11g must find the original password)
alter user CYJYGK3 identified by original password; If special characters are present in the password, you need to use "" to cause them.

After the modification is complete, verify.
If the WebLogic is configured with a database re-connect mechanism, it is theoretically not necessary to restart the node to recover. If you do not configure a re-connect policy, you must restart the service.

This article from the "Technology in hand, the world I have" blog, please be sure to keep this source http://xin521long.blog.51cto.com/11884590/1833629

ORACLE11G User name password 180 days expiration processing