Re: Listener Configuration in Oracle 9i

From: Frank <fbortel_at_nescape.net>
Date: Thu, 04 Dec 2003 20:18:45 +0100
Message-ID: <bqo0qe$80u$1_at_news4.tilbu1.nb.home.nl>

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

Received on Thu Dec 04 2003 - 20:18:45 CET