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.

Upgrading JDBC driver in Fusion Middleware 11g stack

1. Download the latest version of the JDBC drivers [ojdbc6.jar and orai18n.jar ]from OTN

2. Replace the following directories with the latest ojdbc6.jar
FMW_HOME/Oracle_SOA1/inventory/Scripts/ext/jlib/ojdbc6.jar
FMW_HOME/oracle_common/inventory/Scripts/ext/jlib/ojdbc6.jar
FMW_HOME/wlserver_10.3/server/lib/ojdbc6.jar
FMW_HOME/wlserver_10.3/server/adr/ojdbc6.jar

Make sure you take a backup of ojdbc6.jar from any one of the directories above

3. Replace the following directories with the latest orai18n.jar
FMW_HOME/oracle_common/modules/oracle.nlsrtl_11.1.0/orai18n.jar
FMW_HOME/wlserver_10.3/server/ext/jdbc/oracle/11g/orai18n.jar

Make sure you take a backup of orai18n.jar from any one of the directories above

4. Restart WebLogic Server and test your data source.

Note: 
a. The above change was tested on Fusion Middleware 11g ps5
b. FMW_HOME as defined in Fusion Middleware Directory Structure

Oracle Linux 6.5 and Gnome Issues

Yesterday, I was trying to install Oracle Linux 6.5 on my desktop with Nvidia driver. During installation process, I customized and selected the packages to install Desktop and other gui features. Post installation, the gui would not load and the server just hangs on the Oracle Linux 6.5 status bar.

With the help of Lance, our Sys Admin, ran the following commands to get the GUI

yum install gdm
yum install gnome
yum install xorg-x11-drv-nouveau

Reboot the system - and I get the GUI