Re: Connection setup problem and . . .

"Howard J. Rogers" <howardjr_at_www.com> wrote in message news:3a8d955c_at_news.iprimus.com.au...
> 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.

Naturally, I meant tnsnames.ora. Sorry.... too many oras!

HJR
>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 - 17:35:52 CST