eygle.com   eygle.com
eygle.com eygle
eygle.com  
 

« 10.2.0.4 RAC CRS-0184错误 CRS 无法启动案例 | Blog首页 | Oracle 11gR2 Solaris x86-64 发布 »

ORA-600 17285 错误 与 PL/SQL Developer

最近遇到一则ORA-600 17285错误,着实吓人一跳,在繁忙的高峰时段出现这个错误,还真是让人紧张的。

Fri Dec  4 10:11:24 2009
Errors in file /u01/admin/cnderpdb/udump/cnderpdb2_ora_377482.trc:
ORA-00600: internal error code, arguments: [17285], [0x1104679C0], [4294967295], [0x70000033D7A52B0], [], [], [], []
ORA-00604: error occurred at recursive SQL level 2
ORA-03135: connection lost contact
Fri Dec  4 10:11:26 2009
Trace dumping is performing id=[cdmp_20091204101126]
Fri Dec  4 10:11:26 2009
Errors in file /u01/admin/erpdb/udump/erpdb2_ora_377482.trc:
ORA-00600: internal error code, arguments: [17285], [0x1104679C0], [4294967295], [0x70000033D7A52B0], [], [], [], []
ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [17285], [0x1104679C0], [4294967295], [0x70000033D7A52B0], [], [], [], []
ORA-00604: error occurred at recursive SQL level 2
ORA-03135: connection lost contact
Fri Dec  4 10:11:26 2009
Errors in file /u01/admin/erpdb/udump/erpdb2_ora_377482.trc:
ORA-07445: exception encountered: core dump [] [] [] [] [] []
ORA-00600: internal error code, arguments: [17285], [0x1104679C0], [4294967295], [0x70000033D7A52B0], [], [], [], []
ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [17285], [0x1104679C0], [4294967295], [0x70000033D7A52B0], [], [], [], []
ORA-00604: error occurred at recursive SQL level 2
ORA-03135: connection lost contact
查看跟踪文件,可以发现这是一个PL/SQL Developer的客户端调用出现的问题,那么就不怕了,这应当仅仅是客户端处理异常导致的:
*** 2009-12-04 09:32:23.348
*** ACTION NAME:(Test Window - Script for procedu) 2009-12-04 09:32:23.335
*** MODULE NAME:(PL/SQL Developer) 2009-12-04 09:32:23.335
*** SERVICE NAME:(SYS$USERS) 2009-12-04 09:32:23.335
*** SESSION ID:(754.58117) 2009-12-04 09:32:23.335
Probe:read_pipe: receive failed, status 3
*** 2009-12-04 10:11:24.194
*********START PLSQL RUNTIME DUMP************
***Got internal error Exception caught in pfrrun() while running PLSQL***
***Got ORA-604 while running PLSQL***
PACKAGE BODY SYS.PBREAK:
library unit=7000002d541e670 line=1129 opcode=0 static link=0 scope=1
FP=110448310 PC=7000002e28c37c2 Page=1 AP=1104470d0 ST=110448510
DL0=110545dc8 GF=110545e60 DL1=110545e08 DPF=110545e50 DS=7000002e28c5250
也就是说,可能某个客户端正在调用PL/SQL Developer进行某个Procedure的测试。

查询一下Metalink获得基本信息,也可以知道问题不大:
Oracle is in the process of deleting an instantiation object when it discovers that the object is currently on the call stack.
也就是说Oracle在处理删除对象时,发现对象还在被调用,这类错误显然并不会带来数据损失。

在跟踪文件部分也可以看到错误出现在dbms_debug包的调用过程中:
*** 2009-12-04 10:11:24.213
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [17285], [0x1104679C0], [4294967295], [0x70000033D7A52B0], [], [], [], []
ORA-00604: error occurred at recursive SQL level 2
ORA-03135: connection lost contact
Current SQL statement for this session:
begin
  sys.dbms_debug.default_timeout := 3600;
  sys.dbms_debug.debug_off;
end;
----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
----- Call Stack Trace -----
calling              call     entry                argument values in hex     
location             type     point                (? means dubious value)    
-------------------- -------- -------------------- ----------------------------

Metalink上还有个历史悠久的Bug中提到:
Bug 377047  PLSQL: ORA-600 [17285] if Ctrl-C in critical code

可见客户端在编译或执行过程中取消某些操作就可以导致这个600错误。

也可以参考Yangtingkun遇到的: http://space.itpub.net/4227/viewspace-254385

-The End-






历史上的今天...
    >> 2010-12-07文章:
    >> 2008-12-07文章:
    >> 2007-12-07文章:
           有多少Puber在上我的网站?
    >> 2006-12-07文章:
    >> 2005-12-07文章:
           What's the Next to be Compressed?
           Still not got my DBA

无觅

By eygle on 2009-12-07 08:24 | Comments (0) | Case | 2469 |


CopyRight © 2004~2020 云和恩墨,成就未来!, All rights reserved.
数据恢复·紧急救援·性能优化 云和恩墨 24x7 热线电话:400-600-8755 业务咨询:010-59007017-7040 or 7037 业务合作: marketing@enmotech.com