Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> extproc and listeners.
Hi
I have 2 linux machines, both installed with oracle 8.0.5. They are both identical wrt tnsnames.ora and listener.ora - barring the host and globaldb name entries (no sqlnet.ora)I am trying to get extproc running on both. Works fine on the one but gives an
"ORA-28575: unable to open RPC connection to external procedure agent "
on the other.
I assume this implies problems with the listener: it appears that the
extproc
listener is not starting up, even though it says that there is a
service handler attached. (as per a lsnrctl start)
I've tried doing a tnsping to extproc_connection_data (reports no listener on machine1, and finds the listener on machine2.
I did not set up the databases originally, and am struggling to see what else could impact.
I don;t know of any other configuration files, and would appreciate any pointers anyone might give.
Thanks
CM
[ oracle_at_devel ~ ]$ lsnrctl start
LSNRCTL for Linux: Version 8.0.5.0.0 - Production on 19-NOV-99 07:39:11
(c) Copyright 1997 Oracle Corporation. All rights reserved.
Starting /export/u01/app/oracle/product/8.0.5/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 8.0.5.0.0 - Production
System parameter file is
/export/u01/app/oracle/product/8.0.5/network/admin/listener.ora
Log messages written to
/export/u01/app/oracle/product/8.0.5/network/log/listener.log
Listening on: (ADDRESS=(PROTOCOL=ipc)(DEV=6)(KEY=orcl)) Listening on: (ADDRESS=(PROTOCOL=ipc)(DEV=10)(KEY=PNPKEY)) Listening on:
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=orcl)) STATUS of the LISTENER
Alias LISTENER Version TNSLSNR for Linux: Version 8.0.5.0.0 - Production Start Date 19-NOV-99 07:39:14 Uptime 0 days 0 hr. 0 min. 0 sec Trace Level off Security OFF SNMP OFF
extproc has 1 service handler(s) orcl has 1 service handler(s)The command completed successfully
[oracle_at_lindev admin]$ lsnrctl stop
LSNRCTL for Linux: Version 8.0.5.0.0 - Production on 19-NOV-99 07:34:24
(c) Copyright 1997 Oracle Corporation. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=orcl))
TNS-12224: TNS:no listener
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=PNPKEY))
TNS-12224: TNS:no listener
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
Connecting to
(ADDRESS=(PROTOCOL=TCP)(Host=mymachine.here.co.za)(Port=1521))
The command completed successfully
[oracle_at_lindev admin]$ lsnrctl start
LSNRCTL for Linux: Version 8.0.5.0.0 - Production on 19-NOV-99 07:34:33
(c) Copyright 1997 Oracle Corporation. All rights reserved.
Starting /u01/app/oracle/product/8.0.5/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 8.0.5.0.0 - Production
System parameter file is
/u01/app/oracle/product/8.0.5/network/admin/listener.ora
Log messages written to
/u01/app/oracle/product/8.0.5/network/log/listener.log
Listening on: (ADDRESS=(PROTOCOL=ipc)(DEV=6)(KEY=orcl)) Listening on: (ADDRESS=(PROTOCOL=ipc)(DEV=10)(KEY=PNPKEY)) Listening on:
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=orcl))
TNS-12224: TNS:no listener
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=PNPKEY))
TNS-12224: TNS:no listener
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
Connecting to
(ADDRESS=(PROTOCOL=TCP)(Host=lindev.intouch.co.za)(Port=1521))
STATUS of the LISTENER
Alias LISTENER Version TNSLSNR for Linux: Version 8.0.5.0.0 - Production Start Date 19-NOV-99 07:34:36 Uptime 0 days 0 hr. 0 min. 6 sec Trace Level off Security OFF SNMP OFF
extproc has 1 service handler(s) orcl has 1 service handler(s)The command completed successfully
-tnsnames.ora----------------------------------------------------------------------extproc_connection_data =
orcl =
(DESCRIPTION =
(ADDRESS = (PROTOCOL= TCP)(Host= mymachine.here.intouch.co.za)(Port=
1521))
(CONNECT_DATA = (SID = orcl))
)
orcl_BEQ =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = BEQ)(PROGRAM = /u01/app/oracle/product/8.0.5) (argv0 = oracleorcl) (args = '(DESCRIPTION = (LOCAL=YES)(ADDRESS=(PROTOCOL=BEQ)))') (envs =
)
)
-listener.ora----------------------------------------------------------------------LISTENER =
(ADDRESS_LIST = (ADDRESS= (PROTOCOL= IPC)(KEY= orcl)) (ADDRESS= (PROTOCOL= IPC)(KEY= PNPKEY)) (ADDRESS= (PROTOCOL= TCP)(Host= mymachine.here.co.za)(Port=1521))
(GLOBAL_DBNAME= lindev.intouch.co.za.) (ORACLE_HOME= /u01/app/oracle/product/8.0.5) (SID_NAME = orcl)
(SID_NAME = extproc) (ORACLE_HOME = /u01/app/oracle/product/8.0.5) (PROGRAM = extproc)
"You can learn more about a man in an hour of play than in a year of
conversation." PlatoReceived on Thu Nov 18 1999 - 23:52:24 CST