Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ORA-12569 and ORA-12592

ORA-12569 and ORA-12592

From: Benjamin Wai <Benjamin_Wai_at_msn.com>
Date: 1997/08/18
Message-ID: <01bcac29$fa469ea0$02015b24@wabash>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US