VERIFIED SOLUTION i
X

How to make sure the correct Oracle clients are in the Path, and that they are in the correct order.

UPDATED: September 6, 2017


Whichever oracle client appears first in the windows PATH variable is the one that is used.

Steps to make sure to have the correct client in the PATH:

Step 1) Install both 32b and 64b versions of the Oracle client.
Step 2) Create a “folder link” (using mklink command in dos window) in the C:\Windows\System32 folder called 11gR2 (or whatever version of Oracle being used) to the 64b version
Step 3) Create a “folder link” (using mklink command in dos window) in the C:\Windows\SysWOW64 folder called 11gR2 (or whatever version of Oracle being used) to the 32b version
Step 4) Edit the Windows path variable and remove any existing references to Oracle client folders and replace it with a single reference to C:\Windows\System32\11gR2

An example both of the clients into the following folders:
C:\Oracle\instantclient_11_2_32bit
C:\Oracle\instantclient_11_2_64bit

Then create the following folder links:
C:\Windows\System32\11gR2-> C:\Oracle\instantclient_11_2_64bit
C:\Windows\SysWOW64\11gR2-> C:\Oracle\instantclient_11_2_32bit
(it is important that the link folders have the same name)

Then add C:\Windows\System32\11gR2 to the PATH variable.

It works because the actual path used by C:\Windows\System32 depends on whether the application is 32bit or 64bit so a 64bit application results at C:\Windows\System32\11gR2 whereas a 32bit application will get C:\Windows\SysWOW64\11gR2 so the correct OCI.dll file is used for the correct application.

Environment Details

Product Feature: Installation / Upgrade

Operating System: Windows 2008 64bit

Database: Oracle


 

Downloads

  • No Downloads