toad 9.1 toad 9.5 problem with oracle 11g client

toad 9.1 toad 9.5 problem with oracle 11g client

I logged a support ticket at Quest. The support over there is really quick and helpful. In less than a day I got a message back that they were going to try it themselves, it went even to the technical people (development team) and after a few mails of back and for I got this final message: "Unfortunately, it was confirmed by our team's technical lead that Toad version 9.5 only support Oracle server 11g and not Oracle client 11g. My only suggestion for you is to install another client on your machine that is 10gR2 version or lower."

http://dgielis.blogspot.com/2007/11/quest-toad-on-oracle-11g-not-supported.html

ORACLE_HOME

ORACLE_HOME refers to either:

    a directory where the Oracle software is installed; or
    an environment variable pointing to the directory where the Oracle software is installed.


Windows

Check current value:

echo The current ORACLE_HOME is %ORACLE_HOME%

Set the ORACLE_HOME environment variable:

set ORACLE_HOME=C:\oracle\ora10.2

On Windows the ORACLE_HOME may also be stored in the registry:

    HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE
    HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOMEID
    HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ALL_HOMES
    HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services

http://www.orafaq.com/wiki/ORACLE_HOME