Re: TNS:listener Error

Hello,

as you said, you're using 8i on Solaris. 8i has the feature to register a service dynamically with a specific listener. Therefore the instance would have to know which listener to talk to (configure in init.ora) or you have to tell the listener which service it should listen for (probably you've not done that). If you go to netasst and add the service you should be fine.

You could also check this with lsnrctl services MYLISTENER.

• Kai.

> > 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.
 

-- 
Kai Jendrian <kai_at_jendrian.de>
PGP Fingerprint: CB 0D 0C DC 2B 29 E0 E5  CE 1C E5 49 36 59 A3 82