RE: external proc listener

[Kevin Lange]

Joe;   Shouldn't the KEY match the SID_NAME ??? EXTERNAL_PROCEDURE_LISTENER=   (ADDRESS_LIST=         (ADDRESS=           (PROTOCOL=IPC)           (KEY=extproc)            <======           )   ) SID_LIST_EXTERNAL_PROCEDURE_LISTENER=   (SID_LIST=     (SID_DESC=       (SID_NAME=extproc)                <=======       (ORACLE_HOME=/u03/home/oracle/product/8.0.5)       (PROGRAM=extproc)   Your key is extproc and your sid_name is  plsextproc -----Original Message----- From: JOE TESTA [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 14, 2001 12:26 PM To: Multiple recipients of list ORACLE-L Subject: external proc listener Ok i know i'm doing something wrong here in working with external proc listener as i can even get the stupid demo to work right.   here is my listener.ora   LISTENER_EXTPROC=     (ADDRESS = (PROTOCOL = IPC) (KEY = extproc))   SID_LIST_LISTENER_EXTPROC   (SID_LIST =     (SID_DESC =                      (SID_NAME = plsextproc)      (ORACLE_HOME = /u151/oracle/product/8.1.7)      (PROGRAM = EXTPROC)   )  ) on startup i get this(which lends me to believe i've got something messed up):   <all of the standard listener stuff> and   Listener Trace File       /u151/oracle/product/8.1.7/network/log/listener_extproc.trc The listener supports no services The command completed successfully     tnsnames.ora extproc_connection_data=             (description=                        (address=(protocol=ipc)(key=extproc))                         (connect_data=     (sid=plsextproc))) So what am i missing, i've RTFM, metalink, used what I thought were good examples from multiple places, yet when running the demo in $ORACLE_HOME/plsql/demo, i still get the ORA-28575 error.   thanks, joe