Re:external proc listener

From: <dgoulet_at_vicr.com>
Date: Tue, 14 Aug 2001 10:35:17 -0700
Message-ID: <F001.0036A1D7.20010814103707@fatcity.com>

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" <JTESTA_at_longaberger.com>
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):

<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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=windows-1252">
<META content="MSHTML 5.50.4522.1800" name=GENERATOR></HEAD>
<BODY style="MARGIN-TOP: 2px; FONT: 8pt MS Sans Serif; MARGIN-LEFT: 2px">
<DIV><FONT size=1>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.</FONT></DIV>

<DIV><FONT size=1></FONT>&nbsp;</DIV>
<DIV><FONT size=1>here is my listener.ora</FONT></DIV>
<DIV><FONT size=1></FONT>&nbsp;</DIV>
<DIV><FONT size=1>LISTENER_EXTPROC=<BR>&nbsp;&nbsp;&nbsp; (ADDRESS = (PROTOCOL =

IPC) (KEY = extproc))</FONT></DIV>
<DIV> </DIV><FONT size=1>
<DIV><BR>SID_LIST_LISTENER_EXTPROC<BR>  (SID_LIST =<BR>    (SID_DESC
=             & nbsp;  
<BR>     (SID_NAME = plsextproc)<BR>    

(ORACLE_HOME = /u151/oracle/product/8.1.7)<BR>     (PROGRAM = EXTPROC)<BR>  ) <BR> )<BR></DIV> <DIV>on startup i get this(which lends me to believe i've got something messed up):</DIV>

<DIV>&nbsp;</DIV>
<DIV>&lt;all of the standard listener stuff&gt; and</DIV>
<DIV>&nbsp;</DIV>
<DIV>Listener Trace File&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

/u151/oracle/product/8.1.7/network/log/listener_extproc.trc<BR>The listener supports no services<BR>The command completed successfully</DIV>

<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<DIV>tnsnames.ora</DIV>
<DIV>extproc_connection_data=&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb

sp;  
<BR> (description=         &nb sp;           <BR>  
(address=(protocol=ipc)(key=extproc))       & nbsp;            &nb sp;

<BR>&nbsp;&nbsp; (connect_data=<BR>&nbsp;&nbsp;&nbsp; (sid=plsextproc))) 
<BR><BR></DIV>
<DIV>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.</DIV>

<DIV>&nbsp;</DIV>
<DIV>thanks, joe</DIV>
<DIV>&nbsp;</DIV></FONT></BODY></HTML>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: dgoulet_at_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_at_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).

Received on Tue Aug 14 2001 - 12:35:17 CDT