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()) ==========

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

ORA-600(1158)错误

Leave a Reply Cancel reply

Recent Posts

Recent Comments

Archives

Categories

Meta