ORA-28575: unable to open RPC connection to external procedure agent
Hello,
we have a problem with our external procedure agent, when accessing:
ORA-28575: unable to open RPC connection to external procedure agent
TNSNAMES.ORA:
comastest =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ACCELRYS-TEST.MPI-DORTMUND.MPG.DE)(PORT = 1521))
)
(CONNECT_DATA =
(GLOBAL_NAME = comas.accelrys-server.mpi-dortmund.mpg.de)
(INSTANCE_NAME = comas)
(SERVICE_NAME = comas.accelrys-server.mpi-dortmund.mpg.de)
(SID = comas)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
-----
LISTENER.ORA:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /opt/oracle/product/10.2.0/db_1)
(PROGRAM = extproc32)
(ENVS="EXTPROC_DLLS=ANY,LD_LIBRARY_PATH=/opt/oracle/product/10.2.0/db_1/lib32")
)
(SID_DESC =
(ORACLE_HOME = /opt/oracle/product/10.2.0/db_1)
(SID_NAME = comas)
(GLOBAL_DBNAME = comastest.accelrys-server.mpi-dortmund.mpg.de)
)
)
# dynamic service
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = accelrys-test.mpi-dortmund.mpg.de)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
-----
I'm not sure, if there is a mistake in a variable.
The SID is correct. We have named the INSTANCE_NAME as the SID - is that correct, too? Or where can I find the real INSTANCE_NAME?
We set the GLOBAL_NAME to a combination of DB_NAME + DB_DOMAIN - is that correct?
The same is for the SERVICE_NAME - a combination of DB_NAME + DB_DOMAIN. Correct?
The problem is, that it is a copy of a working server so that the DB_NAME + DB_DOMAIN is different from SID and HOSTNAME.
Can the problem be in these configuration files?
-----
The listener is running and I'm able to login with sqlplus and I can connect to the database. But I cannot use extproc.
lsnrctl status
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 11-OCT-2011 08:32:47
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=accelrys-test.mpi-dortmund.mpg.de)(PORT=1521)))
STATUS of the LISTENER
Alias LISTENER
Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production
Start Date 10-OCT-2011 10:25:50
Uptime 0 days 22 hr. 6 min. 57 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /opt/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File /opt/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=accelrys-test.MPI-DORTMUND.MPG.DE)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "comas" has 1 instance(s).
Instance "comas", status UNKNOWN, has 1 handler(s) for this service...
Service "comas.accelrys-server.mpi-dortmund.mpg.de" has 1 instance(s).
Instance "comas", status READY, has 1 handler(s) for this service...
Service "comasXDB.accelrys-server.mpi-dortmund.mpg.de" has 1 instance(s).
Instance "comas", status READY, has 1 handler(s) for this service...
Service "comas_XPT.accelrys-server.mpi-dortmund.mpg.de" has 1 instance(s).
Instance "comas", status READY, has 1 handler(s) for this service...
The command completed successfully
-------
The listener.log shows me the following error when trying to run extproc:
06-OCT-2011 09:10:49 * (CONNECT_DATA=(SID=PLSExtProc)(PRESENTATION=RO)(CID=(PROGRAM=)(HOST=MPI-DORTMUND\M10020-VMXP)(USER=costerma))) * (ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)) * establish * PLSExtProc * 12518
TNS-12518: TNS:listener could not hand off client connection
TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adapter error
TNS-00517: Lost contact
Linux Error: 32: Broken pipe
06-OCT-2011 09:13:10 * service_update * comas * 0
06-OCT-2011 09:15:47 * (CONNECT_DATA=(SID=PLSExtProc)(PRESENTATION=RO)(CID=(PROGRAM=)(HOST=accelrys-test)(USER=root))) * (ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)) * establish * PLSExtProc * 12518
TNS-12518: TNS:listener could not hand off client connection
TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adapter error
TNS-00517: Lost contact
Linux Error: 32: Broken pipe
---------
The listener tracelog shows me following error when trying to run extproc:
[07-OCT-2011 10:53:53:432] nsglhe: entry
[07-OCT-2011 10:53:53:432] nsglhe: Direct handoff errors: ns=12547, ns2=12560
[07-OCT-2011 10:53:53:432] nsrefuse: error exit (nssndrsp)
--------
Any hints?