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

Home -> Community -> Usenet -> c.d.o.misc -> Re: external stored procedure help

Re: external stored procedure help

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Mon, 6 Sep 1999 19:18:47 +0200
Message-ID: <936638379.3395.0.pluto.d4ee154e@news.demon.nl>


You can trace the connection by adding/changing the following lines in sqlnet.ora on the server

trace_level_client = 16
trace_unique_client = true
trace_directory_client = <any directory other than the bin directory>
in listener.ora probably also
trace_level_listener = 16
etc.

This will create a trace file with a deluge of messages, but more often than not it is useful in tracking down the error. I would be interested to learn any results.

Hth,

--
Sybrand Bakker, Oracle DBA

Ferran Foz <ferran.foz_at_technologist.com> wrote in message news:7r0h2n$mco$1_at_nnrp1.deja.com...
> I've got the same problem with Oracle 8.0.5 under Windows NT.
>
> If i run the external procedure 2 times the 2nd time it runs!
>
> How can i trace this? Any idea of the problem?
>
> Thanks!
>
> In article <7p8198$b3n$1_at_nnrp1.deja.com>,
> yhpeh_at_my-deja.com wrote:
> > Hi,
> > I have tried to run a simple external stored procedure in Oracle
> > 8.0.5 for Solaris 2.6. I keep getting the following error. Any help is
> > apreciated.
> >
> > ORA-28575: unable to open RPC connection to external procedure agent
> >
> > The configuration of listener.ora & tnsnames.ora is as follows:
> >
> > listener.ora
> > -------------
> > LISTENER =
> > (ADDRESS_LIST =
> > (ADDRESS= (PROTOCOL= TCP)(Host= singemsd01)(Port= 1521))
> > (ADDRESS= (PROTOCOL= IPC)(KEY= extproc)))
> > )
> > SID_LIST_LISTENER =
> > (SID_LIST =
> > (SID_DESC =
> > (ORACLE_HOME= /app/oracle/product/8.0.5)
> > (SID_NAME = GEM2)
> > )
> > (SID_DESC =
> > (SID_NAME = extproc)
> > (ORACLE_HOME = /app/oracle/product/8.0.5)
> > (PROGRAM = extproc)
> > )
> > )
> > STARTUP_WAIT_TIME_LISTENER = 0
> > CONNECT_TIMEOUT_LISTENER = 10
> > TRACE_LEVEL_LISTENER = OFF
> >
> > tnsnames.ora
> > ------------
> > extproc_connection_data.world =
> > (DESCRIPTION =
> > (ADDRESS = (PROTOCOL = IPC)
> > (KEY = GEM2)
> > )
> > (CONNECT_DATA = (SID = extproc))
> > )
> >
> > GEM2 =
> > (DESCRIPTION =
> > (ADDRESS = (PROTOCOL= TCP)(Host= singemsd01)(Port= 1521))
> > (CONNECT_DATA = (SID = GEM2))
> > )
> >
> > GEM2_BEQ =
> > (DESCRIPTION =
> > (ADDRESS = (PROTOCOL = BEQ)(PROGRAM = /app/oracle/product/8.0.5)
> > (argv0 = oracleGEM2)
> > (args = '(DESCRIPTION = (LOCAL=YES)(ADDRESS=
> > (PROTOCOL=BEQ)))')
> > (envs =
> > 'ORACLE_HOME=/app/oracle/product/8.0.5,ORACLE_SID=GEM2')
> > )
> > )
> >
> > When I checked the listener status, both GEM2 and extproc services are
> > started successfully. But Oracle will complain RPC connection error
> > whenever run the external store procedure. I have been tinkering with
> > the ora files for a few days with no results. The test program is as
> > follows:
> >
> > square.c
> > --------
> > #include <stdio.h>
> >
> > int square(int square) {
> > return x*x;
> > }
> >
> > create library squarelib as '/usr/home/yhpeh/square.so'
> >
> > create function square_of(x binary_integer) return binary_integer as
> > external library squarelib name "square" language C;
> >
> > Rgds,
> > yew hock
> >
> > Sent via Deja.com http://www.deja.com/
> > Share what you know. Learn what you don't.
> >
>
> --
> -- Ferran Foz mailto:ferran.foz_at_technologist.com
> -- STE Consulting, SA http://www.ste.es
>
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Mon Sep 06 1999 - 12:18:47 CDT

Original text of this message

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