Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Will only recognize FIRST listing in TNSNAMES file
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