Toad World® Forums

Oracle client install for Toad connection for 9i,10g,11g

Hi All

I want to Install Oracle client for Toad connection which will be help me to connect oracle 9i, 10g, and 11g which are exist on different host.

Can anyone suggest me which oracle client I need to install as per computability.

I try to search for solution in existing forum but unable to find.

Thanks In Advance

Gajendra

1 Like

Message from: 6981

YS Also I want to know which is best compitabilty for oracle 9i,10g,11g version
and TOAD version.
Oracle Client supported to TOAD

Thanks in Advance
Gajendra


Historical Messages

Author: Gajendra Bhende
Date: Tue May 24 22:08:34 PDT 2011
YS Also I want to know which is best compitabilty for oracle 9i,10g,11g version
and TOAD version.
Oracle Client supported to TOAD

Thanks in Advance
Gajendra
__

Author: Gajendra Bhende
Date: Tue May 24 20:59:41 PDT 2011

Hi All

I want to Install Oracle client for Toad connection which will be help me to
connect oracle 9i, 10g, and 11g which are exist on different host.

Can anyone suggest me which oracle client I need to install as per
computability.

I try to search for solution in existing forum but unable to find.

Thanks In Advance

Gajendra

__


YS Also I want to know which is best compitabilty for oracle 9i,10g,11g version and TOAD version.
Oracle Client supported to TOAD

Thanks in Advance
Gajendra

Morning Gajendra,

I want to Install Oracle client for Toad connection which will be help
me to connect oracle 9i, 10g, and 11g which are exist on different host.
You are most likely best to install 11g client. The latest version is
11.2.0.2 however, if you are running Windows 2000, the highest version
you can install is 11.1.0.6.

Using 11g client in this way, you can connect from Toad to databases
running versions as follows:

11.2.0.2 connects to 11.2, 11.1, 10.2.0.2 or higher and 9.2.0.4 or
higher. Note, 10.1 is not a supported combination for this version of
client.

11.1.0.6 connects to 11.2, 11.1, 10.2.0.2 or higher, 10.1 and 9.2.0.4 or
higher.

Now, it is possible that the client will still connect to other versions
of Oracle databases, the above are the combinations that Oracle will
support - given proper support contracts etc.

For example, I have been able to get an 8.0.6 client talking to an
Oracle 11.2.0.2 database. It works, until you try and select from a
table which has a column in a data type that is new since 8.0.6 -
timestamp for example. Then it fails miserably!


Cheers,
Norm. [TeamT]