external stored procedure help

From: <yhpeh_at_my-deja.com>
Date: Mon, 16 Aug 1999 03:41:30 GMT
Message-ID: <7p8198$b3n$1@nnrp1.deja.com>

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. Received on Sun Aug 15 1999 - 22:41:30 CDT