External procedure / OCI

From: Jeroen van der Goorbergh <GoorberghJ_at_Logica.com>
Date: Mon, 8 Mar 1999 13:24:43 +0100
Message-ID: <7c0fil$an4@romeo.logica.co.uk>

Hi,

I'm trying to access an external procedure, but unfortunately with not much succes. I get the following error message: ORA-28575: unable to open RPC connection to external procedure agent I checked my Listener.ora and Tnsnames.ora as suggested by TFM but I can't find anything wrong with them.
My Listener.ora contains the following lines:

EXTERNAL_PROCEDURE_LISTENER =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL=TCP)

(KEY = EXTPROC0)
)
)

SID_LIST_EXTERNAL_PROCEDURE_LISTENER =
(SID_LIST =

     (SID_DESC = (SID_NAME = extproc_agent)
                 (ORACLE_HOME = D:\ORANT )
                 (PROGRAM = extproc)
     )

)

And my Tnsnames.ora:

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)

               (KEY = EXTPROC0)
    )
(CONNECT_DATA = (SID = extproc_agent))
  )

Does anyone have some suggestions for me?

Thanks in advance,

Jeroen Received on Mon Mar 08 1999 - 06:24:43 CST