By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,870 Members | 1,212 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,870 IT Pros & Developers. It's quick & easy.

Listener Configuration in Oracle 9i

P: n/a
Hello,

Can anyone help me with configuring listener of Oracle 9i DB in Red
Hat Linux 9.I have installed 2 database in a single system.

I am using the default port of 1521 for 1 listener and 1 database
working properly.I have created the second database, should i give the
same port no: to the 2nd listener?????

What should I add in Other services section of Net Manager??

pls help
with Thanx
Cherrish Vaidiyan
Jul 19 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Cherrish Vaidiyan wrote:
Hello,

Can anyone help me with configuring listener of Oracle 9i DB in Red
Hat Linux 9.I have installed 2 database in a single system.

I am using the default port of 1521 for 1 listener and 1 database
working properly.I have created the second database, should i give the
same port no: to the 2nd listener?????

What should I add in Other services section of Net Manager??

pls help
with Thanx
Cherrish Vaidiyan


Yes.
This part only comes once, unless you want multiple ports:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = csdb01.cs.nl)(PORT = 1521))
)
)
)
Replace csdb01.cs.nl with your server name.
This part knows multiple entries:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /opt/oracle/920)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = o920)
(ORACLE_HOME = /opt/oracle/920)
(GLOBAL_DBNAME=o920.csdb01.cs.nl)
)
)
You may repeat the SID_DESC part for all SID's, e.g.:
(SID_DESC =
(SID_NAME = o920)
(ORACLE_HOME = /opt/oracle/920)
(GLOBAL_DBNAME=o920.csdb01.cs.nl)
)
(SID_DESC =
(SID_NAME = o817)
(ORACLE_HOME = /opt/oracle/817)
(GLOBAL_DBNAME=o817.csdb01.cs.nl)
)
etc.
Make sure you leave (at least one) space at the beginning of the
lines - only the 1 line (SID_LIST_LISTENER =) may start on pos 1.
--
Regards, Frank van Bortel

Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.