ORA-600(1158)错误

执行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中重新的可能性不大。因此,问题的产生肯定还是与数据库状态异常有关。

This entry was posted in BUG and tagged , , . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *