Re: PL/SQL and external procedures

From: Peter Dickmann <pdickmann_at_de.lhsgroup.com>
Date: Thu, 13 Jan 2000 11:55:11 +0100
Message-ID: <387daf11@news.lhsgroup.com>

Hmm,

now both lowercase, but no success; using TNS_ADMIN set to a local directory containing both listener.ora and tnsnames.ora.

LSNRCTL> start external_procedure_listener Starting /usr/oracle/oracode/8.0.5.1/bin/tnslsnr: please wait...

TNSLSNR for DEC OSF/1 AXP: Version 8.0.5.0.0 - Production System parameter file is /u01/home/perf/tnsadmin/listener.ora Log messages written to
/usr/oracle/oracode/8.0.5.1/network/log/external_procedure_listener.log Listening on: (ADDRESS=(PROTOCOL=ipc)(DEV=7)(KEY=extproc_key))

Connecting to (ADDRESS=(PROTOCOL=ipc)(KEY=extproc_key)) STATUS of the LISTENER

---

Alias                     external_procedure_listener
Version                   TNSLSNR for DEC OSF/1 AXP: Version 8.0.5.0.0 -
Production
Start Date                13-JAN-00 11:44:33
Uptime                    0 days 0 hr. 0 min. 4 sec
Trace Level               off
Security                  OFF
SNMP                      OFF

Listener Parameter File /u01/home/perf/tnsadmin/listener.ora Listener Log File
/usr/oracle/oracode/8.0.5.1/network/log/external_procedure_listener.log Services Summary...
  extproc_agent has 1 service handler(s) The command completed successfully
LSNRCTL> LSNRCTL> services external_procedure_listener Connecting to (ADDRESS=(PROTOCOL=ipc)(KEY=extproc_key)) Services Summary...
  extproc_agent has 1 service handler(s)     DEDICATED SERVER established:0 refused:0       LOCAL SERVER
The command completed successfully
LSNRCTL> Peter

Sybrand Bakker <postmaster_at_sybrandb.demon.nl> wrote in message news:947758966.20074.0.pluto.d4ee154e_at_news.demon.nl...
> Obviously nothing, but you are using different case for the word IPC. That
> has proven to be a problem in previous releases.
> I would also check with lsrnctl80 services, whether it is really listening
> on that protocol.
>
> Hth,
>
> --
> Sybrand Bakker, Oracle DBA
> Peter Dickmann <pdickmann_at_de.lhsgroup.com> wrote in message
> news:387da427_at_news.lhsgroup.com...
> > Hi,
> >
> > I want to call an external procedure from PL/SQL (8.0.5.1 on DEC Unix
> 4.0d).
> > I followed the manual, say, changed the listener.ora and tnsnames.ora,
> > started the external_procedure_listener, built a shared C library
> containing
> > the function, registered the library, and created a PL/SQL package
> > comprising an EXTERN function calling the library function. But when I
> call
> > the PL/SQL via SQL*PLUS, I always receive an error:
> >
> > SQL> select testpack.add(1,2) from dual;
> > select testpack.add(1,2) from dual
> > *
> > ERROR at line 1:
> > ORA-28575: unable to open RPC connection to external procedure agent
> > ORA-06512: at "SYSADM.TESTPACK", line 25
> > ORA-06512: at line 1
> >
> > The tnsnames.ora contains:
> >
> > extproc_connection_data =
> > (DESCRIPTION =
> > (ADDRESS =
> > (PROTOCOL=IPC)
> > (KEY=extproc_key)
> > )
> > (CONNECT_DATA =
> > (SID = extproc_agent)
> > )
> > )
> >
> > And the listener.ora:
> >
> > EXTERNAL_PROCEDURE_LISTENER =
> > (ADDRESS_LIST =
> > (ADDRESS=
> > (PROTOCOL=ipc)
> > (KEY=extproc_key)
> > )
> > )
> > STARTUP_WAIT_TIME_EXTERNAL_PROCEDURE_LISTENER = 0
> > CONNECT_TIMEOUT_EXTERNAL_PROCEDURE_LISTENER = 10
> > TRACE_LEVEL_EXTERNAL_PROCEDURE_LISTENER = OFF
> > SID_LIST_EXTERNAL_PROCEDURE_LISTENER =
> > (SID_LIST =
> > (SID_DESC =
> > (SID_NAME=extproc_agent)
> > (ORACLE_HOME=/usr/oracle/oracode/8.0.5.1)
> > (PROGRAM=extproc)
> > )
> > )
> >
> > Any ideas what's going wrong?
> >
> > Thanx, Peter
> >
> >
> >
>
>
Received on Thu Jan 13 2000 - 04:55:11 CST