Re: DBDesigner and SQL*Plus: Connection Trouble

Well, I configured the environment variable TNS_ADMIN to point to the folder containing the correct TNSNAMES.ora. DBDesigner still doesn't connect. Neither does SQL*Plus. Is there a way I could know for sure where these programs are looking?

On Apr 28, 1:18 am, sybra..._at_hccnet.nl wrote:
> On 27 Apr 2007 14:34:31 -0700, HugeBob <rnu..._at_gmail.com> wrote:
>
>
>
> >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?
>
> OK, yet again.
>
> You have multiple homes.
> By default each product will use the tnsnames.ora in
> %ORACLE_HOME%\network\admin.
> So
> 1 you are using at least 2 different tnsnames.ora's
> 2 the files in directories named 'sample' are just that and won't be
> used
> 3 you either need to synchronize the tnsnames.ora's manually OR set
> TNS_ADMIN. Oracle looks in the directory pointed to by TNS_ADMIN,
> followed by %ORACLE_HOME%\network\admin and the default directory.
>
> And finally, yes, as this is all documented,you belong to the 99.9
> percent of posters here, that
> a) don't search Google
> b) don't read the documentation. Obviously, the question 'what's
> TNS_ADMIN?' can be answered by the documentation.
>
> This is sooooo boring.
>
> --
> Sybrand Bakker
> Senior Oracle DBA
Received on Thu May 03 2007 - 17:05:05 CEST