Re: automatic detection of running sid by listener in 8x

I think if you don't include a service name it won't do service discovery.

Dave Turner

Sorry, don't have time right now to check.

On Tue, 5 Sep 2000, Thapliyal, Deepak wrote:

> actually dan,
>
> i was curious about thye oracle 8x listener feature which automatically
> detects running SID'S and then starts service for them so that clients can
> connect to the sid's using TNS. i was wondering if there is a way to disable
> this so that the SID list is what governs what services are started when the
> listener starts.
>
> TIA
> deepAk
>
> -----Original Message-----
> Sent: Tuesday, September 05, 2000 11:22 AM
> To: 'Thapliyal, Deepak'
>
>
> Not sure what you mean, but the intelligent agent can be stopped with the
> command:
>
> lsnrctl dbsnmp_stop
>
> Of course, it must be started in the first place and does not automatically
> run by default. AFAIK, the intelligent agent is used mainly for handling
> snmp requests from OEM.
>
> ~Dan.
>
>
> -----Original Message-----
> Sent: Tuesday, September 05, 2000 11:13 AM
> To: 'Straub, Dan'; 'Ruth Gramolini'; Paul Vallee; LazyDBA Listserver
> (E-mail)
>
>
> any way i can disable this agent ???
>
> -----Original Message-----
> Sent: Tuesday, September 05, 2000 10:51 AM
> To: 'Ruth Gramolini'; Paul Vallee; LazyDBA Listserver (E-mail)
>
>
> FYI....from the 7.3.4 doc:
>
> Intelligent Agent Discovery Algorithm (UNIX):
>
> At startup, the agent discovers new services on the machine where it is
> installed and creates its configuration files: snmp_ro.ora, snmp_rw.ora, and
> services.ora.
>
> To determine what services are available on its machine (services that the
> agent will manage), the agent uses the following discovery algorithm
>
> 1
> The agent reads the oratab file for values of all the Oracle Homes and
> SIDs. Depending on the platform, the oratab file can be located in either of
> the following two directories:
>
> /etc
> /var/opt/oracle
>
> 2
> Based on the Oracle Homes values found in oratab, the agent reads the
> listener.ora files to determine which databases are serviced by that
> listener.
>
> 3
> The agent also reads the listener.ora files for the global names of those
> databases (GLOBAL_DBNAME parameters).
>
> 4
> If GLOBAL_DBNAME parameters are not found in the listener.ora file, the
> agent searches for tnsnames.ora files in a location set by the TNS_ADMIN
> environment variable.
>
> 5
> If the TNS_ADMIN variable is not set, the agent looks for tnsnames.ora
> files in the standard locations. For example: $ORACLE_HOME/network/admin.
>
> 6
> If tnsnames.ora files are not found, the database aliases are created as
> <SID>_<HOSTNAME>.
>
>
>
> ~Dan.
>
>
> -----Original Message-----
> Sent: Wednesday, August 30, 2000 7:53 AM
> To: Paul Vallee; LazyDBA Listserver (E-mail)
>
>
> Using OEM you can find out all of the attached database but expanding the
> node for the server where the listener is.
> Ruth
> ----- Original Message -----
> To: LazyDBA Listserver (E-mail) <oracledba_at_lazydba.com>
> Sent: Wednesday, August 30, 2000 10:30 AM
>
>
> > Hi all,
> >
> > Is there a way to connect to a listener over the network and receive a
> list
> > of SIDs or services that it supports? Why do I think that either OEM or
> the
> > IA can do this? Do they do it the way I think they might (using TNS calls
> to
> > a listener), or do they do it the easy way, (reading /etc/oratab for
> > example).
> >
> > Thank you,
> > Paul Vallee - vallee@pythian.com - http://www.pythian.com
> > Practice manager, Oracle DBA outsourcing
> >
> >
> > --------
> > If you're bored, then visit the list's website: http://www.lazydba.com
> (updated daily)
> > to unsubscribe, send a blank email to oracledba-unsubscribe_at_quickdoc.co.uk
> > to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk
> >
> >
>
>
> --------
> If you're bored, then visit the list's website: http://www.lazydba.com
> (updated daily)
> to unsubscribe, send a blank email to oracledba-unsubscribe_at_quickdoc.co.uk
> to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk
>
>
>
> --------
> If you're bored, then visit the list's website: http://www.lazydba.com
> (updated daily)
> to unsubscribe, send a blank email to oracledba-unsubscribe_at_quickdoc.co.uk
> to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk
> --
> Author: Thapliyal, Deepak
> INET: DThapliyal_at_ea.com
>
> 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
Received on Tue Sep 05 2000 - 15:01:16 CDT