An error shown in my trace file

[oracle8]

HI!

Upon opening my alert log this morning, I found out that an error was displayed on my trace file (Shown below). Could anybody explain his/her brilliant ideas on to solve this error.

Thanks

Rommel


pid: 810


*** 2003.12.01.17.10.52.069
*** SESSION ID30.128) 2003.12.01.17.10.49.365
FATAL ERROR IN TWO-TASK SERVER: error = 12571
*** 2003.12.01.17.10.52.119
ksedmp: internal or fatal error
Current SQL statement for this session:
INSERT INTO JNLDETAILS(JNLD_ENTRY#,JNLD_ACNT_CD,JNLD_DEPO_DT,jnld_bank_code,JNLD_DB_AMT,JNLD_CR_AMT,JNLD_JNLH_TRAN#,JNLD_RECON_STAT,JNLD_CREATED_BY,JNLD_DATE_CREATED,JNLD_MODIFIED_BY,JNLD_DATE_MODIFIED) VALUES JNLD_ENTRY#,:JNLD_ACNT_CD,:JNLD_DEPO_DT,:jnld_bank_code,:JNLD_DB_AMT,:JNLD_CR_AMT,:JNLD_JNLH_TRAN#,:JNLD_RECON_STAT,:JNLD_CREATED_BY,:JNLD_DATE_CREATED,:JNLD_MODIFIED_BY,:JNLD_DATE_MODIFIED) RETURNING ROWID,JNLD_ENTRY#,JNLD_ACNT_CD,JNLD_DEPO_DT,jnld_bank_code,JNLD_DB_AMT,JNLD_CR_AMT,JNLD_JNLH_TRAN#,JNLD_RECON_STAT,JNLD_CREATED_BY,JNLD_DATE_CREATED,JNLD_MODIFIED_BY,JNLD_DATE_MODIFIED INTO :13,:14,:15,:16,:17,:18,:19,:20,:21,:22,:23,:24,:25
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
_ksedmp+9e CALLrel _ksedst+0
9DE5EC
_opitsk+cdb CALLrel _ksedmp+0 2
_opiino+4fe CALLrel _opitsk+0 0
_opiodr+4a6 CALLreg 00000000 3C 4
69DFBF8
_opidrv+335 CALLrel _opiodr+0 3C 4
69DFBF8
0
_sou2o+f CALLrel _opidrv+0 3C 4
69DFBF8
_opimai+10c CALLrel _sou2o+0
_OracleThreadStart@4+47e CALLrel _opimai+0 2
69DFE74
77E92CA5 CALLreg 00000000
----- Argument/Register Address Dump -----
Argument/Register addr=69de5ec. Dump of memory from 69DE5AC to 69DE6EC
69DE5A0 00000000 00000003 00000000 65522120 00000033
69DE5C0 00000000 00000003 069DE585 00000001 00000000 00000000 00000000 00000000
69DE5E0 0000001D 0019C920 069DE5FC 009E7F78 009E7F78 009E7F78 009E7F80 009E7F78
69DE600 009E7F78 009E7F78 009E7F78 009E7F80 0019C920 00000000 00000000 00000000
69DE620 0019C920 069DE6D4 007F85BC 069DE638 0000001C 00000000 2A2A2A0A 30303220
69DE640 32312E33 2E31302E 312E3731 32352E30 32332D25 2D252073 25207338 7332332D
69DE660 00310020 00004F48 000000D4 069DE6A0 44393620 34374546 25207300 7332332D
69DE680 342D2520 00000A73 069DE6A0 65522120 00000033 00000000 0019C920 0000000D
69DE6A0 00000020 00000000 00000000 069DFFEC 00000000 069DFE74 00000000 00000001
69DE6C0 00000001 00000000 069DDE34 00000003 069DE6F8 007BB0F3 069DE610 00000000
69DE6E0 0000311B 0019F1B8 00000001
Argument/Register addr=69dfbf8. Dump of memory from 69DFBB8 to 69DFCF8
69DFBA0 069DFBEC 001F0003
69DFBC0 069DFBCC 06A33BD8 002C40E0 00000000 00000000 06000000 00000000 00000000
69DFBE0 00000000 00360034 00000000 00000BB8 069DFC10 77E8865A 069DFD81 FFFFFFFF
69DFC00 00000000 00000001 00000000 069DFE88 77E8A70A 069DFFB4 004027D3 00000002
69DFC20 069DFE74 00CC92D8 77D4A1BB 00CC9764 001A0DD0 00400080 74FD26EF 069DFC88
69DFC40 77F90F39 00400000 00000001 00000009 069DFC64 00000000 44414853 00000000
69DFC60 009E0000 00000002 00C38078 000009EC 069DFC54 000C4004 069DFD0C 77FB80DB
69DFC80 77F90F78 FFFFFFFF 069DFD1C 77F8D26B 00400000 00000002 7FFAD000 7FFDF000
69DFCA0 77F8CBD5 77FCD348 77F834AC 069DFD30 77D4A1BB 00CC9764 00000000 00000000
69DFCC0 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
69DFCE0 00000000 00000000 00000000 00000000 00000000 7FFAD000
Argument/Register addr=69dfe74. Dump of memory from 69DFE34 to 69DFF74
69DFE20 8583F448 8044C083 8583D740
69DFE40 00000000 00000000 00000000 0000001A F326DD14 0000001B 00000001 8583D740
69DFE60 00000010 84BF95C8 06A50021 0000964E 00000287 069DFD74 069DFD81 00000000
69DFE80 84BF95C8 00000010 61726F2A 77617073 65725F6E 5F796C70 6961686B 3630325F
69DFEA0 06002A34 84BF95C8 C4000010 C0300068 F326DC5C 8044A515 8583D740 00000001
69DFEC0 00000004 8584DC28 C00005EC 06A5FFFF 0000001B 00000001 00000010 00000000
69DFEE0 00000001 00000080 8584DC28 C00005EC F326DD44 804B6F5F C0300000 00000202
69DFF00 804B6FA6 F326DD64 069DC5AC 804B6BFB 00001000 00008790 0000017B 0000017E
69DFF20 00000000 00000000 C0502000 8583D740 8499F1A0 00000000 8499F330 F326DC60
69DFF40 00000246 8042D686 80062F00 8499F300 8499F1A0 84AF0888 84B03688 E140B8D0
69DFF60 E140B8D0 00000000 F326DCAC 00000000 8499F330
----- End of Call Stack Trace -----
===================================================

 

[alexhu]

Your best bet is Oracle Support - the 12571 error is actually this

TNS-12571 TNSacket writer failure

Cause: An error occurred during a data send. This message is not normally visible to the user.

In addition, this message could occur when any of the following SQL*Plus commands have been issued:

SHUTDOWN ABORT

SHUTDOWN IMMEDIATE

SHUTDOWN TRANSACTIONAL

Action: For further details, turn on tracing and re-execute the operation. If the error persists, contact Oracle Support Services.

which can be very difficult to trace but see thread759-719565 which has some helpful hints from Santamufasa

Alex