RE: external proc listener

From: JOE TESTA <JTESTA_at_longaberger.com>
Date: Tue, 14 Aug 2001 10:57:45 -0700
Message-ID: <F001.0036A301.20010814111230@fatcity.com>

thanks a bunch that was it.  and to think i trusted the oracle docs for an example, doooooh, i should know better.  
someone smack me, i'm sure there are enough of you out there who'd like to :)
 
joe
>>> kgel_at_ppoone.com 08/14/01 02:27PM
>>>
Joe;
  Shouldn't the KEY match
the SID_NAME ???

  <FONT face=Tahoma
  size=2>EXTERNAL_PROCEDURE_LISTENER= 
(ADDRESS_LIST=       
(ADDRESS=         
(PROTOCOL=IPC)         
(KEY=extproc)<SPAN

  class=370131917-14082001>            <======             ) 

  )SID_LIST_EXTERNAL_PROCEDURE_LISTENER=  

(SID_LIST=    (SID_DESC=     
(SID_NAME=extproc)<SPAN

  class=370131917-14082001>                <=======      

(ORACLE_HOME=/u03/home/oracle/product/8.0.5)     
(PROGRAM=extproc)<FONT

  face="MS Sans Serif" size=1><FONT face="MS Sans Serif"   size=1>

   
  <FONT
  face="MS Sans Serif" size=1>Your key is extproc and your sid_name is    plsextproc
  <FONT face="MS Sans Serif"
  size=1>-----Original
  Message-----From: JOE TESTA
  [mailto:JTESTA_at_longaberger.com]Sent: Tuesday, August 14, 2001 12:26   PMTo: Multiple recipients of list ORACLE-LSubject:   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.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 - 12:57:45 CDT