Re: Help requested ! Protocol Adapters Missing oracle 9i...

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 Received on Mon Dec 29 2003 - 00:53:04 CET