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

Home -> Community -> Usenet -> c.d.o.server -> Re: Will only recognize FIRST listing in TNSNAMES file

Re: Will only recognize FIRST listing in TNSNAMES file

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Thu, 10 Oct 2002 21:34:51 +0200
Message-ID: <ihlbquop28j0rs0f94m4cefs2pse5qhugk@4ax.com>


On 10 Oct 2002 11:07:07 -0700, PrivateBenjamin_at_hushmail.com (April) wrote:

>Strange one,
>
>trying to connect to an Oracle7.3 (I know, I know) db through TOAD or
>a DSN for MS -Access, we are receiving the error "could not resolve
>TNSNAMES". However the correct TNSNAMES are in the file and the same
>file is used successfully by other users.
>
>If the db instance to which we are trying to connect, is put first in
>the file, then the connection works, ONLY and ONLY if the db is first
>in the file?????
>
>Any thoughts,
>thx
>April

You must have syntax errors in your tnsnames.ora. Syntax errors result in ora-12154. Please post your tnsnames.ora file

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Oct 10 2002 - 14:34:51 CDT

Original text of this message

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