rpc problem when calling external procedure
From: Dyrson Rodrigues Alves Junior <dyrson_at_casasoft.com.br>
Date: Thu, 24 Jun 1999 16:56:53 -0400
Message-ID: <37729C2C.A5419E82_at_casasoft.com.br>
Dear gentleman,
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
)
(SID_DESC =
)
)
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 60
TRACE_LEVEL_LISTENER = off
Date: Thu, 24 Jun 1999 16:56:53 -0400
Message-ID: <37729C2C.A5419E82_at_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_at_casasoft.com.br | http://www.casasoft.com.br | +-------------------------------+----------------------------------+Received on Thu Jun 24 1999 - 22:56:53 CEST