Re: Connection setup problem and . . .

If you go into the listener control utility (lsnrctl), and type the word "services", does it say that it is listening for any services, or none?

I bet it's "none" -and I reckon that's because you are using the new 8i feature whereby Instances automatically register themselves with the Listener. That's a neat trick if you can pull it off, but it can be fiddly. You must get listener.ora, host tnsnames.ora and your database's init.ora all working together on this one, and keep re-bouncing your Instance until the Listener reports that it has services handles.

Key parameters in the init.ora are instance_name, service_names and db_domain. Service_names should be instance_name+.+db_domain (ie, if db_domain were BLAH, and instance_name=ORCL, service_names should be ORCL.BLAH (there's a dot in there somewhere!!)

Since the Instance is going to register itself with the Listener, it's fairly obvious that the Listener must be running BEFORE the Instance (otherwise there's nothing to register with!). An Instance bounce should take care of that.

I should warn you that when we train this on 8.1.5, and extra space in one of the host-side tnsnames.ora file's lines causes the Instance to fail to register. Last time, I think that chapter took 2 hours before all the students had it working.

It is MUCH more reliable in 8.1.6 and above (although all my 8.1.6+ databases are running on NT, which might make all the difference).

You could revert to the old way of doing things (which works 100% of the time -usually!) which is to give up on SERVICE_NAME and stick with a SID_LIST in your init.ora. On 8.1.5, I have found that the presence of a SID_LIST when trying for auto-registration causes problems, and the presence of a SERVICE_NAME when trying for the old method of name resolution also causes problems -you should really think of them as mutually exclusive.

The idea of SERVICE_NAME and auto-registration is that since the Listener is aware of what Instances have registered with it, it can load balance and failover... very useful in a Parallel Server environment, but a bit over the top for bog-standard databases.

Regards
HJR "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 Fri Feb 16 2001 - 15:02:16 CST