Listener Configuration in Oracle 9i

[Cherrish Vaidiyan]

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

[Frank]

Re: Listener Configuration in Oracle 9i

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_LI ST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = csdb01.cs.nl)(P ORT = 1521))
)
)
)
Replace csdb01.cs.nl with your server name.
This part knows multiple entries:
SID_LIST_LISTEN ER =
(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_LISTE NER =) may start on pos 1.
--
Regards, Frank van Bortel