From dgoulet@vicr.com Tue, 14 Aug 2001 10:35:17 -0700 From: dgoulet@vicr.com Date: Tue, 14 Aug 2001 10:35:17 -0700 Subject: Re:external proc listener Message-ID: MIME-Version: 1.0 Content-Type: text/plain Joe, Extproc's are a pain until you get them figured out the first time. Here is a copy of the listener file we use on one of the instances where it does work: SQLNET.AUTHENTICATION_SERVICES = (NONE) LOGGING_LISTENER = OFF USE_PLUG_AND_PLAY_LISTENER = OFF USE_CKPFILE_LISTENER = OFF LISTENER = (ADDRESS_LIST = (ADDRESS= (PROTOCOL=IPC) (KEY= milton2.world) ) (ADDRESS= (PROTOCOL=IPC) (KEY= 02) ) ) callout_listener= ( ADDRESS_LIST = (ADDRESS= (PROTOCOL = IPC) (KEY = extproc_key) ) ) STARTUP_WAIT_TIME_LISTENER = 0 CONNECT_TIMEOUT_LISTENER = 10 TRACE_LEVEL_LISTENER = OFF SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = milton2.world) (SID_NAME = 02) (ORACLE_HOME = /ora1/81632) (PRESPAWN_MAX = 10) ) sid_list_callout_listener = ( SID_LIST = (SID_DESC = (SID_NAME = 11) (PROGRAM = /ora1/81632/bin/extproc) ) ) The tnsnames entry looks like: extproc_connection_data.world = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC) (KEY = extproc_key) ) (CONNECT_DATA = (SID = 11)) ) Hope it helps. Dick Goulet ____________________Reply Separator____________________ Author: "JOE TESTA" Date: 8/14/2001 9:25 AM 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): 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
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 =             & nbsp;  
     (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=        &nb sp;  
 (description=         &nb sp;          
   (address=(protocol=ipc)(key=extproc))       & nbsp;            &nb sp;
   (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
 
 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: dgoulet@vicr.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).