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

This article mainly explains the "how to modify the jdbc configuration file to modify the Weblogic data source password", the content of the article is simple and clear, easy to learn and understand, the following please follow the editor's ideas slowly in depth, together to study and learn "how to modify the jdbc configuration file to modify the Weblogic data source password" bar!

Note: assume that one of the weblogic domain names in the environment is cams and the data source is CAMSDB

(1) directly modify the ciphertext password in the weblogic data source configuration file 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, and encountered a new problem]

Enter the path where the JDBC configuration file is located

[cams@mymc1 jdbc] $cd / home/cams/bea/middleware/user_projects/domains/cams/config/jdbc

Open the configuration file and modify it

[cams@mymc1 jdbc] $vi CAMSDB-2211-jdbc.xml

Change ciphertext password in XXX to plaintext password

Then start the weblogic domain and view the startup log

[cams@mymc1 jdbc] $cd / home/cams/bea/middleware/user_projects/domains/cams

[cams@mymc1 jdbc] $nohup. / startWebLogic.sh &

[cams@mymc1 jdbc] $tail-f nohup.out

The following error message was found:

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

Obviously, Oracle users tried to connect too many times with the wrong password, resulting in the account being locked.

(6) deal with the final problem [as a result of another error report, caused by carelessness]

Here, you need to contact the database administrator, log in to the database using system or sys users, and execute the query statement:

SQL > select * from dba_users where account_status' OPEN'

Find the locked user and execute the unlock statement:

SQL > alter user XXXX account unlock

Then restart again, or find an error message:

ORA-01017: invalid username/password; logon denied

After checking, because in the replacement, there is a ciphertext replacement error, resulting in the data source connection failed. You can replace it here.

Finally, weblogic starts successfully, everything OK!

Thank you for reading, the above is "how to modify the jdbc configuration file to modify the Weblogic data source password" content, after the study of this article, I believe you on how to modify the jdbc configuration file to modify the Weblogic data source password has a deeper understanding of this problem, the specific use of the situation also needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

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.