Re: Use SQL*Plus 10g to connect to 9i databases

  • From: Hemant K Chitale <hkchital@xxxxxxxxxxxxxx>
  • To: andert@xxxxxxxxx
  • Date: Thu, 14 Sep 2006 21:39:02 +0800


Do you have TNS_ADMIN configured , pointing to some other location, in the registry subtree for your 10g Installation ?


At 08:34 AM Thursday, Stephen Andert wrote:

10g sqlnet.ora

SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

9i sqlnet.ora

SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
Thanks


If I use SQL*Plus for Windows version 9, it works. I copied the tnsnamed.ora from the Ora9 HOME to the Ora10 HOME, so the connect info should be the same.


DB and listener are up.

Thanks for any thoughts.

Stephen


Hemant K Chitale
http://web.singnet.com.sg/~hkchital


-- //www.freelists.org/webpage/oracle-l


Other related posts: