The Oracle 11g user name and password have expired. The solution is as follows:
1: log on to the console for verification. The JDBC test provided by weblogic can verify the database connectivity. At the same time, the application log should be prompted with a password expiration error for the ORA-28002.
2: You can also log on to the database, use the original user to connect to try conn username/MIMA. There will also be a ORA-28002 password expiration prompt.
The procedure is as follows:
Oracle 11g has a 180-day password expiration policy by default. The policy needs to be modified as follows. It takes effect immediately without restarting on a node.
You must use the database administrator account to perform the following operations.
#1: query confirmation policy. If the word "180 Days" is displayed, the default configuration exists: (You can also use dba_users to view it)
Sqlplus/as sysdba
Select * from dba_profiles where profile = 'default' and resource_name = 'password _ LIFE_TIME ';
#2: modify the configuration policy
Alter profile default limit PASSWORD_LIFE_TIME UNLIMITED;
After the modification, perform the preceding query and verify that the result is as limited as possible.
3: reset the password (the original password must be found for oracle11g)
Alter user cyjygk3 identified by original password. If the password contains special characters, use.
Verify the modification.
If weblogic is configured with a database reconnection mechanism, it can be restored without restarting the node theoretically. If the reconnection policy is not configured, you must restart the service.
Add another article:
After the password expires, an exception occurs when the business process connects to the database, which will inevitably affect the use and login.
Liberation method:
**************************************** ***************
1. Check the user password's validity period settings (generally the DEFAULT configuration file is DEFAULT)
SQL> SELECT * FROM dba_profiles WHERE profile = 'default' AND resource_name = 'password _ LIFE_TIME'
2. Change the password validity period from the default 180 days to "unlimited". After the change, you do not need to restart the database and the password will take effect immediately.
SQL> Alter PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
3. Change the account password again
SQL> alter user ink identified by <original password> ---- no new password required
4. Log on with the modified user, if "ORA-28000: User locked" is reported, unlock
SQL> alter user db_user account unlock;
SQL> commit;