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 [EMAIL PROTECTED]
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
