I thought someone posted that 8.0.5 needs the patch
to 8.0.5.1 fro context to work.
I just got mine going on 8.1.5
In article <3834E598.7187794A_at_usa.net>,
chase.meridian_at_usa.net wrote:
>
> 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:
> (ADDRESS=(PROTOCOL=tcp)(DEV=11)(HOST=192.168.0.138)(PORT=1521))
>
> 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
> Listener Parameter File
> /export/u01/app/oracle/product/8.0.5/network/admin/listener.ora
> Listener Log File
> /export/u01/app/oracle/product/8.0.5/network/log/listener.log
> Services Summary...
> extproc has 1 service handler(s)
> orcl has 1 service handler(s)
> The command completed successfully
>
> ----------------------------------------------------------------------
> ----------------------------------------------------------------------
> ----------------------------------------------------------------------
> on the other machine I get
>
> [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:
> (ADDRESS=(PROTOCOL=tcp)(DEV=11)(HOST=192.168.0.82)(PORT=1521))
>
> 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
> Listener Parameter File
> /u01/app/oracle/product/8.0.5/network/admin/listener.ora
> Listener Log File
> /u01/app/oracle/product/8.0.5/network/log/listener.log
> Services Summary...
> extproc has 1 service handler(s)
> orcl has 1 service handler(s)
> The command completed successfully
>
> ----------------------------------------------------------------------
> ----------------------------------------------------------------------
> -tnsnames.ora---------------------------------------------------------
> extproc_connection_data =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = IPC)(KEY = orcl))
> (CONNECT_DATA = (SID = extproc))
> )
>
> 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 =
> 'ORACLE_HOME=/u01/app/oracle/product/8.0.5,ORACLE_SID=orcl')
> )
> )
> ----------------------------------------------------------------------
> ----------------------------------------------------------------------
> -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))
> )
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (GLOBAL_DBNAME= lindev.intouch.co.za.)
> (ORACLE_HOME= /u01/app/oracle/product/8.0.5)
> (SID_NAME = orcl)
> )
> (SID_DESC =
> (SID_NAME = extproc)
> (ORACLE_HOME = /u01/app/oracle/product/8.0.5)
> (PROGRAM = extproc)
> )
> )
> STARTUP_WAIT_TIME_LISTENER = 0
> CONNECT_TIMEOUT_LISTENER = 10
> TRACE_LEVEL_LISTENER = OFF
> ----------------------------------------------------------------------
> ----------------------------------------------------------------------
> ----------------------------------------------------------------------
>
> "You can learn more about a man in an hour of play than in a year of
> conversation." Plato
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Fri Nov 19 1999 - 07:20:25 CST
