Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> unable to open RPC connection to external procedure agent
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 Wed Jun 26 2002 - 11:56:40 CDT