Re: DBDesigner and SQL*Plus: Connection Trouble

On May 3, 11:14 am, DA Morgan <damor..._at_psoug.org> wrote:
> 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 athttp://tahiti.oracle.comor in Morgan's Library, under
> SQLNET.ORA, atwww.psoug.org.
> --
> Daniel A. Morgan
> University of Washington
> damor..._at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org

I'm sorry. I'm not an Oracle guru. I decided to start from scratch and remove my Oracle client and anything else related to Oracle from my system. I checked the registry and removed all references to Oracle from there. I reinstalled the client and related apps. Now, everything in the registry points to this new install as does TNS_ADMIN. There are no TNSNAMES.ORA files anywhere except in the SAMPLE folder. STILL, SQL*Plus and DBDesigner will not connect. Yet [Quoted] [Quoted] all the other Oracle apps work fine. I placed the following in SQLNET.ORA for tracing:

NAMES.DIRECTORY_PATH=(HOSTNAME)
NAMES.DEFAULT_DOMAIN=my.domain.somewhere SQLNET.AUTHENTICATION_SERVICES=(NTS)
LOG_DIRECTORY_CLIENT=C:\ORACLE92\NETWORK\LOG LOG_FILE_CLIENT=sqlnetClient.log

TRACE_DIRECTORY_CLIENT
TRACE_FILE_CLIENT
TRACE_LEVEL_CLIENT=admin
TRACE_UNIQUE_CLIENT=true

Is tracing/logging automatic once it's enabled in the SQLNET.ORA file or is some other client used? I was thinking that when tracing was enabled that results would be automatically placed in the target file. Received on Fri May 04 2007 - 18:17:15 CEST