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: Ferran Foz <ferran.foz_at_technologist.com>
Date: Mon, 06 Sep 1999 13:54:36 GMT
Message-ID: <7r0h2n$mco$1@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 - 08:54:36 CDT

Original text of this message

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