External procedure

From: Patrick Li <patli_at_starvision.com>
Date: Thu, 14 Jan 1999 11:34:43 -0800
Message-ID: <369E46D3.35479CC0@starvision.com>

Hi,

I am trying to use the External PL/SQL procedure for an Oracle 8 database on Unix
but I ran into problems trying to configure the listener.ora and tnsnames.ora files.

I successfully built the extproc.so using the make script that came with the Oracle 8
software but I kept running into this error when executing the external PL/SQL
procedure from sqlplus.

ORA_28575: unable to open RPC connection to extenal procedure agent.'

According to the Oracle documnet, the problem above is caused by incorrect
configuration on the listener.ora and tnsname.ora files. The host name on my
system is called godzilla and the SID is called oracle1

My listener.ora and tnsnames.ora are:

listener.ora

LISTENER =

  (ADDRESS_LIST =
        (ADDRESS= (PROTOCOL= IPC)(KEY= oracle1))
        (ADDRESS= (PROTOCOL= IPC)(KEY= PNPKEY))
        (ADDRESS= (PROTOCOL= TCP)(Host= godzilla)(Port= 1521))
        (ADDRESS= (PROTOCOL= IPC)(KEY= extproc0))

  )
SID_LIST_LISTENER =
  (SID_LIST =
(SID_DESC =

      (GLOBAL_DBNAME= godzilla)
      (ORACLE_HOME= /opt/oracle/product/8.0.4)
      (SID_NAME = oracle1)

    )
(SID_DESC =

      (SID_NAME = extproc)
      (PROGRAM = extproc)

    )
  )
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = ADMIN and the tnsname.ora is

NET1 =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(Host = godzilla)(Port = 1521))
(CONNECT_DATA = (SID = oracle1))

  )

GODZILLA =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = godzilla)(PORT = 1521))
(CONNECT_DATA = (SID = oracle1))

  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = oracle1))
(CONNECT_DATA = (SID = extproc))
(SOURCE_ROUTE = YES)

  )

Thanks.
Patrick Received on Thu Jan 14 1999 - 13:34:43 CST