In theory all three clients will work with 9iRelease2.
However, we have encountered a problem where the client is 8.0.6, connects
to a 9.2 database which has a database link to an 8.1.7 database -- queries
across the db-link result in an ORA-3120 error. The analyst closed the
TAR has 8.0.6 is
Using clients 9 be ready for a question from someone that connect internal
works with 9i too! :-)
One day a developer came to me and said that contrary to what I had told him
he was able to connect as internal into a 9iR2 test DB, and he showed me.
Later I figured out that he was using 8.0.5
It also depends on the character set being used on the database server.
With 9i, there are a few new character sets.
Older client will probably not be able to deal with these new character
sets.
I think there is a patch for the 8i client to handle new character sets,
however.
HTH,
Gerardo
How were you able to connect INTERNAL or SYS AS SYSDBA
from a remote ORACLE_HOME ? INTERNAL from the same O_H
didn't require a passsword, per the default behaviour. SYS AS SYSDBA
from a remote O_H requires a Password from the password file. Does
your developer has the SYS password ?
Hemant
At