Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Use SQL*Plus 10g to connect to 9i databases

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

From: Hemant K Chitale <hkchital_at_singnet.com.sg>
Date: Thu, 14 Sep 2006 21:39:02 +0800
Message-Id: <7.0.1.0.0.20060914213642.01b1fb68@singnet.com.sg>

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

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Sep 14 2006 - 08:39:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US