Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> extproc and listeners.

extproc and listeners.

From: <chase.meridian_at_usa.net>
Date: Fri, 19 Nov 1999 07:52:24 +0200
Message-ID: <3834E598.7187794A@usa.net>

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
Received on Thu Nov 18 1999 - 23:52:24 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US