Oracle Database Discussions

I have many Oracle instances on an HP-RISC box, that has HP-UX 11 installed.

I have properly configured listener.ora, tnsnames.ora and sqlnet.ora, according to many docs from Metalink, but I cannot call external procedures because I receive an RPC connection error, according to the messages below.

It is VERY important to solve this problem as soon as possible, since important reports, asked by the government, depends on this feature.


===> The client receives the following error:
ORA-28575: unable to open RPC connection to external procedure agent

===> If the Unix session that is used to start the listener is left opened, I see the following error at the console:
/usr/lib/dld.sl: Unresolved symbol: nlepeget (code) from extprocPLSExtProc

===> Last, the listener log shows the following messages:
TNSLSNR for HPUX: Version 8.1.7.4.0 - Production on 26-JUL-2004 14:44:53
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rjoaxap2)(PORT=4050)))
26-JUL-2004 15:43:03 * (CONNECT_DATA=(SID=PLSExtProc)(PRESENTATION=RO)) * (ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)) * establish * PLSExtProc * 12500
TNS-12500: TNS:listener failed to start a dedicated server process
TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adapter error
TNS-00517: Lost contact
HPUX Error: 32: Broken pipe

I had cut parts of the three configuration files:

================== listener.ora ==================
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = rjoaxap2)(PORT = 4050))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /aplic/oracle/app/product/8.1.7)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = DNXTL01)
(ORACLE_HOME = /aplic/oracle/app/product/8.1.7)
)
)
==================================================
================== tnsnames.ora ==================
EXTPROC_CONNECTION_DATA.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
==================================================
=================== sqlnet.ora ===================
NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)
NAMES.DEFAULT_DOMAIN = WORLD
NAME.DEFAULT_ZONE = WORLD
DISABLE_OOB=ON
==================================================