Re: External Procedures / OCI

From: Christopher M. Day <christopher.day_at_rdbms.freeserve.co.uk>
Date: Wed, 10 Mar 1999 21:45:38 +0000
Message-ID: <36E6E802.6EB26BC0@rdbms.freeserve.co.uk>

Jeroen,

The protocol you have specified is 'TCP', you need to use 'IPC'. This should now work.(Well, at least you configuration does on my box ;)

Chris.

Jeroen van der Goorbergh wrote:
>
> 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 Wed Mar 10 1999 - 15:45:38 CST