ORA-28575: unable to open RPC connection to external procedure agent

From: Sebastian Faust <sebastian.faust_at_googlemail.com>
Date: 15 May 2007 08:31:12 -0700
Message-ID: <1179243072.799820.204500@y80g2000hsf.googlegroups.com>

Hi,

since some days we are trying to call an external procedure from oracle 9.2. When calling the procedure from sqlplus, we get the following frustrating error since 2 days: ORA-28575: unable to open RPC connection to external procedure agent.

Our listener.ora has the following structure: LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = TCP)(HOST = se)(PORT = 1521))
      )

    )
  )

EXTPROC_LISTENER =
  (ADDRESS = (PROTOCOL = IPC)(KEY = test_key))

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(GLOBAL_DBNAME = MyDB)
(ORACLE_HOME = /opt/oracle/9.2.0)
(SID_NAME= MyDB_SID)

    )
  )

SID_LIST_EXTPROC_LISTENER =
    (SID_DESC =
(SID_NAME = test_SID)
(ORACLE_HOME = /opt/oracle/9.2.0)
(ENVS="EXTPROC_DLLS=ANY")
(PROGRAM =extproc)

    )

LOG_DIRECTORY_LISTENER=/opt/oracle/9.2.0/network/log

The tnsnames.ora has the following structure: EXTPROC_CONNECTION_DATA =

       (DESCRIPTION =
            (ADDRESS = (PROTOCOL = IPC)(KEY =  test_key))
            (CONNECT_DATA = (SID =  test_SID))
        )

EXTPROC_CONNECTION_DATA.test.se =
       (DESCRIPTION =
            (ADDRESS = (PROTOCOL = IPC)(KEY =  test_key))
            (CONNECT_DATA = (SID =  test_SID))
        )

We created the function with:
CREATE OR REPLACE FUNCTION shell(cmd IN VARCHAR2)  RETURN PLS_INTEGER
AS
  LANGUAGE C LIBRARY extprocshell_lib
  NAME "extprocsh"
  PARAMETERS (cmd STRING, RETURN INT);
/

and the library with
CREATE OR REPLACE LIBRARY extprocshell_lib

   AS '/opt/oracle/9.2.0/lib/proceduresso';

Does anyone has an idea what's going wrong here?

Thanks in advance!
Sebastian Received on Tue May 15 2007 - 10:31:12 CDT