Shulou(Shulou.com)06/01 Report--

The problem of password expiration occurs and is handled as follows:

1: log in to the console for verification, and the JDBC test that comes with weblogic can verify database connectivity. At the same time, the application log should show an error that the password of ORA-28002 expires.

2: you can also log in to the database and use the original user to connect to conn username/MIMA. The password expiration prompt for ORA-28002 will also appear.

The specific operations are as follows:

11g oracle has a policy that the password expires within 180 days by default. You need to modify it as follows. You can do it on a node without restarting. It will take effect immediately.

The following operations should be done using the database administrator account.

# 1: query confirmation policy. If the word "180 days" appears, the default configuration exists: (you can also use dba_users to try to view it)

Sqlplus / as sysdba

Select * from dba_profiles where profile='DEFAULT' and resource_name='PASSWORD_LIFE_TIME'

# 2: modify configuration policy

Alter profile default limit PASSWORD_LIFE_TIME UNLIMITED

After modification, the above query operation is performed and verified, and the result is UNLIMITED.

3: reset the password (if it is oracle11g, you must find the original password)

Alter user cyjygk3 identified by original password; if there are special characters in the password, it needs to be quoted with "".

After the modification is completed, verify it.

If weblogic is configured with a database reconnection mechanism, it can theoretically be restored without restarting the node. If the reconnection policy is not configured, the service must be restarted.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.