oracle 9.2.0.7 connect issue
497150Dec 19 2007 — edited Dec 20 2007I have 2 client with 2 different homes - one 9.2.0.7 and one with 10.2.0.2.
Lately I had to change the domain name, and changes the TNSNAMES file - made 1 file and pasted the same into the 2 network/admin directories.
Oracle 10g client works fine, but 9i client doesn't. I could tnsping the database but cannot stat sqlplus. Getting the error below.
Tried to reconfigure with netca - getting the same error there...
Before the domain change both clients were workign fine.
Not using sqlnet.ora files (all commented inside)
Any help on how to troubleshoot the problem will be helpful.
Thanks a lot, mj
ERROR: ORA-12154: TNS:could not resolve service name