Re: Error Message

From: Knut Talman <knut.talman_at_mytoys.de>
Date: Mon, 21 Jan 2002 12:45:23 +0100
Message-ID: <3C4BFF53.9A01775F@mytoys.de>

First: http://learn.to/quote

> So how do I specify my SERVICE_NAME??

The SERVICE_NAME given in your tnsnames.ora has no corresponding entry in listener.ora of the referenced server. Check the service name there and change your tnsnames.ora

Check http://technet.oracle.com for further information.

> "Peter Chatterton" <chatt_at_millcomm.com> ¼¶¼g©ó¶l¥ó·s»D
> :DvD28.352$Ii5.239805_at_news20.bellglobal.com...
> > TNS-12514 TNS:listener could not resolve SERVICE_NAME given in connect
> > descriptor
> >
> > Cause: The SERVICE_NAME in the CONNECT_DATA was not found in the
> listener's
> > tables.
> >
> > Action: Check to make sure that the SERVICE_NAME specified is correct.
> >
> > "nifnif2" <nifnif2_at_seed.net.tw> wrote in message
> > news:a2epge$hj8$1_at_news.seed.net.tw...
> > > ORA-12514: Message 12514 not found; product=RDBMS80; facility=ORA
> > >
> > > what does this message mean?

Regards,

Knut Received on Mon Jan 21 2002 - 05:45:23 CST