external proc listener

From: JOE TESTA <JTESTA_at_longaberger.com>
Date: Tue, 14 Aug 2001 09:30:53 -0700
Message-ID: <F001.00369F15.20010814092557@fatcity.com>

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.trcThe listener supports no servicesThe 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
 
Received on Tue Aug 14 2001 - 11:30:53 CDT