How to Configure OUD to accept SSL using a Self-Signed Certificate

Requirement:
Need to enable SSL for OUD with self-signed certificate.

Steps to create SSL self-signed certificate for OUD (11.1.2.3.0)

1. Prepare keystore directory:

cd /u01/mwOUD/asinst_2/OUD
mkdir config/sslv101
touch sslv101/keystore.pin
chmod 666 config/sslv101/keystore.pin

Add password to above file. In my case, I have added P@ssw0rd to file. Continue reading “How to Configure OUD to accept SSL using a Self-Signed Certificate”

Advertisements

Sqldeveloper Connection import failed with error oracle.jdevimpl.db.adapter.DatabaseProviderFactory1212

Problem:
Import connections.xml from 12c to 11g environment throws error “Missing class: oracle.jdevimpl.db.adapter.DatabaseProviderFactory1212Continue reading “Sqldeveloper Connection import failed with error oracle.jdevimpl.db.adapter.DatabaseProviderFactory1212”

How to Decrypt SqlDeveloper connections passwords

To recover password we need two files named connections.xml & product-preferences.xml .
Above files can be available in below locations

On Windows :
%APPDATA%SQL Developersystem*o.jdeveloper.db.connection*connections.xml
%APPDATA%SQL Developersystem*o.sqldeveloper*product-preferences.xml

On Linux :
user_home/.sqldeveloper/system/o.sqldeveloper/connections.xml
user_home/.sqldeveloper/system/o.sqldeveloper/product-preferences.xml

Continue reading “How to Decrypt SqlDeveloper connections passwords”