Re: RE: New Listener Question

List, please correct me if I'm wrong, but I understand that you can define local listeners for the dynamic registration process to register with using the init.ora parameter LOCAL_LISTENER. This parameter identifies "local" listeners for the instance via a tnsnames.ora style format. It can contain multiple listener address to register with. For example:

LOCAL_LISTENER = "(ADDRESS_LIST =
(ADDRESS=(PROTOCOL=TCP)(HOST=db01.acme.com)(PORT=1521)) (ADDRESS=(PROTOCOL=TCP)(HOST=db02.acme.com)(PORT=1521))(ADDRESS=(PROTOCOL=TC P)(HOST=db03.acme.com)(PORT=1521)))"

Jon Walthour

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Wednesday, July 18, 2001 3:44 PM

> Alex, you are correct. And that's how it worked in 8.1.6.
> But due to some unknown 'feature' one has to explicitly set th
> service_names and instance_name in the init .ora file as a workaround to
be
> able to use auto-register feature in 8.1.7. Again, only if using the
default
> listener name with default listener port#.. I have not yet tested this
> stuff in 9.0.1 but will do in the very near future.
>
> Regards,
>
> - Kirti Deshpande
> Verizon Information Services
> http://www.superpages.com
>
> > -----Original Message-----
> > From: Hillman, Alex [SMTP:Alex.Hillman_at_usmint.treas.gov]
> > Sent: Wednesday, July 18, 2001 1:52 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: 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
> >
> >
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Deshpande, Kirti
> INET: kirti.deshpande_at_verizon.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).