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" <[EMAIL PROTECTED]>
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:[EMAIL PROTECTED]]
> > 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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
