Re: Help : SQL*NET or config problem

Sounds like a SQL*NET problem, try using SQL*Plus to verify if your SQL*NET i running or not.

Fas

Patricia Rodriguez-Tome <tome_at_ebi.ac.uk> wrote in article <32EE2A15.475D_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?
>
> I had the same kind of error with sybase (but I was only trying isql
> to connect to the database, and an external program for which I do not
> have the src) and the problem was because we had an old version of the
> interfaces files (the equiv of tnsnames.ora) but isql (sybase program)
> didnot have problems with the old version of the file.
>
>
>
> So I am wondering if I could have here the same problem :
> Since I am almost the only one here working from solaris -
> we had just copied the tnsnames.ora file from dec to solaris.
>
> Is that the problem? Is there a specific format for solaris
> different of the others?
> Where should I look to find what is wrong?
>
> Any hints, idea suggestions will be more than welcome
>
> Regards,
>
> Pat R.-Tome
>
> --
> =======================================================================
> Dr. Patricia Rodriguez-Tome | URL: http://www.ebi.ac.uk
> The EMBL Outstation, Hinxton - The European Bioinformatics Institute
> Wellcome Trust genome Campus, Hinxton | Tel: +44 (0)1223 494 409
> Cambridge CB10 1SD, UK | Fax: +44 (0)1223 494 468
> ========================================================================
>
Received on Mon Feb 03 1997 - 00:00:00 CST