Re: DBDesigner and SQL*Plus: Connection Trouble

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 03 May 2007 08:14:24 -0700
Message-ID: <1178205262.8992_at_bubbleator.drizzle.com>


[Quoted] HugeBob wrote:

> 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

Start by not top posting. Scroll to the bottom to reply.

Then in your SQLNET.ORA initiate SQLNET tracing. You will find the syntax at http://tahiti.oracle.com or in Morgan's Library, under SQLNET.ORA, at www.psoug.org.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Thu May 03 2007 - 17:14:24 CEST

Original text of this message