Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> ORA-28575: RPC connection with external procedure cannot opened
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
-- 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