From: anacedent@hotmail.com   
      
   Crowe wrote:   
   > Greetings Everyone:   
   >   
   > Oracle 9i installed on a sun solaris box. No protocol adapters   
   > available.   
   > I would greatly appreciate any help from the db gurus on this forum.   
      
   I've been doing DBA duties on Solaris for the last 5+ years.   
   I have NEVER used netca.   
      
   I start with a working listener.ora file (as below)   
   and then modify it as necessary for any new system.   
      
   ###########   
   # FILENAME: listener.ora   
   # SERVICE.: TCP LISTENER   
   ###########   
   #   
   LISTENER =   
        (ADDRESS_LIST =   
            (ADDRESS =   
              (PROTOCOL = TCP)   
              (HOST = prod)   
              (PORT = 1529)   
            )   
        )   
      
   SID_LIST_LISTENER =   
      (SID_LIST =   
        (SID_DESC =   
          (SID_NAME = MWH)   
          (ORACLE_HOME=/u01/app/oracle/product/7.3.4)   
   		(ENVS='EPC_DISABLED=TRUE')   
        )   
        (SID_DESC =   
          (SID_NAME = STG)   
          (ORACLE_HOME=/u01/app/oracle/product/7.3.4)   
   		(ENVS='EPC_DISABLED=TRUE')   
        )   
   	 (SID_DESC =   
   	   (ORACLE_HOME= /u01/app/oracle/product/9.0.1)   
   	   (SID_NAME = WRK)   
   	 )   
   	 (SID_DESC =   
   	   (ORACLE_HOME= /u03/app/oracle/product/9.2.0)   
   	   (SID_NAME = HDCR)   
   	 )   
   	 (SID_DESC =   
   	   (ORACLE_HOME= /u01/app/oracle/product/9.0.1)   
   	   (SID_NAME = CTI)   
   	 )   
      )   
      
      
   HTH &  YMMV   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)