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