Wednesday, April 23, 2014

How to recover / decrypt lost JDBC DB password?




It is a common practice that DBAs or Middlware team keeps a record of all the DB schema user credentials which are used to configure the JDBC resources on weblogic side.

However, it is equally common sometimes we forget this password. Of course, resetting the password is the last option.


Below is an easy way to recover the passwords.

Download the script from  here and copy on to the Unix server.

Below commands need to be run,

$. ./setWLSEnv.sh  (executing setDomainEnv.sh also works).

$  java weblogic.WLST  decryptPassword.py <domain_directory_path>   {3DES}cB/oOD/n1AYMusmAgNIeg==

{3DES}cB/oOD/n1AYMusmAgNIeg==  is the encrypted password  pulled from the relevant jdbc xml file located at config/jdbc folder.

For more information, please look at the source.

No comments:

Post a Comment