rendered paste bodyHi All,
When I execute one of the sql install scripts of some other package I
get the following error.
DECLARE
*
ERROR at line 1:
ORA-28575: unable to open RPC connection to external procedure agent
ORA-06512: at line 51
I had attached all .ora files and client log.
-------------------------------------------------------------------
client log
$ cat client.trace_4465.trc
[12-FEB-2007 14:56:22:167] --- TRACE CONFIGURATION INFORMATION FOLLOWS
---
[12-FEB-2007 14:56:22:168] New trace stream
is /home/oracle/client.trace_4465.trc
[12-FEB-2007 14:56:22:168] New trace level is 4
[12-FEB-2007 14:56:22:168] --- TRACE CONFIGURATION INFORMATION ENDS ---
[12-FEB-2007 14:56:22:168] --- PARAMETER SOURCE INFORMATION FOLLOWS ---
[12-FEB-2007 14:56:22:168] Attempted load of system pfile
source /home/oracle/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora
[12-FEB-2007 14:56:22:168] Parameter source loaded successfully
[12-FEB-2007 14:56:22:168]
[12-FEB-2007 14:56:22:168] Attempted load of local pfile
source /home/oracle/.sqlnet.ora
[12-FEB-2007 14:56:22:168] Parameter source was not loaded
[12-FEB-2007 14:56:22:168]
[12-FEB-2007 14:56:22:168] -> PARAMETER TABLE LOAD RESULTS FOLLOW <-
[12-FEB-2007 14:56:22:168] Successful parameter table load
[12-FEB-2007 14:56:22:168] -> PARAMETER TABLE HAS THE FOLLOWING
CONTENTS <-
[12-FEB-2007 14:56:22:168] TRACE_LEVEL_CLIENT = USER
[12-FEB-2007 14:56:22:168] NAMES.DIRECTORY_PATH = (TNSNAMES,
EZCONNECT)
[12-FEB-2007 14:56:22:168] TRACE_DIRECTORY_CLIENT = /home/oracle/
[12-FEB-2007 14:56:22:168] TRACE_FILE_CLIENT = CLIENT.trace
[12-FEB-2007 14:56:22:168] --- PARAMETER SOURCE INFORMATION ENDS ---
[12-FEB-2007 14:56:22:168] --- LOG CONFIGURATION INFORMATION FOLLOWS ---
[12-FEB-2007 14:56:22:168] Log stream will be
"/home/oracle/DSAccord6/sql/sqlnet.log"
[12-FEB-2007 14:56:22:168] Log stream validation not requested
[12-FEB-2007 14:56:22:168] --- LOG CONFIGURATION INFORMATION ENDS ---
[12-FEB-2007 14:56:22:168] nrigbni: Unable to get data from navigation
file tnsnav.ora
[12-FEB-2007 14:56:22:169] nttbnd2addr: ip=loopback specified
[12-FEB-2007 14:56:22:169] nttbnd2addr: using 127.0.0.1
[12-FEB-2007 14:56:22:169] nttbnd2addr: using host IP address: 127.0.0.1
[12-FEB-2007 14:56:22:169] nttcnp: getting sockname
[12-FEB-2007 14:56:22:169] nttcnp: getting peername
[12-FEB-2007 14:56:22:170] niotns: Not trying to enable dead connection
detection.
[12-FEB-2007 14:56:22:170] niotns: Calling address:
(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/home/oracle/oracle/product/10.2.0/db_1/bin/oracle)(ARGV0=oracleorcl)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')(DETACH=NO))(CONNECT_DATA=(CID=(PROGRAM=sqlplus)(HOST=accord.novaglobal.com.sg)(USER=oracle))))
[12-FEB-2007 14:56:22:170] nscall: connecting...
[12-FEB-2007 14:56:22:170] nsc2addr:
(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/home/oracle/oracle/product/10.2.0/db_1/bin/oracle)(ARGV0=oracleorcl)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')(DETACH=NO))(CONNECT_DATA=(CID=(PROGRAM=sqlplus)(HOST=accord.novaglobal.com.sg)(USER=oracle))))
[12-FEB-2007 14:56:22:170] nsopen: opening transport...
[12-FEB-2007 14:56:22:170] sntpcall: not detaching from parent with
additional fork
[12-FEB-2007 14:56:22:171] sntpcall: hdl[IR]=11, hdl[IW]=10
[12-FEB-2007 14:56:22:196] sntpcall: result string is NTP0 4468
[12-FEB-2007 14:56:22:196] nsopen: transport is open
[12-FEB-2007 14:56:22:197] nsnainit: inf->nsinfflg[0]: 0x41
inf->nsinfflg[1]: 0x41
[12-FEB-2007 14:56:22:197] nsopen: global context check-in (to slot 0)
complete
[12-FEB-2007 14:56:22:197] nscon: doing connect handshake...
[12-FEB-2007 14:56:22:197] nscon: sending NSPTCN packet
[12-FEB-2007 14:56:22:197] nscon: sending 267 bytes connect data
[12-FEB-2007 14:56:22:197] nsdo: 267 bytes to NS buffer
[12-FEB-2007 14:56:22:197] nscon: got NSPTAC packet
[12-FEB-2007 14:56:22:197] nscon: connect handshake is complete
[12-FEB-2007 14:56:22:197] nscon: nsctxinf[0]=0x41, [1]=0x41
[12-FEB-2007 14:56:22:197] nsnainconn: inf->nsinfflg[0]: 0x41
inf->nsinfflg[1]: 0x41
[12-FEB-2007 14:56:22:197] nsnasend: bytes to send: 158
[12-FEB-2007 14:56:22:197] nsdo: 158 bytes to NS buffer
[12-FEB-2007 14:56:22:197] nsnareceive: buffer address: 0xbfff516c bytes
wanted: 2048
[12-FEB-2007 14:56:22:198] nsnareceive: calling NS to receive 2048 bytes
into address 0xbfff516c
[12-FEB-2007 14:56:22:198] nsdo: 129 bytes from NS buffer
[12-FEB-2007 14:56:22:198] nsnareceive: received 129 bytes
[12-FEB-2007 14:56:22:198] nsnareceive: no more data to receive -
returning
[12-FEB-2007 14:56:22:198] nsnareceive: total bytes received: 129
[12-FEB-2007 14:56:22:198] nszgwop: SQLNET.WALLET_OVERRIDE not found,
using default.
[12-FEB-2007 14:56:52:981] nstimarmed: no timer allocated
[12-FEB-2007 14:56:52:981] nstoClearTimeout: ATO disabled for
ctx=0x0x80d2f48
[12-FEB-2007 14:56:52:981] nstoClearTimeout: STO disabled for
ctx=0x0x80d2f48
[12-FEB-2007 14:56:52:981] nstoClearTimeout: RTO disabled for
ctx=0x0x80d2f48
[12-FEB-2007 14:56:52:981] nstoClearTimeout: PITO disabled for
ctx=0x0x80d2f48
[12-FEB-2007 14:56:52:981] nstoUpdateActive: Active timeout is -1 (see
nstotyp)
[12-FEB-2007 14:56:52:981] nsclose: closing transport
[12-FEB-2007 14:56:52:981] nsclose: global context check-out (from slot
0) complete
[12-FEB-2007 14:56:52:982] nttbnd2addr: ip=loopback specified
[12-FEB-2007 14:56:52:982] nttbnd2addr: using 127.0.0.1
[12-FEB-2007 14:56:52:982] nttbnd2addr: using host IP address: 127.0.0.1
[12-FEB-2007 14:56:52:982] nttcnp: getting sockname
[12-FEB-2007 14:56:52:982] nttcnp: getting peername
[12-FEB-2007 14:56:52:982] niotns: Not trying to enable dead connection
detection.
[12-FEB-2007 14:56:52:982] niotns: Calling address:
(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/home/oracle/oracle/product/10.2.0/db_1/bin/oracle)(ARGV0=oracleorcl)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')(DETACH=NO))(CONNECT_DATA=(CID=(PROGRAM=sqlplus)(HOST=accord.novaglobal.com.sg)(USER=oracle))))
[12-FEB-2007 14:56:52:982] nscall: connecting...
[12-FEB-2007 14:56:52:982] nsc2addr:
(DESCRIPTION=(ADDRESS=(PROTOCOL=beq)(PROGRAM=/home/oracle/oracle/product/10.2.0/db_1/bin/oracle)(ARGV0=oracleorcl)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')(DETACH=NO))(CONNECT_DATA=(CID=(PROGRAM=sqlplus)(HOST=accord.novaglobal.com.sg)(USER=oracle))))
[12-FEB-2007 14:56:52:982] nsopen: opening transport...
[12-FEB-2007 14:56:52:983] sntpcall: not detaching from parent with
additional fork
[12-FEB-2007 14:56:52:983] sntpcall: hdl[IR]=11, hdl[IW]=10
[12-FEB-2007 14:56:53:009] sntpcall: result string is NTP0 4469
[12-FEB-2007 14:56:53:010] nsopen: transport is open
[12-FEB-2007 14:56:53:010] nsnainit: inf->nsinfflg[0]: 0x41
inf->nsinfflg[1]: 0x41
[12-FEB-2007 14:56:53:010] nsopen: global context check-in (to slot 0)
complete
[12-FEB-2007 14:56:53:010] nscon: doing connect handshake...
[12-FEB-2007 14:56:53:010] nscon: sending NSPTCN packet
[12-FEB-2007 14:56:53:010] nscon: sending 267 bytes connect data
[12-FEB-2007 14:56:53:010] nsdo: 267 bytes to NS buffer
[12-FEB-2007 14:56:53:010] nscon: got NSPTAC packet
[12-FEB-2007 14:56:53:010] nscon: connect handshake is complete
[12-FEB-2007 14:56:53:010] nscon: nsctxinf[0]=0x41, [1]=0x41
[12-FEB-2007 14:56:53:010] nsnainconn: inf->nsinfflg[0]: 0x41
inf->nsinfflg[1]: 0x41
[12-FEB-2007 14:56:53:010] nsnasend: bytes to send: 158
[12-FEB-2007 14:56:53:010] nsdo: 158 bytes to NS buffer
[12-FEB-2007 14:56:53:010] nsnareceive: buffer address: 0xbfff516c bytes
wanted: 2048
[12-FEB-2007 14:56:53:010] nsnareceive: calling NS to receive 2048 bytes
into address 0xbfff516c
[12-FEB-2007 14:56:53:011] nsdo: 129 bytes from NS buffer
[12-FEB-2007 14:56:53:011] nsnareceive: received 129 bytes
[12-FEB-2007 14:56:53:011] nsnareceive: no more data to receive -
returning
[12-FEB-2007 14:56:53:011] nsnareceive: total bytes received: 129
[12-FEB-2007 14:56:53:025] nszgclv: SQLNET.ALLOWED_LOGON_VERSION not
found, using default.
[12-FEB-2007 14:57:30:008] nsrdr: got NSPTMK packet
[12-FEB-2007 14:57:30:008] nioqrc: Recieve: returning error: 3111
[12-FEB-2007 14:57:30:008] nsdo: sending NSPTMK packet
[12-FEB-2007 14:57:30:008] nsrdr: got NSPTMK packet
[12-FEB-2007 14:57:30:008] nserror: nsres: id=0, op=70, ns=12582, ns2=0;
nt[0]=0, nt[1]=0, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
[12-FEB-2007 14:57:30:008] nserror: nsres: id=0, op=70, ns=12630, ns2=0;
nt[0]=0, nt[1]=0, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
[12-FEB-2007 14:57:30:016] nstimarmed: no timer allocated
[12-FEB-2007 14:57:30:016] nstoClearTimeout: ATO disabled for
ctx=0x0x80d2fe8
[12-FEB-2007 14:57:30:016] nstoClearTimeout: STO disabled for
ctx=0x0x80d2fe8
[12-FEB-2007 14:57:30:016] nstoClearTimeout: RTO disabled for
ctx=0x0x80d2fe8
[12-FEB-2007 14:57:30:016] nstoClearTimeout: PITO disabled for
ctx=0x0x80d2fe8
[12-FEB-2007 14:57:30:016] nstoUpdateActive: Active timeout is -1 (see
nstotyp)
[12-FEB-2007 14:57:30:016] nsclose: closing transport
[12-FEB-2007 14:57:30:016] nsclose: global context check-out (from slot
0) complete
----------------------------------------------
sqlnet.ora
$ cat sqlnet.ora
# sqlnet.ora Network Configuration
File: /home/oracle/oracle/product/10.2.0/db_1/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
TRACE_LEVEL_CLIENT = USER
TRACE_FILE_CLIENT = CLIENT.trace
TRACE_DIRECTORY_CLIENT = /home/oracle/
-------------------------------------------------------
listener.ora
$ cat listener.ora
# listener.ora Network Configuration
File: /home/oracle/oracle/product/10.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = orcl)
(ORACLE_HOME = /home/oracle/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
(ENVS = "LD_LIBRARY_PATH=/home/oracle/DSAccord6/lib,
ACCORD_SYSTEM_6=/home/oracle/DSAccord6/system/,
ACCORD_SETTINGS_6=/home/oracle/DSAccord6/accord6.ini,
EXTPROC_DLLS=ANY")
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = accord.novaglobal.com.sg)(PORT
= 1521))
)
)
TRACE_LEVEL_LISTENER = ADMIN
TRACE_FILE_LISTENER = TESTTRC.trace
-----------------------------------------------------------
tnsnames.ora
$ cat tnsnames.ora
# tnsnames.ora Network Configuration
File: /home/oracle/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = accord.novaglobal.com.sg)(PORT =
1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)