ORA-28575:<unable to open RPC connection to external procedure agent> - error when executing external procedure

From: Will Kallander <wkallander_at_geocities.com>
Date: Thu, 1 Jul 1999 16:45:43 -0700
Message-ID: <377bfcdb.0@news.cm2.com>

I've read everything I can get my hands on, including former posts to this list. But I'm still having trouble executing the imgdemo from the ORD demos package.

I get the infernal "ORA-28575: Unable to open RPC connection to external procedure agent"

I've verified that my RPC server is running, and the TNSListener service is running.

What am I doing wrong?

--Will

wkallander_at_geocities.com

Here is my Listener.ora:

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = pangea)(PORT = 1521))
(PROTOCOL_STACK =

        (PRESENTATION = TTC)
        (SESSION = NS)
      )

    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(GLOBAL_DBNAME = mis.lizardtech.com)
(ORACLE_HOME = D:\Oracle\Ora81)
(SID_NAME = MIS)

    )
  )

EXTERNAL_PROCEDURE_LISTENER =
  (ADDRESS_LIST =

       (ADDRESS =
        (PROTOCOL = IPC)
                  (KEY = EXTPROC0)
        )

  )

SID_LIST_EXTERNAL_PROCEDURE_LISTENER =
  (SID_LIST =

        (SID_DESC =
         (SID_NAME = MIS)
                  (ORACLE_HOME = D:\Oracle\Ora81)
                   (PROGRAM = extproc)
         )

  )

and here is my TNSNames.ora:

MIS =
  (DESCRIPTION =
    (SOURCE_ROUTE = OFF)
    (ADDRESS_LIST =
(ADDRESS =

       (PROTOCOL = TCP)
       (HOST = mis.lizardtech.com)
       (PORT = 1521)
      )

    )
    (CONNECT_DATA =
(SID = MIS)
(SERVICE_NAME = mis.lizardtech.com)
    )
  )

extproc_connection_data =
 (DESCRIPTION =

         (ADDRESS =
          (PROTOCOL = IPC)
          (KEY = EXTPROC0)
         )
                (CONNECT_DATA =

   (SID = MIS)
  )
 ) Received on Thu Jul 01 1999 - 18:45:43 CDT