Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> ORA-12569 and ORA-12592
I have received two consistent Oracle errors: ORA-12569 and ORA-12592, and would appreciate your opinion on what may have caused them.
Oracle manual has only the following description:
>ORA-12569 TNS: packet checksum failure
>Cause: The data received is not the same as the data sent.
>Action: Atempt the transaction again. If the error is persisten, turn on
tracing and reexecute the operation.
>ORA-12592 TNS: bad packet
>Cause: An ill-formed packet has been detected by the TNS software.
>Action: Not normally visible to user. For further details, turn on
tracing and reexecute the operation. If error persists, contact Worldwide
Customer Support.
Below are extracts from the SQL*Net traces I performed. I used nme.exe, set trace at ADMIN level. - first one from where ORA-12569 occured and second one from ORA12592. The full trace for the ORA12592 error code is attached with this message (file SQLNET87.TRC).
The traces are performed on a Windows 3.1x platform that uses SQL*Net 2.3, Q+E ODBC drivers, and accesses Oracle7 Server 7.2.2.3.0 over an IPX/SPX network.
Please reply by email to wai_at_OpenDataSystems.com I apprepriate any help provided. Thank you.
Benjamin Wai
ODS
>ORA-12569================================================
Writing 17 bytes to ECB(0) pointer 0x48AF:12 for connID 2087
17 bytes to transport
532 bytes from transport
1516 bytes from transport
532 bytes from transport
1516 bytes from transport
532 bytes from transport
1516 bytes from transport
532 bytes from transport
1516 bytes from transport
532 bytes from transport
1516 bytes from transport
532 bytes from transport
1516 bytes from transport
532 bytes from transport
1516 bytes from transport
532 bytes from transport
1516 bytes from transport
sending NSPTMK packet
Writing 11 bytes to ECB(0) pointer 0x48AF:12 for connID 2087
11 bytes to transport
flushing transport
sending NSPTMK packet
Writing 11 bytes to ECB(0) pointer 0x48AF:12 for connID 2087
11 bytes to transport
flushing transport
cmd=1, lcl=0x0
cmd=3, lcl=0x2
2 bytes from transport
6 bytes from transport
-<ERROR>- header checksum error
-<ERROR>- nsres: id=0, op=68, ns=12569, ns2=0; nt[0]=0, nt[1]=0, nt[2]=0
cmd=2, lcl=0x0
-<ERROR>- osnqrs: recieve failed, no reset marker.
disconnecting...
no timer allocated
Writing 10 bytes to ECB(0) pointer 0x48AF:12 for connID 2087
10 bytes to transport
closing transport
global context check-out (from slot 0) complete
>ORA-12592 (file SQLNET87.TRC)========================================
Writing 17 bytes to ECB(0) pointer 0xE2F:12 for connID -18704
17 bytes to transport
532 bytes from transport
1516 bytes from transport
532 bytes from transport
1516 bytes from transport
sending NSPTMK packet
Writing 11 bytes to ECB(0) pointer 0xE2F:12 for connID -18704
11 bytes to transport
flushing transport
sending NSPTMK packet
Writing 11 bytes to ECB(0) pointer 0xE2F:12 for connID -18704
11 bytes to transport
flushing transport
cmd=1, lcl=0x0
cmd=3, lcl=0x2
2 bytes from transport
6 bytes from transport
-<ERROR>- bad packet header (plen=0x0)
-<ERROR>- nsres: id=0, op=68, ns=12592, ns2=0; nt[0]=0, nt[1]=0, nt[2]=0
cmd=2, lcl=0x0
-<ERROR>- osnqrs: recieve failed, no reset marker.
disconnecting...
no timer allocated
Writing 10 bytes to ECB(0) pointer 0xE2F:12 for connID -18704
10 bytes to transport
closing transport
global context check-out (from slot 0) complete
begin 600 Sqlnet87.trc
<encoded_portion_removed>
end
Received on Mon Aug 18 1997 - 00:00:00 CDT
![]() |
![]() |