Re: SQL*NET problem?

Find you sqlnet.ora file, and set the client trace level to ADMIN. This will trace the calls made to SQL*Net as it tries to connect to the application. Check a SQL*Net manual for specifics, and the location of the trace file.

In the trace file you should see what database name, address, host etc your system is using to try to connect. You might also see errors lower down in the error stack that can help pinpoint your problem. Also, run the trace while you use one of the other application you say do connect, to make a comparision.

Jim

Patricia Rodriguez-Tome <tome_at_uranus.ebi.ac.uk> wrote in article <E4oMBz.27E_at_ebi.ac.uk>...
>
> Hello,
>
>
> I have a problem somewhere in my configuration (I suppose) that I cannot
> resolve.
>
> The config :
>
> OS : Solaris 2.5
> Compiler C++ : Sun Workshop 4.2
> Oracle libs : 7.3.2.2
> SQL*NET : V2.2 (i think = the last one?)
>
> My database server is on Digital Unix, same version.
>
> I can connect to that server by using : Oraperl(perl5), oratcl, pro*c
 programs
> that I write. We have bought a product to map c++ classes to relational,
> and if I write programs with their libraries, I can also connect to the
> database
>
> But if I use one program they provide , I get the following error message
:
>
> Oracle Data Dictionary is being read. Please wait...
> [ Oracle LDA Error : Number -12203
> Message: ORA-12203: TNS:unable to connect to destination
> ,offset: 0
>
>
> which for me looks like an sql*net error of not being able to get to the
> server?
Received on Mon Feb 03 1997 - 00:00:00 CST