ORA-28575: RPC connection with external procedure cannot opened

From: <Luc.Demanche_at_astrazeneca.com>
Date: Wed, 21 Jan 2004 06:49:25 -0800
Message-ID: <F001.005DDC30.20040121064925@fatcity.com>

Hi DBAs,

Here is my situation, I'm running Oracle8174 on Solaris. We are using an external procedure called in my pl/sql. I'll give you my example:

I will use the Oracle example "DEBUG_EXTPROC" I'm on the Unix server and I connect with SQLPLUS, without the listener

SQL> connect c$mdlimol2
Enter password:
Connected.
SQL> execute debug_extproc.startup_extproc_agent;

PL/SQL procedure successfully completed.

SQL> Everything goes fine....

But when I connect with the listener
SQL> connect c$mdlimol2_at_oratest1
Enter password:
Connected.
SQL> execute debug_extproc.startup_extproc_agent; ....

ERROR at line 1:
ORA-28575: unable to open RPC connection to external procedure agent ...

So the problem could be the listener ... But if a try TNSPING extproc_connection_data, I got OK

Here is the copy of my listener file
SID_LIST_EXTPROCLISTENER =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /disk1/app/oracle/product/8.1.7)
(PROGRAM = /disk1/app/oracle/product/8.1.7/bin/extproc)
    )
  )

EXTPROCLISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =

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

)
)

And tnsnames
EXTPROC_CONNECTION_DATA.CAMRD.ASTRAZENECA.NET=   (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
(SRVR = DEDICATED)

    )
  )

I'm not using MTS

Thank you for you help

Luc

Luc Demanche
AstraZeneca R&D Montreal
Oracle Database Administrator
514.832.3200 x2356

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: Luc.Demanche_at_astrazeneca.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Wed Jan 21 2004 - 08:49:25 CST