rpc problem when calling external procedure

From: Dyrson Rodrigues Alves Junior <dyrson_at_casasoft.com.br>
Date: Thu, 24 Jun 1999 16:59:41 -0400
Message-ID: <37729CC8.6F8FFC92@casasoft.com.br>

Dear gentleman,

I am trying to call an external procedure but I got the following error:

ORA-28576: lost RPC connection to external procedure agent
ORA-06512: at "ALUNO8.SQUARE_DE", line 0
ORA-06512: at line 4

I followed every step described in the bulletin PLSQL:Oracle8 External Procedure Calls. So I donīt understand what is the problem.

I am using HP-UX B.10.20 with Oracle 8.0.4.

The tnsnames.ora and listener.ora of my server are below. Thanks in advance.

# Filename: Tnsnames.ora
#
extproc_connection_data =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = O8))
(CONNECT_DATA = (SID = extproc))

  )

O8 =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL= TCP)(Host= oaec)(Port= 1521))
(CONNECT_DATA = (SID = O8))

  )

# Filename: Listener.ora
#
LISTENER =

  (ADDRESS_LIST =
        (ADDRESS= (PROTOCOL= IPC)(KEY= O8))
        (ADDRESS= (PROTOCOL= IPC)(KEY= PNPKEY))
        (ADDRESS= (PROTOCOL= TCP)(Host= 144.23.10.5)(Port= 1521))
        (ADDRESS= (PROTOCOL= IPC)(KEY= extproc))

  )
SID_LIST_LISTENER =
  (SID_LIST =
(SID_DESC =

      (ORACLE_HOME= /u01/oracle8/product/8.0.4)
      (SID_NAME = O8)

    )
(SID_DESC =

      (SID_NAME = extproc)
      (ORACLE_HOME = /u01/oracle8/product/8.0.4)
      (PROGRAM = extproc)

    )
  )
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 60
TRACE_LEVEL_LISTENER = off

--

+-------------------------------+----------------------------------+
| Dyrson Rodrigues Alves Junior | Casa de Software                 |
| Analista de Sistemas          | Oracle Approved Education Center |
| mailto:dyrson@casasoft.com.br | http://www.casasoft.com.br       |
+-------------------------------+----------------------------------+

Received on Thu Jun 24 1999 - 15:59:41 CDT