How to use a specific Oracle home when I have multiple Oracle homes installed? (4327951)

How can I get Spotlight on Oracle to use a specific Oracle home when I have multiple Oracle homes installed?

RESOLUTION 1:
One possible way to force Spotlight on Oracle to use a specific Oracle home/client is to add the directory path for the oci.dll for that Oracle client/home to the Spotlight on Oracle shortcut on your desktop.

Here are some examples:

"C:\Program Files\Quest Software\Spotlight\Console\Spotlight.exe" ocidll=C:\oracle\ora10gr2_client\bin

"C:\Program Files\Quest Software\Spotlight\Console\Spotlight.exe" ocidll=C:\oracle\product\10.2.0\client_1\BIN

Please see attached screen shot to demonstrate what is being suggested.

RESOLUTION 2:
Another way is to change the PATH variable on your system and put the wanted Oracle Home at the first position:
1. Right-click on my computer and select properties
2. Select the advanced tab and click on Environmental variables
3. Select the PATH variable and edit the variable value to make the wanted oracle  path the first entry in the list

An enhancement request is submitted to get an "Oracle Home Selector" feature that the Oracle Home can be choose for each connection.

It will be implemented in a future release.