Your problem lies on the server. Check listener.ora. It's the listener,
which is running on your server, that generates the error message.
> -----Original Message-----
> From: Oliver Artelt [SMTP:oli_at_md.transnet.de]
> Sent: 14 November 2000 20:36
> To: Multiple recipients of list ORACLE-L
> Subject: Re: is problem on remote or local database?
>
>
> Hi, to make it clearer: The error message is completely correct, but you
> don't understand it. (I think you use tnsnames)
> 'listener could not resolve SERVICE_NAME given in connect descriptor' it's
>
> meant that your net service name cannot be found in the tnsnames.ora. That
>
> has nothing to do with finding the remote machine in the network. You must
>
> use the FQN of your service that's SID.world or SID.bullshit.com but not
> SID. If you use domainless names, you don't have to give 'world' but the
> dot
> must remain!! Change the row SID= into SID.= .
>
> oli
>
>
> On Monday 13 November 2000 22:15, peter_at_schoenster.com wrote:
> > On 13 Nov 2000, at 21:10, Oliver Artelt wrote:
> > > Hi, in my opinion mysql and oracle aren't comparable in this case.If
> > > you'll find your problem -and tnsping works - try to connect via
> sqlplus
> > > on the client and the server and with the net service name in the
> > > connection string. I think your suggestions are wrong -Probably it
> could
> > > really not resolve the net service name because your tnsnames.ora are
> > > wrong. If you do tnsnames check the FQN of the net service name. Man,
> > > that's not mysql!!!
> > >
> > :) ... certainly mysql is not oracle. My point was that mysql tells
> >
> > me where the problem is, but oracle does not. Oracle's error
> > message appears too generic. I find it odd (but then I'm ignorant)
> > that oracle can resolve the name when using tnsping but not when
> > using sqlpus.
> >
> > SID =
> > (DESCRIPTION =
> > (ADDRESS_LIST =
> > (ADDRESS = (PROTOCOL = TCP)
> > (HOST = hostname)
> > (PORT = 1521))
> > )
> > (CONNECT_DATA =
> > (SERVICE_NAME = SID)
> > )
> > )
> >
> > I took out SID and hostname of course. When I do tnsping
> >
> > > Sun Microsystems Inc. SunOS 5.8 Generic February 2000
> > >
> > > > tnsping SID
> > >
> > > TNS Ping Utility for Intel SVR4 UNIX: Version 8.1.5.0.0 - Production
> > > on 13-NOV-00 12:24:17
> > >
> > > (c) Copyright 1997 Oracle Corporation. All rights reserved.
> > >
> > > Attempting to contact
> > > (ADDRESS=(PROTOCOL=TCP)(HOST=hostname)(PORT=1521)) OK (800
> > > msec) >
> >
> > (please note, SID and hostname represent real values). So it
> > resolves the hostname when I use tnsping. When I do ... Wait, wait
> > .... here must be the answer ...
> >
> > ORA-12514: TNS:listener could not resolve SERVICE_NAME given
> > in connect descriptor
> >
> > TNS:listener must be on the remote oracle server ... and
> > SERVICE_NAME is the SID ... it is telling me that there is not
> > database called SID (actually the value I use for SID).
> >
> > TNS:listener is not on my client machine ... it is on the remote
> > machine.
> >
> > I think this must be it. If I had used the wrong hostname for HOST
> > then even tnsping would not have worked (or by accident ...
> > perhaps I found some other oracle server that responded:) but
> > because I do have a good hostname it responds ... but my SID
> > does not correspond to a known database on the remote server ...
> >
> > Peter
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > ---------------------------
> > "Reality is that which, when you stop believing in it, doesn't go
> > away".
> > -- Philip K. Dick
>
> --
> ---
>
> Oliver Artelt, System- und Datenbankadministration
> ---------------------------------------------------------------
> cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg
> telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19
> email: oli@cubeoffice.de # web: http://www.cubeoffice.de
> ---------------------------------------------------------------
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Oliver Artelt
> INET: oli_at_md.transnet.de
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Tue Nov 14 2000 - 14:37:15 CST
