Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: 10.2 listener won't start on same port as 9.2 listener

RE: 10.2 listener won't start on same port as 9.2 listener

From: Allen, Brandon <Brandon.Allen_at_OneNeck.com>
Date: Tue, 20 Sep 2005 09:31:03 -0700
Message-ID: <04DDF147ED3A0D42B48A48A18D574C4502361616@NT15.oneneck.corp>


"I was talking about if a brand new database was created. The listener.ora file still needs an entry for that database."

No, it doesn't.

Read this (from http://download-west.oracle.com/docs/cd/B10501_01/network.920/a96580/listener.htm#490265):

For Oracle9i and Oracle8i databases, the listener uses the dynamic service information about the database and instance it has received through service registration before using statically configured information in the listener.ora file. Dynamic service registration is configured in the database initialization file. It does not require any configuration in the listener.ora file.

To ensure service registration works properly, the initialization parameter file should contain the following parameters:

SERVICE_NAMES for the database service name INSTANCE_NAME for the instance name
For example:

SERVICE_NAMES=sales.us.acme.com
INSTANCE_NAME=sales

Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Sep 20 2005 - 11:31:32 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US