Modify the jdbc data source password through the configuration file in the weblogic background

Note: Assume one of the weblogic domains in the environmentFor cams, the data source is CAMSDB

(1) Directly modify the ciphertext password in the data source configuration file of weblogic to the latest plaintext password [the first attempt ended in failure, weblogic did not automatically convert the password in the JDBC configuration file from plaintext to ciphertext
Enter the path where the JDBC configuration file is located
[[email protected] jdbc]$ cd /home/cams/bea/middleware/user_projects/domains/cams/config/jdbc
Open the configuration file and modify it
[[email protected] jdbc]$ vi CAMSDB-2211-jdbc.xml

Change the ciphertext password in XXX to the plaintext password
Then start the weblogic domain, and check the startup log, the following error is reported:

Caused by: com.bea.xml.XmlException: java.lang.IllegalArgumentException: In production mode, it's not allowed to set a clear text value to the property: PasswordEncrypted of JDBCDriverParamsBean

(2) Use the tools provided by weblogic to convert the plaintext into ciphertext, and then replace it

[[email protected] ~]$ cp /home/cams/bea/middleware/wlserver_10.3/server/lib/weblogic.jar /home/cams/bea/middleware/user_projects/domains/cams/
[[email protected] ~]$ cd /home/cams/bea/middleware/user_projects/domains/cams/
[[email protected] cams]$ java -cp weblogic.jar weblogic.security.Encrypt newpassword

Here, the ciphertext of the password of the data source CAMSDB is: [Note: the same plaintext generates different ciphertexts in different weblogics]
{AES}dUH3nDtUg3LfPBCngOAAPFgsIW4gVRPyD25aibk4zVQ=

(3) Modify the ciphertext password in the weblogic data source configuration file to the latest ciphertext password [still encounter problems, the account is locked]

Enter the path where the JDBC configuration file is located
[[email protected] jdbc]$ cd /home/cams/bea/middleware/user_projects/domains/cams/config/jdb
Open the configuration file and modify it
[[email protected] jdbc]$ vi CAMSDB-2211-jdbc.xml
Change the ciphertext password in XXX to the latest ciphertext password
Then start the weblogic domain and view the startup log

[[email protected] jdbc]$ cd /home/cams/bea/middleware/user_projects/domains/cams
[[email protected] jdbc]$ nohup ./startWebLogic.sh & tail -f nohup.out

The following error message was found:
weblogic.common.ResourceException: weblogic.common.ResourceException: Could not create pool connection. The DBMS driver exception was: ORA-28000: the account is locked

(4) Solve the problem of account lockout

1) select username, profile from dba_users; ---confirm the profile used by the user

2) alter profile default limit failed_login_attempts unlimited;---If the number of login attempts is limited to 10 times, modify the limit of the number of login attempts to unlimited (you do not need to restart the database after modification, and the modification result will take effect immediately.)

3) Note: After the modification, the account that has not been prompted by the ORA-28000 warning will not encounter the same problem again. The locked user still needs to be unlocked. The method is as follows:

Alter user user_name account unlock;