ORA-600 [12333] "Fatal Two-Task Protocol Violation"

PURPOSE:
This article discusses the internal error "ORA-600 [12333]", what it means and possible actions. The information here is only applicable to the versions listed and is provided only for guidance.

ERROR:
ORA-600 [12333][a][.b][c][d][e]

VERSIONS:
Versions 7.3.X to 9.X

DESCRIPTION:
There are now two basic usages of OERI(12333):
i. Usage with 3 additional numeric values
ii. Usage with 4 additional values ... new since 8.0.X

ORA-600[12333] is reported with three additional numeric values when a request is being received from a network packet and the request code in the packet is not recognized. The three additional values report the invalid request values received.

The error may have a number of different root causes. For example, a network error may have caused bad data to be received, or the client application may have sent wrong data, or the data in the network buffer may have been overwritten. Since there are many potential causes of this error, it is essential to have a reproducible testcase to correctly diagnose the underlying cause. If operating system network logs are available, it is advisable to check them for evidence of network failures which may indicate network transmission problems.

The second form of the error is "ORA-600[12333][PTI][.b][c][d]", which may be reported when parsing storage options on alter/create of various database objects. The b, c, d arguments identify a specific statement type being parsed.

This form of the error indicates a problem in the sql parser. As common functions are used to parse the storage options of different database objects, this error code is used as a semantic check that the parser has not passed options that are invalid for the statement being parsed.

There is no data corruption as a result of this error. The error results in a process failure.

ARGUMENTS:
i.
Arg [a] TTI Layer Function code received
Arg [.b] Function code
Arg [c] Sequence

ii.
Arg [a] PTI
Arg [.b] prspo_proc_opts
Arg [c] statement type
Arg [d] check identification, e.g., INDEX

FUNCTIONALITY:
USER/ORACLE INTERFACE LAYER

IMPACT:
PROCESS FAILURE
NO DATA CORRUPTION

SUGGESTIONS:
Check networking connections and NLS settings: [NOTE:77442.1].
Please ensure that the issue is reproducible before pursuing with Oracle Support Services.

Known Issues:
Bug 953506: CLIENTS EXPECTING ORA-1405/1406 MAY GET ORA-3106 OR OERI:12333 fixed in 8.0.6.2
Bug 1273347: OERI:12333 CAN OCCUR fixed in 8.1.6.2 and 8.1.7.0 releases
Bug 709582: OERI:12333 DURING SHUTDOWM IMMEDIATE WHEN USING RMAN fixed in 8.1.5.1 and 8.1.6.0 releases.

REFERENCES:
Note:77442.1 ORA_NLS (ORA_NLS32, ORA_NLS33) Environment Variables.