XPost: comp.database.oracle   
   From: fbortel@nescape.net   
      
   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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)