Re: TNS:listner Error

Looks like the correct moment to add to your sqlnet.ora on the client

trace_level_client = 16
trace_unique_client = true
trace_directory_client = <any directory>

This will dump *all* info, including all connection attempts, available to a file called sqlnet<nn>.trc in the specified directory.

Hth,
Sybrand Bakker, Oracle DBA

"kush" <kdhakal_at_eline.com> wrote in message news:tnUU5.263$Mx.14117_at_sjc-read.news.verio.net...
> Hi! Thanks for the answer. Actually I am using toad to connect to two
> different oracle database resides on two different solaris box. Right now,
 I
> can connect to one of the box but couldn't connect to the other(getting
 same
> 12514 error). Although I have different oracle homes, I know which one
 Toad
> is using and have placed necessary code in tnsnames.ora file inside oracle
> home/network/admin. So now, this tnsnames.ora file has connection
> code(service name) to connect to two different database on two seperate
> machine. So from the same tnsnames.ora file, I can connect to one of the
 box
> and couldn't connect to another. I have even tried placing TNS_ADMIN key
 in
> every oracle home to point to the oracle home which Toad is using, still
 no
> use. Now, I want to know what should I check next?
> Thanks for the help.
>
> kush
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
> news:8vh43r$4is9e$6_at_ID-62141.news.dfncis.de...
> > It has to be exactly the same.
> > Probably you are not using the tnsnames.ora you think you are using.
 Check
> > for multiple tnsnames.ora on your client and/or try to play with the
 TOAD
> > options to ignore/include NET8.
> >
> > Hth,
> >
> > Sybrand Bakker, Oracle DBA
> >
> > "kush" <kdhakal_at_eline.com> wrote in message
> > news:tRFS5.3057$A26.138329_at_sjc-read.news.verio.net...
> > > Hi all, I just have successfully installed oracle 8i on solaris. Now
 when
 I
> > > tried to connect it through Toad(development tool) from WindowNT it
 gave
 me
> > > following error.
> > >
> > > ORA-12514: TNS:listener could not resolve SERVICE_NAME given in
 connect
> > > descriptor
> > >
> > > I have checked tnsnames.ora file on my(NT) machine and it looks fine.
 My
> > > question is does tnsnames.ora in NT has to be exactly same as
 tnsnames.ora
> > > in Solaris(where the oracle database resides)? even if that is true, I
 tried
> > > that it also and I am getting same error. Do I need to change anything
 on
> > > listener.ora file on Solaris(where the oracle database resides)?.
> > > Any hint will be appreciated. thanks in advance.
> > >
> > > kush
> > >
> > >
> >
> >
>
>
Received on Tue Nov 28 2000 - 17:15:12 CST