Re: ORA-28575:<unable to open RPC connection to external procedure agent> - error when executing external procedure from PL/SQL

From: <mlgerdts_at_my-dejanews.com>
Date: Wed, 31 Mar 1999 22:13:10 GMT
Message-ID: <7du6le$l3r$1@nnrp1.dejanews.com>

In article <36dfe8e6.4097501_at_192.86.155.100>, tkyte_at_us.oracle.com wrote:

> In the event you hit an 'rpc' error in the next steps (eg: the listner is
> configured wrong), the following might help as well:
>

Working from the sample files given in the previous message in this thread, I have not been able to resolve the RPC error that I am experiencing. I am on Solaris 2.6 with Oracle 8.0.5.

My tnsnames.ora contains:

---

CAE =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = deathstar.cae.wisc.edu)(PORT = 1521))
(CONNECT_DATA = (SID = ORCL))

  )

ORCL =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = tempest)(PORT = 1521))
(CONNECT_DATA = (SID = ORCL))

  )

extproc_connection_data =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL=IPC) (KEY=extproc_key))
(CONNECT_DATA = (SID = extproc))

  )

---

My listener.ora contains:

---

LISTENER =
  (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY=extproc_key))
(ADDRESS = (PROTOCOL = TCP)(HOST = tempest)(PORT = 1521))
  )

SID_LIST_LISTENER =
  (SID_LIST =
(SID_DESC =

      (GLOBAL_DBNAME = tempest.cae.wisc.edu)
      (ORACLE_HOME = /opt/oracle/product/8.0.5)
      (SID_NAME = ORCL)

    )
(SID_DESC =

      (SID_NAME = extproc)
      (ORACLE_HOME = /opt/oracle/product/8.0.5)
      (PROGRAM = extproc)
      (ENVS=DEBUG_MODULES=all,DEBUG_FILE=/tmp/ext_proc.log)

    )
  )

STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10

---

But when I try to call the external procedure...

SQL> select acct.ufc_crypt('abce', 'ab') from dual; select acct.ufc_crypt('abce', 'ab') from dual

       *
ERROR at line 1:

ORA-28575: unable to open RPC connection to external procedure agent
ORA-06512: at "GERDTS.ACCT", line 105
ORA-06512: at line 1

Is there any way that I can verify that the listener is listening? When I change tnsnames.ora and/or listener.ora do I need to restart oracle and/or the listener? (I have been shutting them down between changes, suspecting that it was not really necessary.)

Other than the steps outlined in the PL/SQL Users' Guide, Chapter 10, is there anything else that needs to be done? I have several processes running called ora_*_ORCL (for the ORCL SID, right?). Should there be some running for the extproc SID as well?

Thanks much for any help people have to offer! Mike

--
Mike Gerdts
UNIX Systems Administrator
Computer-Aided Engineering Center
University of Wisconsin - Madison

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Mar 31 1999 - 16:13:10 CST