Extproc agent problems

From: Björn-Åke Segrell <pinne_at_pegit.se>
Date: Tue, 01 Feb 2000 23:32:32 +0000
Message-ID: <38976D10.66C6D60B@pegit.se>

Hi,

Oracle 8.0.5 on RH Linux 5.2 w kernel 2.2.13.

I'm having trouble setting up the extproc listener and run the extproc.sql demo
as described in the Oracle on-line manual.

Compiling the .so dll works ok, but I must have something wrong in my configuration.
(Eventhough i just cut'n pasted from the example setup from the manul)

Does anyone have any hints

Regards

#
# Installation Generated Net8 Configuration
# Version Date: Oct-27-97
# Filename: Tnsnames.ora
#

#20000201, Pinne-> commented out
#extproc_connection_data =
# (DESCRIPTION =
# (ADDRESS = (PROTOCOL = IPC)(KEY = PEG1))
# (CONNECT_DATA = (SID = extproc))
# )
#<-

#20000201, Pinne->

extproc_connection_data =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = extproc_key)) (CONNECT_DATA = (SID = extproc_agent)) )
#<-

PEG1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL= TCP)(Host= localhost.localdomain)(Port= 1521))     (CONNECT_DATA = (SID = PEG1))
  )

PEG1_BEQ =
(DESCRIPTION =

    (ADDRESS = (PROTOCOL = BEQ)(PROGRAM = /u01/app/oracle/product/8.0.5)
               (argv0 = oraclePEG1)
               (args = '(DESCRIPTION = (LOCAL=YES)(ADDRESS=(PROTOCOL=BEQ)))')
               (envs = 'ORACLE_HOME=/u01/app/oracle/product/8.0.5,ORACLE_SID=PEG1')

)
)

#
# Installation Generated Net8 Configuration
# Version Date: Jun-17-97
# Filename: Listener.ora
#

# 20000201, Pinne->

EXTERNAL_PROCEDURE_LISTENER =
(ADRESS_LIST =

     (ADRESS = (PROTOCOL=ipc)
               (KEY=extproc_key)
     )

)

SID_LIST_EXTERNAL_PROCEDURE_LISTENER = (SID_LIST =

       (SID_DESC = (SID_NAME=extproc_agent)
                   (ORACLE_HOME=/u01/app/oracle/product/8.0.5)
                   (PROGRAM=extproc)
       )

)

#<-

LISTENER =
(ADDRESS_LIST =

	(ADDRESS= (PROTOCOL= IPC)(KEY= PEG1))
        (ADDRESS= (PROTOCOL= IPC)(KEY= PNPKEY))
        (ADDRESS= (PROTOCOL= TCP)(Host= localhost.localdomain)(Port= 1521))

  )
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =

      (GLOBAL_DBNAME= localhost.localdomain.)
      (ORACLE_HOME= /u01/app/oracle/product/8.0.5)
      (SID_NAME = PEG1)

)
(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

Oracle Server Manager Release 3.0.5.0.0 - Production

Oracle8 Release 8.0.5.0.0 - Production
PL/SQL Release 8.0.5.0.0 - Production

SVRMGR> Connected.
SVRMGR> ORACLE instance started.

Total System Global Area                          4754704 bytes
Fixed Size                                          48400 bytes
Variable Size                                     4222976 bytes
Database Buffers                                   409600 bytes
Redo Buffers                                        73728 bytes

Database mounted.
Database opened.
SVRMGR>
Server Manager complete.

Database "PEG1" warm started.

LSNRCTL for Linux: Version 8.0.5.0.0 - Production on 02-FEB-00 00:11:24

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=PEG1))
Listening on: (ADDRESS=(PROTOCOL=ipc)(DEV=10)(KEY=PNPKEY))
Listening on: (ADDRESS=(PROTOCOL=tcp)(DEV=11)(HOST=127.0.0.1)(PORT=1521))

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=PEG1)) STATUS of the LISTENER

Alias                     listener
Version                   TNSLSNR for Linux: Version 8.0.5.0.0 - Production
Start Date                02-FEB-00 00:11:29
Uptime                    0 days 0 hr. 0 min. 1 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...
  PEG1		has 1 service handler(s)
  extproc		has 1 service handler(s)

The command completed successfully Received on Tue Feb 01 2000 - 17:32:32 CST