Re: unable to open RPC connection to external procedure agent

Hi Everyone,

THanks again for all your suggestions. It just goes to show how great this newsgroup really is. I ended up taking this up with the folks at Oracle support, and after a half day of troubleshooting, they managed to solve this problem (and a few other things :) ). For those of you who would like to see the solution, please email me at khalid_at_nospam.positivelectron.com (remove the nospam). And I will send you a transcript of the support log. Its fairly lengthy (14 pages of conversation).

Cheers!

Khalid.

"Khalid Eidoo" <rogers_at_rogers.com> wrote in message news:3nmS8.3420$ZM3.1186037_at_news20.bellglobal.com...
> I've written a little C application that i'm calling as an external
> procedure. I've successfully compiled and loaded this procedure, however I
> am having a heck of a time trying to execute this procedure. I keep
getting
> the error ORA-28575: unable to open RPC connection to external procedure
> agent, which I from what I understand is a listener configuration problem.
> Can someone please help me configure my listener.ora and tnsnames.ora
files
> so that I can perform trusted callouts?
>
> My ora files are below.
>
> Thanks,
>
> khalid.
>
> # LISTENER.ORA Network Configuration File:
> /home/oracle/config/9.0.1/listener.ora
> # Generated by Oracle configuration tools.
>
> FORSYS =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = forsys.terida.com)(PORT = 1521))
> )
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = IPC)(KEY = blah))
> )
> )
>
> SAVE_CONFIG_ON_STOP_FORSYS = TRUE
>
> SID_LIST_FORSYS =
> (SID_LIST =
> (SID_DESC =
> (GLOBAL_DBNAME = forsys.terida.com)
> (ORACLE_HOME = /opt/oracle/product/9.0.1)
> (SID_NAME = forsys))
> (SID_DESC =
> (SID_NAME=extproc)(ORACLE_HOME=/opt/oracle/product/9.0.1)
> (PROGRAM=extproc))
> )
>
>
> # TNSNAMES.ORA Network Configuration File:
> /home/oracle/config/9.0.1/tnsnames.ora
> # Generated by Oracle configuration tools.
>
> FORSYS =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = terida.forsys.com)(PORT = 1521))
> (ADDRESS = (PROTOCOL = IPC)(Key = EXTPROC))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = forsys)
> )
> )
> extproc_connection_data =
> (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=blah))
> (CONNECT_DATA=(SID=extproc)))
>
>
>
>
>
Received on Thu Jun 27 2002 - 18:58:04 CDT