Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Extproc agent problems
Check your sql*net configuration.
1. Can you tnsping the external procedure? 2. Check the KEY for the listener matches the KEY in tnsnames.ora 3. Check the SID for the listener matches the SID in tnsnames.ora
> (CONNECT_DATA = (SID = extproc_agent))
does not match
> (SID_NAME = extproc)
John Russell
jbr_at_johnruss.com
Björn-Åke Segrell wrote:
>
> 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
>
> (c) Copyright 1997, Oracle Corporation. All Rights Reserved.
>
> 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
>
> (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=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
--
Only Web Data, Inc. Phone: 415 591 0200 4 Embarcadero Center, Suite 3700 Fax: 415 591 0300San Francisco CA 94111-4107, USA Email: jbr_at_johnruss.com