ora-600[12333]错误小结及跟踪方法

原创 2004年10月29日 14:00:00
该错误,是当服务器接收到无法识别的网络代码或请求时引起Oracle发出的告警  ,主要原因来自于网络,
与Oracle 本身没有关系。
如果该错误持续出现,建议用以下代码进行跟踪,有可能是病毒引发的:
===========================================
create table
SYSTEM.login_info
( logindatetime date,
LogoffDateTime Date,
LoggedUser Varchar2(30),
SESSIONID Number,
TERMINAL varchar2(20),
ip       varchar2(16),
PROGRAM varchar2(20)
);
--------------------------------------------------------------------
CREATE OR REPLACE TRIGGER logoff_audit Before LOGOFF ON DATABASE
BEGIN
insert into system.login_info
select
'',sysdate,user,sys_context('USERENV','SESSIONID'),sys_context('USERENV'
,'TERMINAL'),utl_inaddr.get_host_address, program from v$session where logon_time = (select
logindatetime from SYSTEM.login_info where SESSIONID=
sys_context('USERENV','SESSIONID'));
END;
---------------------------------------------------------------------
CREATE OR REPLACE TRIGGER logon_audit AFTER LOGON ON DATABASE
BEGIN
insert into system.login_info
select sysdate,null,user,sys_context('USERENV','SESSIONID'),sys_context(
'USERENV','TERMINAL'),utl_inaddr.get_host_address,program from v$session;
END;
==============================================================

其他可能原因:
Typically the ORA-600 [12333] itself is not the problem,
It may be a chance of the underlying network problems
This is usually a client side related issue and is not normally related to server. It is a communications issue and not related to the version of the RDBMS. Thats why you do have this errors intermittently only.

Most occurances of ORA-600 [12333] just means that something has
gone wrong in the communication between the client and the server processes. Often, this could be the result of an abnormal condition (a process is inadvertently killed, or a database shuts down)

The error indicates a protocol communications mismatch

<Note:112660.1>

PURPOSE
-------

This paper describes one known reason of frequent occurence of ORA-600 [12333]
errors.
NOTE: There may exist many other issues however.

SCOPE & APPLICATION
-------------------

Support Analysts and DBAs.


ORA-600 [12333] in case of termination of user sessions
-------------------------------------------------------

ORA-600 [12333] may occur in case of abnormal termination of user
sessions, eg. shutdown immediate, forced disconnections etc.


Frequent ORA-600 [12333] in case of using resource limit
--------------------------------------------------------

Using user profiles and resource_limit=true may cause frequent ORA-600 [12333]occurence. We may also see many SNIPPED session in V$SESSION. For those ones resources are not freed until any server related action is taken at the client side. It seems that ORA-600 [12333] appears while sending ORA-1012 or ORA-2396 messages to the client process.

If we really have to use user profiles to enforce resource limit policies(especially idle time) we'd better proactively remove such sessions.
For now, the only found way preventing from ORA-600 [12333] occurence
caused by resource_limit issue is killing processes related to SNIPPED sessions at OS level. This implies it is applicable only to the DEDICATED server processes. Killing shadow processes for SNIPPED sessions is explained in <Note:96170.1>.

NOTE: Killing shadow processes only decreases the likehood of ORA-600 [12333] occurence. It is a workaround.


Couple of suggestion
=======================

1)Check the network errors, their should be any errors or protocol mismatch

2)Check the NLS settings on client as well as server side settings
ORA_NLS (ORA_NLS32, ORA_NLS33) Environment Variables.

Article-ID: <Note:77442.1>
Title: ORA_NLS (ORA_NLS32, ORA_NLS33) Environment Variables

3)NO users should disconnect abnormally.

TraceView简介和 DDMS工具使用

一、TraceView简介       TraceView是AndroidSDK里面自带的工具,用于对Android的应用程序以及Framework层的代码进行性能分析。       Tr...
  • liu515714312
  • liu515714312
  • 2014年02月27日 10:00
  • 636

Troubleshooting ORA-3137 [12333] Errors Encountered When Using Oracle JDBC Driver (文档 ID 1361107.1)

In this Document   Purpose   Troubleshooting Steps   Known Dat...
  • songyongbo_107
  • songyongbo_107
  • 2016年01月07日 14:17
  • 3325

ORA-00600 [12333]【每日一译】--2012-10-17

Applies to: Oracle Server - Enterprise Edition - Version: 8.1.7.4 to 11.2.0.3 - Release: 8.1.7 to 1...
  • launch_225
  • launch_225
  • 2012年10月16日 11:51
  • 1177

ORA-600(17069)错误的解决过程

在一个报表数据库后台发现了这个错误,详细的错误信息为:Fri Feb 20 08:16:44 2009Errors in file /u1/oracle/admin/repdb01/bdump/rep...
  • w46523173
  • w46523173
  • 2010年04月28日 23:23
  • 1931

UVA 12333 Revenge of Fibonacci

题意:给你一个40 位的数 判断时在斐波那契数列的第一个数的前缀 没仔细看数据范围 原以为只是大数版题就放在C结果做的时候才发现数据量很大 还要加个字典树 套这两个版子就没什么问题了 预先用大数跑出斐...
  • weilehuozhe
  • weilehuozhe
  • 2015年10月07日 01:38
  • 916

UVa 12333 - Revenge of Fibonacci

题目:给你一个数字串,判断他是哪一个Fib数的前缀,有多种答案输出最小的,不存在输出-1。 分析:字符串,大整数。             首先,利用大整数计算Fib的前100000项,由于数据较...
  • mobius_strip
  • mobius_strip
  • 2014年05月26日 09:44
  • 2526

UVA 12333 - Revenge of Fibonacci

建立字典树,保存计算的结果,便于下次查找 #include #include #include #include #include #include #include #include #inclu...
  • zju2016
  • zju2016
  • 2017年07月12日 19:17
  • 135

项目评估与计划(六)- 如何跟踪计划

如何跟踪计划?   计划做出来不是用来看的,而是要执行计划!跟踪计划执行的难度和工作量比起做计划要高出好多倍。   计划跟踪并不是对照进度计划,按时间检查每个人的任务完成情况这么简单,下面介绍一些...
  • iovvo
  • iovvo
  • 2012年11月09日 14:04
  • 1017

多目标跟踪算法

多目标跟踪算法
  • duan19920101
  • duan19920101
  • 2016年03月14日 10:26
  • 3629

Bug 2974637: MANY ORA-600[KKSSCL-INF-INL-LOOP] OCCUR AND CAN NOT CREATE NEW CONNECTION

Bug 2974637: MANY ORA-600[KKSSCL-INF-INL-LOOP] OCCUR AND CAN NOT CREATE NEW CONNECTION Bug 属性类...
  • Makaveli
  • Makaveli
  • 2011年04月25日 15:13
  • 1101
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:ora-600[12333]错误小结及跟踪方法
举报原因:
原因补充:

(最多只允许输入30个字)