Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> unable to open RPC connection to external procedure agent

unable to open RPC connection to external procedure agent

From: Khalid Eidoo <rogers_at_rogers.com>
Date: Wed, 26 Jun 2002 12:56:40 -0400
Message-ID: <3nmS8.3420$ZM3.1186037@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 Wed Jun 26 2002 - 11:56:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US