You are right, sir! I stand corrected. and thanks!
-----Original Message-----
Wilton
Sent: Wednesday, July 18, 2001 1:48 PM
To: Multiple recipients of list ORACLE-L
On Wed, 18 Jul 2001, Glenn Travis wrote:
> 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...
Actually, the parameter that controls instance registration with
listeners for dedicated server is LOCAL_LISTENER. The default value
for this parameter is "(ADDRESS = (PROTOCOL=TCP)(HOST=)(PORT=1521))."
That means that even if you don't set LOCAL_LISTENER, any instance
will try to register with any listener running on port 1521 on the
localhost.
SERVICE_NAMES allows you to specify multiple differently named
databases as a single 'service' for clients, but does not change which
listeners the instance registers with.
This information can be found in TFM, at the following URLs:
http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/
a76961/ch176.htm
http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/network.817
/a76933/concepts.htm#1036732
>From the "Net8 Administrator's Guide, Release 8.1.6:"
"By default, PMON registers with the local listener on server at the
default local address of TCP/IP, port 1521."
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
>
> -----Original Message-----
> Smith
>
> 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.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jeremiah Wilton
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: Glenn Travis
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).
