oracle-12333错误
Errors in file /oracle/OraHome1/admin/hndw/udump/hndw_ora_17941.trc:
ORA-00600: internal error code, arguments: [12333], [10], [60], [57], [], [], []
, []
12333一般都是跟网络有关,跟数据库影响不大。也就是说一般不会影响数据库性能。
造成ORA-00600 [12333]的主要原因:
1、网络故障。
2、在低级别的传输中出现了丢包和接受的包错误的情况。
3、用户cancel。
4、用户提交了错误的数据(这条可以基本否定,软件开发应当考虑了容错性)
我觉得应该检查一下你的网络
Doc ID:
Note:35928.1
Subject: ORA-600 [12333] "Fatal Two-Task Protocol
Violation"
Type: REFERENCE
Status: PUBLISHED
Content Type: TEXT/PLAIN
Creation Date: 22-MAR-1996
Last Revision Date: 29-OCT-2002
Note: For additional ORA-600 related information please
read [NOTE:146580.1]
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.
相关文章
- Oracle官方并发教程之高级并发对象
- 【ORACLE 导入导出】exp 错误
- 【Python Oracle】使用cx_Oracle 连接oracle的简单介绍
- 【Oracle】TNS-12154 错误解析
- 《oracle每日一练》免安装Oracle客户端使用PL/SQL
- 《oracle每天一练》Oracle之物化视图
- php oracle数据库NCOLB字段ORA-01704
- Oracle 释放flash recovery area的四种方法
- ORACLE查看SQL的执行次数/频率
- oracle常用函数使用大全 Oracle除法(转)
- 安装oracle 11g rac (11.2.03) 出现PRVF-5637 错误
- mysql中的日期转换函数(类似oracle中的to_date)
- 【Oracle 集群】ORACLE DATABASE 11G RAC 知识图文详细教程之RAC 工作原理和相关组件(三)
- 【Oracle 集群】ORACLE DATABASE 11G RAC 知识图文详细教程之集群概念介绍(一)
- cx_Oracle连接oracle数据库
- 2013年7月14日-Java连接Oracle数据库
- Step by step Install Oracle 11gR2(11.2.0.4.0) RAC+Active DataGuard on Oracle Enterprise Linux(OEL6.3X86_64)
- C# 连接Oracle数据库,免安装oracle客户端
- Oracle 记录插入时“Invalid parameter binding ”错误
- Oracle建立表空间和用户
- Oracle中添加虚拟列(emp是oracle自带表)
- linux下用OCI库访问oracle数据库返回错误Cannot create OCI environment!;
- 【Oracle】通过LogMiner实现Oracle数据同步迁移
- 国外DDoS产品的一些调研—— Akamai Arbor Networks Cloudflare DOSarrest F5 Fastly Imperva Link11 Neustar Nexusguard Oracle (Dyn) Radware Verisign