Re: Connection setup problem and . . .

Usually this means the service_name in tnsnames.ora doesn't match the service_name in listener.ora
You should use either SID= in both files or SERVICE_NAME= in both files, you can't mix them.

Hth,

Sybrand Bakker, Oracle DBA

"Peasant" <uhwotDELETETHIS_at_coldmail.com> wrote in message news:3n6q8tk4hhl7rg6uip2n5uuf60scliqq9m_at_4ax.com...
> OK - got the message problem sorted out - a typo in $ORACLE_HOME
> (wonder how the listener started then ?) Listener is running.
>
> But I'm still getting a connection failure from clients :
>
> Connecting...ORA-12514: TNS:listener could not resolve SERVICE_NAME
> given in connect descriptor
> The test did not succeed.
>
> I've only tried using the SID (dev) as the "Service Name". Any idea
> where I can find what this is supposed to be ?
>
> Peasant
>
>
> On Fri, 16 Feb 2001 11:22:38 +0200, Peasant
> <uhwotDELETETHIS_at_coldmail.com> said:
>
> >I'm having a problem setting up a connection (client side) to an
> >Oracle 8.1.7 server (O/S is RedHat 6.2).
> >
> >We previously used the 8.0.4 client which was simple enough to set up
> >(server name, port #, and SID). Connections works.
> >
> >Another machine here has the 8.1.7 client installed, and it doesn't
> >ask me for the SID, but asks for "Service Name". What is the service
> >name ? I tried using the SID in there, but the connection fails
> >(complains about the listener). So I check out the listener. Entry is
> >in /etc/services (listener 1521/tcp), but when I try start or check
> >the status of the listener (./bin/lsnrctl status) it complains about a
> >bunch of messages it cannot find :
> >
> >
> >LSNRCTL for Linux: Version 8.1.7.0.0 - Production on 16-FEB-2001
> >09:19:57
> >
> >(c) Copyright 1998 Oracle Corporation. All rights reserved.
> >
> >Message 1053 not found; No message file for product=network,
> >facility=TNSTNS-12541: Message 12541 not found; No message file for
> >product=network, facility=TNS
> > TNS-12560: Message 12560 not found; No message file for
> >product=network, facility=TNS
> > TNS-00511: Message 511 not found; No message file for
> >product=network, facility=TNS
> > Linux Error: 2: No such file or directory
> >Message 1053 not found; No message file for product=network,
> >facility=TNSMessage 1020 not found; No message file for
> >product=network, facility=TNSMessage 1021 not found; No message file
> >for product=network, facility=TNSMessage 1022 not found; No message
> >file for product=network, facility=TNSMessage 1023 not found; No
> >message file for product=network, facility=TNSMessage 1026 not found;
> >No message file for product=network, facility=TNSMessage 1034 not
> >found; No message file for product=network, facility=TNSMessage 1024
> >not found; No message file for product=network, facility=TNSMessage
> >1025 not found; No message file for product=network,
> >facility=TNSMessage 1040 not found; No message file for
> >product=network, facility=TNSMessage 1033 not found; No message file
> >for product=network, facility=TNSMessage 1028 not found; No message
> >file for product=network, facility=TNSMessage 1029 not found; No
> >message file for product=network, facility=TNS Message 1039 not
> >found; No message file for product=network, facility=TNS
> > Message 1039 not found; No message file for product=network,
> >facility=TNS
> >Message 1052 not found; No message file for product=network,
> >facility=TNS
> >
> >
> >
> >Anyone know what causes this / how to fix it ? I'm new to Oracle.
> >
> >Peasant
>
Received on Sat Feb 17 2001 - 15:48:27 CST