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
18.104.22.168 however, if you are running Windows 2000, the highest version
you can install is 22.214.171.124.
Using 11g client in this way, you can connect from Toad to databases
running versions as follows:
126.96.36.199 connects to 11.2, 11.1, 10.2.0.2 or higher and 188.8.131.52 or
higher. Note, 10.1 is not a supported combination for this version of
184.108.40.206 connects to 11.2, 11.1, 10.2.0.2 or higher, 10.1 and 220.127.116.11 or
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 18.104.22.168 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!