问题描述
执行DDL时取消当前的操作出现这个错误。
详细错误信息如下：
SQL> ALTER TRIGGER DBFW_CONSOLE_ACCESS.TRIGGER_DDL disable; ^Calter TRIGGER DBFW_CONSOLE_ACCESS.TRIGGER_DDL disable * ERROR at line 1: ORA-00600: internal error code, arguments: [1158], [], [], [], [], [], [], []
专家解答
告警日志中信息为：
Tue Feb 7 14:56:28 2012 Errors IN file /u01/app/oracle/admin/ORCL/udump/eygle_ora_21708.trc: ORA-00600: internal error code, arguments: [1158], [], [], [], [], [], [], [] Tue Feb 7 14:56:38 2012 Errors IN file /u01/app/oracle/admin/ORCL/udump/eygle_ora_22172.trc: ORA-00604: error occurred at recursive SQL level 1 ORA-01013: USER requested cancel OF CURRENT operation ORA-06512: at line 3 Tue Feb 7 15:01:59 2012 Errors IN file /u01/app/oracle/admin/ORCL/udump/eygle_ora_22401.trc: ORA-00604: error occurred at recursive SQL level 1 ORA-01013: USER requested cancel OF CURRENT operation ORA-06512: at line 3
详细的TRACE文件：
[ora10g@hpserver2 bdump]$ more /u01/app/oracle/admin/ORCL/udump/eygle_ora_21708.trc /u01/app/oracle/admin/ORCL/udump/eygle_ora_21708.trc Oracle DATABASE 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production WITH the Partitioning, OLAP, DATA Mining AND REAL Application Testing options ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1 System name: Linux Node name: hpserver2.enmotech.com Release: 2.6.32-100.28.5.el6.x86_64 Version: #1 SMP Wed Feb 2 18:40:23 EST 2011 Machine: x86_64 Instance name: eygle Redo thread mounted BY this instance: 1 Oracle process NUMBER: 16 Unix process pid: 21708, image: oracle@hpserver2.enmotech.com (TNS V1-V3) *** ACTION NAME:() 2012-02-07 14:48:48.867 *** MODULE NAME:(sqlplus@hpserver2.enmotech.com (TNS V1-V3)) 2012-02-07 14:48:48.867 *** SERVICE NAME:(SYS$USERS) 2012-02-07 14:48:48.867 *** SESSION ID:(148.61) 2012-02-07 14:48:48.867 Error IN executing triggers ON CONNECT internal *** 2012-02-07 14:48:48.868 ksedmp: internal OR fatal error ORA-00604: error occurred at recursive SQL level 1 ORA-30511: invalid DDL operation IN system triggers ORA-06512: at line 3 (enqueue) TX-00080010-00000DB9 DID: 0001-0010-00000011 lv: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 res_flag: 0x6 res: 0x1155771b8, mode: X, lock_flag: 0x0 own: 0x11540ce98, sess: 0x11540ce98, proc: 0x1152fc168, prv: 0x1155771c8 =================================================== ENQUEUES -------- Active: LOCK: (nil), resource: (nil) Global: name: ORCL Hash: LENGTH: 375, at: 0x115597448 [115597448,115597448] [115597478,115597478] [1155974a8,1155974a8] [1155974d8,1155974d8] [115597508,115597508] [115597538,115597538] [115597568,115597568] [115597598,115597598] [1155975c8,1155975c8] [1155975f8,1155975f8] [115597628,115597628] [115597658,115597658] . . . [11559b8e8,11559b8e8] [11559b918,11559b918] [11559b948,11559b948] [11559b978,11559b978] [11559b9a8,11559b9a8] [11559b9d8,11559b9d8] [11559ba08,11559ba08] [11559ba38,11559ba38] [11559ba68,11559ba68] res identification NUL SS SX S SSX X md link owners converters waiters ------------------------------------------------------------------------- 0x115576d60 XR-00000004-00000000 1 0 0 0 0 0 2 [11559a838,11559a838] [11551fe88,11551fe88] [115576d90,115576d90] [115576d80,115576d80] LOCK que owner SESSION hold wait ser link ---------------------------------------------------------------------- 0x11551fe78 OWN 0x115423a80 0x115423a80 (165) NULL NLCK 1 [115576d70,115576d70] 0x115577130 CF-00000000-00000000 0 1 0 0 0 0 4 [11559b3d8,11559b3d8] [11551ff20,11551ff20] [115577160,115577160] [115577150,115577150] LOCK que owner SESSION hold wait ser link ---------------------------------------------------------------------- 0x11551ff10 OWN 0x115423a80 0x115423a80 (165) SS NLCK 1 [115577140,115577140] 0x1155771b8 TX-00080010-00000db9 U 0 0 0 0 0 1 40 [11559b498,11559b498] [112c2b260,112c2b260] [1155771e8,1155771e8] [1155771d8,1155771d8] LOCK que owner SESSION hold wait ser link ---------------------------------------------------------------------- 0x112c2b250 OWN 0x11540ce98 0x11540ce98 (148) X NLCK 61 [1155771c8,1155771c8] 0x115577460 RT-00000001-00000000 0 0 0 0 0 1 40 [115598408,115598408] [115520180,115520180] [115577490,115577490] [115577480,115577480] LOCK que owner SESSION hold wait ser link ---------------------------------------------------------------------- 0x115520170 OWN 0x115424fe8 0x115424fe8 (166) X NLCK 1 [115577470,115577470] 0x1155774e8 RS-00000019-00000001 0 1 0 0 0 0 4 [115598888,115598888] [115520050,115520050] [115577518,115577518] [115577508,115577508] LOCK que owner SESSION hold wait ser link ---------------------------------------------------------------------- 0x115520040 OWN 0x115423a80 0x115423a80 (165) SS NLCK 1 [1155774f8,1155774f8] 0x1155778b8 MR-00000007-00000000 0 0 0 1 0 0 10 [11559ad18,11559ad18] [115520770,115520770] [1155778e8,1155778e8] [1155778d8,1155778d8] LOCK que owner SESSION hold wait ser link ---------------------------------------------------------------------- 0x115520760 OWN 0x115426550 0x115426550 (167) S NLCK 1 [1155778c8,1155778c8] 0x115577940 TX-0004001f-00000aa8 U 0 0 0 0 0 1 40 [11559ad48,11559ad48] [112c6bfb0,112c6bfb0] [115577970,115577970] [115577960,115577960] LOCK que owner SESSION hold wait ser link ---------------------------------------------------------------------- 0x112c6bfa0 OWN 0x11540a3c8 0x11540a3c8 (146) X NLCK 71 [115577950,115577950] 0x115577ad8 MR-00000001-00000000 0 0 0 1 0 0 10 [11559abf8,11559abf8] [1155203e0,1155203e0] [115577b08,115577b08] [115577af8,115577af8] LOCK que owner SESSION hold wait ser link ---------------------------------------------------------------------- 0x1155203d0 OWN 0x115426550 0x115426550 (167) S NLCK 1 [115577ae8,115577ae8] 0x115577b60 MR-00000002-00000000 0 0 0 1 0 0 10 [11559ac28,11559ac28] [115520478,115520478] [115577b90,115577b90] [115577b80,115577b80] LOCK que owner SESSION hold wait ser link ---------------------------------------------------------------------- 0x115520468 OWN 0x115426550 0x115426550 (167) S NLCK 1 [115577b70,115577b70] 0x115577e90 MR-00000003-00000000 0 0 0 1 0 0 10 [11559ac58,11559ac58] [115520510,115520510] [115577ec0,115577ec0] [115577eb0,115577eb0] LOCK que owner SESSION hold wait ser link ---------------------------------------------------------------------- 0x115520500 OWN 0x115426550 0x115426550 (167) S NLCK 1 [115577ea0,115577ea0] 0x115577f18 MR-00000004-00000000 0 0 0 1 0 0 10 [11559ac88,11559ac88] [1155205a8,1155205a8] [115577f48,115577f48] [115577f38,115577f38] LOCK que owner SESSION hold wait ser link ---------------------------------------------------------------------- 0x115520598 OWN 0x115426550 0x115426550 (167) S NLCK 1 [115577f28,115577f28] 0x115577fa0 MR-00000005-00000000 0 0 0 1 0 0 10 [11559acb8,11559acb8] [115520640,115520640] [115577fd0,115577fd0] [115577fc0,115577fc0] LOCK que owner SESSION hold wait ser link ---------------------------------------------------------------------- 0x115520630 OWN 0x115426550 0x115426550 (167) S NLCK 1 [115577fb0,115577fb0] 0x115578028 MR-00000006-00000000 0 0 0 1 0 0 10 [11559ace8,11559ace8] [1155206d8,1155206d8] [115578058,115578058] [115578048,115578048] LOCK que owner SESSION hold wait ser link ---------------------------------------------------------------------- 0x1155206c8 OWN 0x115426550 0x115426550 (167) S NLCK 1 [115578038,115578038] 0x1155780c8 MR-000000c9-00000000 0 0 0 1 0 0 10 [115598b28,115598b28] [115520820,115520820] [1155780f8,1155780f8] [1155780e8,1155780e8] LOCK que owner SESSION hold wait ser link ---------------------------------------------------------------------- 0x115520810 OWN 0x115426550 0x115426550 (167) S NLCK 1 [1155780d8,1155780d8] 0x115579048 PW-00000001-00000000 U 0 0 1 0 0 0 8 [115597898,115597898] [115520218,115520218] [115579078,115579078] [115579068,115579068] LOCK que owner SESSION hold wait ser link ---------------------------------------------------------------------- 0x115520208 OWN 0x115426550 0x115426550 (167) SX NLCK 1 [115579058,115579058] 0x115579f58 TA-00000006-00000001 0 0 0 0 0 1 40 [115598d98,115598d98] [11551ffb8,11551ffb8] [115579f88,115579f88] [115579f78,115579f78] LOCK que owner SESSION hold wait ser link ---------------------------------------------------------------------- 0x11551ffa8 OWN (NULL) X NLCK [115579f68,115579f68] 0x11557b2a8 TS-00000003-00000001 0 0 1 0 0 0 8 [115599068,115599068] [115520950,115520950] [11557b2d8,11557b2d8] [11557b2c8,11557b2c8] LOCK que owner SESSION hold wait ser link ---------------------------------------------------------------------- 0x115520940 OWN 0x115422518 0x115422518 (164) SX NLCK 1 [11557b2b8,11557b2b8] 0x11557e1f8 TX-00060003-00000da2 U 0 0 0 0 0 1 40 [1155988e8,1155988e8] [112c46650,112c46650] [11557e228,11557e228] [11557e218,11557e218] LOCK que owner SESSION hold wait ser link ---------------------------------------------------------------------- 0x112c46640 OWN 0x1154078f8 0x1154078f8 (144) X NLCK 14 [11557e208,11557e208] 0x115580920 TM-000022f2-00000000 U 0 0 0 0 0 1 40 [115598468,115598468] [112bda4c8,112bda4c8] [115580950,115580950] [115580940,115580940] LOCK que owner SESSION hold wait ser link ---------------------------------------------------------------------- 0x112bda4b8 OWN 0x1154078f8 0x1154078f8 (144) X NLCK 14 [115580930,115580930] 0x115582150 TX-00060023-00000da1 U 0 0 0 0 0 1 40 [115598eb8,115598eb8] [112c46ef0,112c46ef0] [115582180,115582180] [115582170,115582170] LOCK que owner SESSION hold wait ser link ---------------------------------------------------------------------- 0x112c46ee0 OWN 0x1154078f8 0x1154078f8 (144) X NLCK 14 [115582160,115582160] 0x11558a7a0 TO-0000cb4e-00000001 0 0 1 0 0 0 8 [115598048,115598048] [1155200e8,1155200e8] [11558a7d0,11558a7d0] [11558a7c0,11558a7c0] LOCK que owner SESSION hold wait ser link ---------------------------------------------------------------------- 0x1155200d8 OWN 0x11540a3c8 0x11540a3c8 (146) SX NLCK 71 [11558a7b0,11558a7b0] *** 2012-02-07 14:56:28.522 ksedmp: internal OR fatal error ORA-00600: internal error code, arguments: [1158], [], [], [], [], [], [], [] CURRENT SQL statement FOR this SESSION: ALTER TRIGGER DBFW_CONSOLE_ACCESS.TRIGGER_DDL disable ----- Call Stack Trace ----- calling CALL entry argument VALUES IN hex location TYPE point (? means dubious VALUE) -------------------- -------- -------------------- ---------------------------- ksedst()+31 CALL ksedst1() 000000000 ? 000000001 ? 7FFFFC3C2CC0 ? 7FFFFC3C2D20 ? 7FFFFC3C2C60 ? 000000000 ? ksedmp()+610 CALL ksedst() 000000000 ? 000000001 ? 7FFFFC3C2CC0 ? 7FFFFC3C2D20 ? 7FFFFC3C2C60 ? 000000000 ? ksfdmp()+21 CALL ksedmp() 000000003 ? 000000001 ? 7FFFFC3C2CC0 ? 7FFFFC3C2D20 ? 7FFFFC3C2C60 ? 000000000 ? kgeriv()+176 CALL ksfdmp() 000000003 ? 000000001 ? 7FFFFC3C2CC0 ? 7FFFFC3C2D20 ? 7FFFFC3C2C60 ? 000000000 ? kgesiv()+119 CALL kgeriv() 0068C8BA0 ? 008686B30 ? 000000000 ? 000000005 ? 7FFFFC3C2C60 ? 000000000 ? ksesic0()+209 CALL kgesiv() 0068C8BA0 ? 008686B30 ? 000000486 ? 000000000 ? 7FFFFC3C3A40 ? 000000000 ? ksqgtlctx()+5189 CALL ksesic0() 000000486 ? 000000040 ? 115597400 ? 000000000 ? 000000013 ? 000000001 ? ktubnd()+3130 CALL ksqgtlctx() 112C2B250 ? 000000006 ? 000000000 ? 000000000 ? 00000003B ? 000080010 ? ktubgn()+222 CALL ktubnd() 7FFFFC3C40D0 ? 112C2B2B0 ? 000000000 ? 000000000 ? 00000003B ? 000080010 ? krvgfci_GatherFixed CALL ktubgn() 000000000 ? 000000000 ? CommonInfo()+98 000000000 ? 000000000 ? 00000003B ? 000080010 ? krvgrgd()+323 CALL krvgfci_GatherFixed 7FFFFC3C4538 ? 000000000 ? CommonInfo() 000000000 ? 000000000 ? 00000003B ? 000080010 ? knldcddl()+603 CALL krvgrgd() 7FFFFC3C4538 ? 000000000 ? 7FAF93439778 ? 000000000 ? 00000003B ? 000080010 ? opiexe()+11908 CALL knldcddl() 00000003C ? 10A659E98 ? 000000000 ? 000000000 ? 00000003B ? 000080010 ? opiosq0()+3316 CALL opiexe() 000000004 ? 000000000 ? 7FFFFC3C57F8 ? 000000001 ? 00000003B ? 000080010 ? kpooprx()+315 CALL opiosq0() 000000003 ? 00000000E ? 7FFFFC3C5968 ? 0000000A4 ? 00000003B ? 000080010 ? kpoal8()+799 CALL kpooprx() 7FFFFC3C8B14 ? 7FFFFC3C6AD8 ? 000000035 ? 000000001 ? 000000000 ? 000080010 ? opiodr()+984 CALL kpoal8() 00000005E ? 000000017 ? 7FFFFC3C8B10 ? 000000001 ? 000000001 ? 000080010 ? ttcpip()+1226 CALL opiodr() 00000005E ? 000000017 ? 7FFFFC3C8B10 ? 000000000 ? 0059F0470 ? 000080010 ? opitsk()+1322 CALL ttcpip() 0068D0870 ? 0052E52C0 ? 7FFFFC3C8B10 ? 000000000 ? 7FFFFC3C8608 ? 7FFFFC3C8C78 ? opiino()+1026 CALL opitsk() 000000003 ? 000000000 ? 7FFFFC3C8B10 ? 000000001 ? 000000000 ? 866002D00000001 ? opiodr()+984 CALL opiino() 00000003C ? 000000004 ? 7FFFFC3C9CD8 ? 000000001 ? 000000000 ? 866002D00000001 ? opidrv()+547 CALL opiodr() 00000003C ? 000000004 ? 7FFFFC3C9CD8 ? 000000000 ? 0059EFF20 ? 866002D00000001 ? sou2o()+114 CALL opidrv() 00000003C ? 000000004 ? 7FFFFC3C9CD8 ? 000000000 ? 0059EFF20 ? 866002D00000001 ? opimai_real()+163 CALL sou2o() 7FFFFC3C9CB0 ? 00000003C ? 000000004 ? 7FFFFC3C9CD8 ? 0059EFF20 ? 866002D00000001 ? main()+116 CALL opimai_real() 000000002 ? 7FFFFC3C9D40 ? 000000004 ? 7FFFFC3C9CD8 ? 0059EFF20 ? 866002D00000001 ? __libc_start_main() CALL main() 000000002 ? 7FFFFC3C9D40 ? +253 000000004 ? 7FFFFC3C9CD8 ? 0059EFF20 ? 866002D00000001 ? _start()+41 CALL __libc_start_main() 000723734 ? 000000002 ? 7FFFFC3C9E98 ? 000000000 ? 0059EFF20 ? 866002D00000001 ? --------------------- Binary Stack Dump --------------------- ========== FRAME [1] (ksedst()+31 -> ksedst1()) ==========
这个1158的ORA-600错误和其他有所不同，在文件开始并非是SQL信息，而是锁的信息，而且从屏幕显式可以看到，对于这个禁止触发器的DDL执行了CTRL+C中止命令的操作。虽然观察数据库的日志发现，数据库由于归档路径写满，导致系统进入HANG的状态，因此当前执行的DDL所依赖的对象被锁，而当取消当前的操作时，由于系统状态的不正常引发了这个错误。
查询了一下MOS，发现问题与Bug 2828026 – Interrupted sessions may fail with ORA-600[1158] / DB can hang [ID 2828026.8]描述的非常类似，但是这个bug已经在9.2.0.4和10.1.0.2中已经解决，理论上在10.2.0.4中重新的可能性不大。因此，问题的产生肯定还是与数据库状态异常有关。
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
