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

Home -> Community -> Usenet -> c.d.o.tools -> Re: DBDesigner and SQL*Plus: Connection Trouble

Re: DBDesigner and SQL*Plus: Connection Trouble

From: HugeBob <rnurse_at_gmail.com>
Date: 27 Apr 2007 14:34:31 -0700
Message-ID: <1177709671.375648.216600@s33g2000prh.googlegroups.com>


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 - 16:34:31 CDT

Original text of this message

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