Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> automatic detection of running sid by listener in 8x
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-----
From: Straub, Dan [mailto:Dan.Straub_at_hboc.com]
Sent: Tuesday, September 05, 2000 11:22 AM
To: 'Thapliyal, Deepak'
Subject: RE: Interrogate a listener for SIDs?
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-----
From: Thapliyal, Deepak [mailto:DThapliyal_at_ea.com]
Sent: Tuesday, September 05, 2000 11:13 AM
To: 'Straub, Dan'; 'Ruth Gramolini'; Paul Vallee; LazyDBA Listserver
(E-mail)
Subject: RE: Interrogate a listener for SIDs?
any way i can disable this agent ???
-----Original Message-----
From: Straub, Dan [mailto:Dan.Straub_at_hboc.com]
Sent: Tuesday, September 05, 2000 10:51 AM
To: 'Ruth Gramolini'; Paul Vallee; LazyDBA Listserver (E-mail)
Subject: RE: Interrogate a listener for SIDs?
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-----
From: Ruth Gramolini [mailto:rgramolini_at_tax.state.vt.us]
Sent: Wednesday, August 30, 2000 7:53 AM
To: Paul Vallee; LazyDBA Listserver (E-mail)
Subject: Re: Interrogate a listener for SIDs?
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 -----
From: Paul Vallee <dbalist_at_pythian.com>
To: LazyDBA Listserver (E-mail) <oracledba_at_lazydba.com>
Sent: Wednesday, August 30, 2000 10:30 AM
Subject: Interrogate a listener for SIDs?
> 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
>
>
![]() |
![]() |