Re: DBDesigner and SQL*Plus: Connection Trouble

[Quoted] On Apr 27, 3:34 pm, sybra..._at_hccnet.nl wrote:
>
> multiple tnsnames.ora's on the server, TNS_ADMIN not being set.
> Dealt with in this forum over and over and over again.
>
> --
> Sybrand Bakker
> Senior Oracle DBA

Hi Sybrand,

Thanks for responding. I found more than one tnsnames.ora files on the server:

%ORACLE_HOME%\hs\admin\tnsnames.ora.sample  (does this one matter?)
%ORACLE_HOME%\admin\tnsnames.ora
%ORACLE_HOME%\admin\sample\tnsnames.ora

Now, on my client, I found several tnsnames*.bak files along with: C:\oracle\network\admin\sample\tnsnames.ora (does this one matter?) C:\oracle\network\admin\tnsnames.ora
In the registry on my client, I found several branches off Oracle \ALL_HOMES: ID0, ID1 and ID2. ID0\PATH contains S:\...\oracle\network \admin. I checked that folder and there is a TNSNAMES.ORA file there. Could this be the problem?

Would removing/renaming all but D:\oracle\ora92\admin\tnsnames.ora on the server and C:\oracle\network\admin\tnsnames.ora on my client help? Also, what does TNS_ADMIN do and what should it be set to? Received on Fri Apr 27 2007 - 23:34:31 CEST