Oracle 11g Username Password 180 days overdue Processing

Oracle 11g Username Password 180 days overdue Processing

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.