RE: RE: New Listener Question

instance_name has default value ORACLE_SID and service_name has default value db_name.db_domain - so you do not need to define these parameters for dynamic service registration.

Alex Hillman

-----Original Message-----
Sent: Wednesday, July 18, 2001 2:25 PM
To: Multiple recipients of list ORACLE-L

Actually, it's called dynamic service registration and you need both the INSTANCE_NAME parameter and the SERVICE_NAMES parameter defined in the init.ora. Then, when the instance starts up, it will register the services it supports with the listener(s).

Jon Walthour

>--- Original Message ---
>From: Glenn Travis <c-glenn.travis_at_wcom.com>
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Date: 7/18/01 12:21:24 PM
>

>I disagree. Mine only registers itself if I have the "service_names"
entry
>in the init.ora file. Comment this line out and see what happens...
>
>-----Original Message-----
>Smith
>Sent: Tuesday, July 17, 2001 1:31 PM
>To: Multiple recipients of list ORACLE-L
>
>
>In Oracle 8i a database will self register with the default
listener
>even if you do not have it defined. There are parameters that
you
>can put in your init.ora to prevent this.
>
>-----Original Message-----
>Sent: Tuesday, July 17, 2001 9:35 AM
>To: Multiple recipients of list ORACLE-L
>
>
>First Off, I would like to thank everyone who replied yesterday,
your
>answers were most helpful!
>
>Today, I am facing a new puzzle. I am currently running 3 databases
on a
>server, but only two of them are listed in the listener.ora
(bdw and rcvr).
>If I do a 'lsnrctl status' it shows a listener for all three
databases (bdw
>rcvr and webprod). How is this possible? I have included my
current
>listener.ora and output from 'lsnrctl status' ... Also, people
who access
>these databases go through VIRTUAL ip's, i.e. the box itself
has IP address
>xxx.xxx.xxx.11 the bdw ip is xxx.xxx.xxx.31 and the webprod
ip is
>xxx.xxx.xxx.30
>The reason for the virt ip's is for the fail over we have in
place, so
>people do not have to reconfigure their machines when we move
the databases
>around.
>
>So by all rights I do not see how anyone can connect, but they
are?!?!?!?
>WTH???
>
>Thanks again guys ...
>
># LISTENER.ORA Configuration
>File:/apps/oracle/product/816/network/admin/listener.ora
># Generated by Oracle configuration tools.
>
>LISTENER =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
> )
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = bdw1)(PORT = 1521))
> )
> )
> (DESCRIPTION =
> (PROTOCOL_STACK =
> (PRESENTATION = GIOP)
> (SESSION = RAW)
> )
> (ADDRESS = (PROTOCOL = TCP)(HOST = bdw1)(PORT = 2481))
> )
> )
>
>SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = PLSExtProc)
> (ORACLE_HOME = /apps/oracle/product/816)
> (PROGRAM = extproc)
> )
> (SID_DESC =
> (GLOBAL_DBNAME = bdw)
> (ORACLE_HOME = /apps/oracle/product/816)
> (SID_NAME = bdw)
> )
> (SID_DESC =
> (GLOBAL_DBNAME = rcvr)
> (ORACLE_HOME = /apps/oracle/product/816)
> (SID_NAME = rcvr)
> )
> )
>
>oracle_at_bdw1 SID: bdw /apps/oracle/product/816/network/admin
> lsnrctl status
>
>LSNRCTL for Solaris: Version 8.1.6.0.0 - Production on 17-JUL-2001
09:24:30
>
>(c) Copyright 1998, 1999, Oracle Corporation. All rights reserved.
>
>Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
>STATUS of the LISTENER
>------------------------
>Alias LISTENER
>Version TNSLSNR for Solaris: Version 8.1.6.0.0
-
>Production
>Start Date 10-JUL-2001 15:14:01
>Uptime 6 days 18 hr. 10 min. 30 sec
>Trace Level off
>Security OFF
>SNMP OFF
>Listener Parameter File
>/apps/oracle/product/816/network/admin/listener.ora
>Listener Log File /apps/oracle/product/816/network/log/listener.log
>Services Summary...
> PLSExtProc has 1 service handler(s)
> WEBPROD has 2 service handler(s)
> bdw has 1 service handler(s)
> bdw has 1 service handler(s)
> rcvr has 1 service handler(s)
>The command completed successfully
>
>----------------------------------------------
>Edward W. Carr
>UNIX Systems Administrator
>Qwest Communications
>Broadband Services Inc.
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Kimberly Smith
> INET: kimberly.smith_at_gmd.fujitsu.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
>(or the name of mailing list you want to be removed from).
You may
>also send the HELP command for other information (like subscribing).
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Glenn Travis
> INET: c-glenn.travis_at_wcom.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
>(or the name of mailing list you want to be removed from).
You may
>also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jon Walthour
  INET: jonw_at_fuse.net

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
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hillman, Alex
  INET: Alex.Hillman_at_usmint.treas.gov

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
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).