Restart PL/SQL Developer and you should be able to connect. Under Connection -> Oracle Home, point to the location where you had extracted Instant Client ( C:\instantclient), and under Connection -> OCI library, point to the oci.dll file in the same directory ( C:\instantclient\oci.dll).
Next, configure PL/SQL Developer to use this version by clicking on Tools -> Preferences. To fix this, download the 32-bit version of Oracle Instant Client, extract it to a directory such as C:\instantclient. Restarting all applications should now let you use PL/SQL Developer seamlessly, whilst also defaulting to the 64-bit Oracle home for your weblogic application.
ORACLE_HOME should have C:\OracleHome32 as it's data field in my example) Create the same 4 strings in the second key, with the appropriate changes to the data (e.g. I've called mine KEY_OraClient11g_home1 and KEY_OraClient11g_home2. Keep your preferences in PL/SQL Developer, and make sure you also specify the OCI library (mine is C:\OracleHome32\oci.dll)įinally, using regedit.exe, add a second key under ORACLE ( HKEY_LOCAL_MACHHINE\SOFTWARE\ORACLE). Then set up an Environment Variable, called TNS_ADMIN with the folder that contains your default TNSnames.ora file as the value (for me it is C:\OracleHome\network\admin) You'll need to install the two clients into separate Oracle Home locations, for example I've gone for C:\OracleHome and C:\OracleHome32