ORA-00600: internal error code, arguments: [kcblasm_1], [103], []

哎呀我的天吶發表於2015-10-27
ErrorASM


點選( 此處 )摺疊或開啟

  1. ORA - 00600 : internal error code , arguments : [ kcbz_check_objd_typ_3 ] , [ ] , [ ] , [ 1 ] , [ ] , [ ] , [ ] , [ ]

  2. Tue Oct 27 10 : 00 : 28 EDT 2015

  3. Errors in file /home/oracle/admin/lxnew/bdump/lxnew_m000_68862 . trc :

  4. ORA - 00600 : internal error code , arguments : [ kcbz_check_objd_typ_3 ] , [ ] , [ ] , [ 1 ] , [ ] , [ ] , [ ] , [ ]

  5. Tue Oct 27 10 : 00 : 29 EDT 2015

  6. Errors in file /home/oracle/admin/lxnew/bdump/lxnew_m000_68862 . trc :

  7. ORA - 00600 : internal error code , arguments : [ 6002 ] , [ 6 ] , [ 255 ] , [ 5 ] , [ ] , [ ] , [ ] , [ ]

  8. Tue Oct 27 10 : 00 : 31 EDT 2015

  9. Errors in file /home/oracle/admin/lxnew/bdump/lxnew_m000_68862 . trc :

  10. ORA - 00600 : internal error code , arguments : [ 6002 ] , [ 6 ] , [ 240 ] , [ 4 ] , [ ] , [ ] , [ ] , [ ]

  11. Tue Oct 27 11 : 00 : 27 EDT 2015

  12. Errors in file /home/oracle/admin/lxnew/bdump/lxnew_m000_11530 . trc :

  13. ORA - 00600 : internal error code , arguments : [ kcbz_check_objd_typ_3 ] , [ ] , [ ] , [ 1 ] , [ ] , [ ] , [ ] , [ ]

  14. Tue Oct 27 11 : 00 : 30 EDT 2015

  15. Errors in file /home/oracle/admin/lxnew/bdump/lxnew_m000_11530 . trc :

  16. ORA - 00600 : internal error code , arguments : [ kcbz_check_objd_typ_3 ] , [ ] , [ ] , [ 1 ] , [ ] , [ ] , [ ] , [ ]

  17. Tue Oct 27 11 : 00 : 31 EDT 2015

  18. Errors in file /home/oracle/admin/lxnew/bdump/lxnew_m000_11530 . trc :

  19. ORA - 00600 : internal error code , arguments : [ 6002 ] , [ 6 ] , [ 255 ] , [ 5 ] , [ ] , [ ] , [ ] , [ ]

  20. Tue Oct 27 11 : 00 : 33 EDT 2015

  21. Errors in file /home/oracle/admin/lxnew/bdump/lxnew_m000_11530 . trc :

  22. ORA - 00600 : internal error code , arguments : [ 6002 ] , [ 6 ] , [ 240 ] , [ 4 ] , [ ] , [ ] , [ ] , [ ]

  23. Tue Oct 27 11 : 04 : 00 EDT 2015

  24. Errors in file /home/oracle/admin/lxnew/udump/lxnew_ora_13249 . trc :

  25. ORA - 00600 : internal error code , arguments : [ kcblasm_1 ] , [ 103 ] , [ ] , [ ] , [ ] , [ ] , [ ] , [ ]

  26. Tue Oct 27 11 : 07 : 28 EDT 2015

  27. Errors in file /home/oracle/admin/lxnew/udump/lxnew_ora_13249 . trc :

  28. ORA - 00600 : internal error code , arguments : [ kcblasm_1 ] , [ 103 ] , [ ] , [ ] , [ ] , [ ] , [ ] , [ ]

  29. Tue Oct 27 11 : 09 : 01 EDT 2015

  30. Errors in file /home/oracle/admin/lxnew/udump/lxnew_ora_13249 . trc :

  31. ORA - 00600 : internal error code , arguments : [ kcblasm_1 ] , [ 103 ] , [ ] , [ ] , [ ] , [ ] , [ ] , [ ]

  32. Tue Oct 27 11 : 13 : 27 EDT 2015

  33. Errors in file /home/oracle/admin/lxnew/udump/lxnew_ora_13249 . trc :

  34. ORA - 00600 : internal error code , arguments : [ kcblasm_1 ] , [ 103 ] , [ ] , [ ] , [ ] , [ ] , [ ] , [ ]


點選( 此處 )摺疊或開啟

  1. /home/oracle/admin/lxnew/udump/lxnew_ora_13249 . trc

  2. Oracle Database 10g Enterprise Edition Release 10 . 2 . . 5 . 0 - 64bit Production

  3. With the Partitioning , OLAP , Data Mining and Real Application Testing options

  4. ORACLE_HOME = /home/oracle/product/10 . 2 . 0/dbhome_1

  5. System name :     Linux

  6. Node name :     longxindb1

  7. Release :     2 . 6 . 32 - 220 . el6 . x86_64

  8. Version :     #1 SMP Thu May 24 05 : 55 : 26 EDT 2012

  9. Machine :     x86_64

  10. Instance name : lxnew

  11. Redo thread mounted by this instance : 1

  12. Oracle process number : 0

  13. Unix process pid : 13249 , image : oracle@longxindb1


  15. ORA - 00020 : maximum number of processes 150 exceeded

  16. /home/oracle/admin/lxnew/udump/lxnew_ora_13249 . trc

  17. Oracle Database 10g Enterprise Edition Release 10 . 2 . . 5 . 0 - 64bit Production

  18. With the Partitioning , OLAP , Data Mining and Real Application Testing options

  19. ORACLE_HOME = /home/oracle/product/10 . 2 . 0/dbhome_1

  20. System name :     Linux

  21. Node name :     longxindb1

  22. Release :     2 . 6 . 32 - 220 . el6 . x86_64

  23. Version :     #1 SMP Thu May 24 05 : 55 : 26 EDT 2012

  24. Machine :     x86_64

  25. Instance name : lxnew

  26. Redo thread mounted by this instance : 1

  27. Oracle process number : 26

  28. Unix process pid : 13249 , image : oracle@longxindb1


  30. * * * ACTION NAME : ( SQL 視窗 - 新建 ) 2015 - 10 - 27 11 : 04 : 00 . 298

  31. * * * MODULE NAME : ( PL/SQL Developer ) 2015 - 10 - 27 11 : 04 : 00 . 298

  32. * * * SERVICE NAME : ( lxnew ) 2015 - 10 - 27 11 : 04 : 00 . 298

  33. * * * SESSION ID : ( 307 . 13498 ) 2015 - 10 - 27 11 : 04 : 00 . 298

  34. * * * 2015 - 10 - 27 11 : 04 : 00 . 298

  35. ksedmp : internal or fatal error

  36. ORA - 00600 : internal error code , arguments : [ kcblasm_1 ] , [ 103 ] , [ ] , [ ] , [ ] , [ ] , [ ] , [ ]

  37. Current SQL statement for this session :

  38. - - INSERT INTO MID_F_ENT_BASIC_INFO

  39. SELECT '20150702' ,

  40.        A . ID ,

  41.        A . NSRSBH ,

  42.        A . COM_CODE ,

  43.        A . REG_BUS_ENT_ID ,

  44.        A . TAXPAYNAME ,

  45.        A . ZZJGDM ,

  46.        A . REG_CODE ,

  47.        B . TAX_CODE ,

  48.        CASE

  49.          WHEN C . OP_LOC IS NULL AND B . REG_ADDR IS NOT NULL THEN

  50.           B . REG_ADDR

  51.          WHEN C . OP_LOC IS NULL AND B . REG_ADDR IS NULL THEN

  52.           D . ZCDZ

  53.           ELSE

  54.           C . OP_LOC

  55.        END ,

  56.        C . REG_CAP ,

  57.        CASE

  58.          WHEN B . REG_ADDR IS NULL AND C . OP_LOC IS NOT NULL THEN

  59.           C . OP_LOC

  60.          WHEN B . REG_ADDR IS NULL AND C . OP_LOC IS NULL THEN

  61.           D . ZCDZ

  62.           ELSE

  63.           B . REG_ADDR

  64.        END ,

  65.        CASE

  66.          WHEN B . IND_CODE IS NULL AND D . HY_DM IS NOT NULL THEN

  67.           D . HY_DM

  68.          WHEN B . IND_CODE IS NULL AND D . HY_DM IS NULL THEN

  69.           C . INDUSTRY_CO

  70.           ELSE

  71.           B . IND_CODE

  72.        END ,

  73.        CASE

  74.          WHEN B . STREET_TYPE IS NULL AND C . DOM_DISTRICT IS NULL THEN

  75.           D . JDXZ_DM

  76.          WHEN B . STREET_TYPE IS NULL AND D . JDXZ_DM IS NULL THEN

  77.           C . DOM_DISTRICT

  78.           ELSE

  79.           B . STREET_TYPE

  80.        END ,

  81.        CASE

  82.          WHEN B . REG_TYPE IS NULL AND D . DJZCLX_DM IS NULL THEN

  83.           C . ENT_TYPE

  84.          WHEN B . REG_TYPE IS NULL AND C . ENT_TYPE IS NULL THEN

  85.           D . DJZCLX_DM

  86.           ELSE

  87.           B . REG_TYPE

  88.        END ,

  89.      NVL ( B . RUDGET_CODE , D . HSXS_DM ) ,

  90.        CASE

  91.          WHEN C . ENT_STATE IS NULL AND B . TAX_STATE IS NULL THEN

  92.           D . NSRZT_DM

  93.          WHEN C . ENT_STATE IS NULL AND D . NSRZT_DM IS NULL THEN

  94.           B . TAX_STATE

  95.           ELSE

  96.           C . ENT_STATE

  97.        END ,

  98.        C . CAP_CUR ,

  99.         '' ,

  100.         '' ,

  101.        CASE

  102.          WHEN C . REG_ORG IS NULL AND B . MTAX_CODE IS NULL THEN

  103.           D . NSR_SWJG_DM

  104.          WHEN C . REG_ORG IS NULL AND D . NSR_SWJG_DM IS NULL THEN

  105.           B . MTAX_CODE

  106.           ELSE

  107.           C . REG_ORG

  108.        END ,

  109.        PT_BUS_SCOPE ,

  110.        OP_SCOPE ,

  111.        OP_SUFFIX ,

  112.        CASE

  113.          WHEN B . REG_DATE IS NULL THEN

  114.           C . EST_DATE

  115.           ELSE

  116.           TO_CHAR ( B . REG_DATE , 'YYYYMMDD' )

  117.        END ,

  118.        APPROVE_DATE ,

  119.        EST_DATE ,

  120.        CANCEL_DATE ,

  121.        REVOKE_DATE

  122.   FROM MID_F_ENT_BASIC_INFO_PP_ALL A ,

  123.        MID_ENT_DS                  B ,

  124.        MID_ENT_IND                 C ,

  125.        MID_ENT_GS                  D

  126.  WHERE A . ID = B . ID ( + )

  127.     AND A . ID = C . ID ( + )

  128.     AND A . ID = D . ID ( + )

  129. - - - - - Call Stack Trace - - - - -

  130. calling call entry                argument values in hex

  131. location type point ( ? means dubious value )

  132. - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

  133. ssd_unwind_bp : unhandled instruction at 0x3d12d3e instr = f

  134. ksedst ( ) + 31 call ksedst1 ( ) 000000000 ? 000000001 ?

  135.                                                    7FFF5FB29320 ? 7FFF5FB29380 ?

  136.                                                    7FFF5FB292C0 ? 000000000 ?

  137. ksedmp ( ) + 610 call ksedst ( ) 000000000 ? 000000001 ?

  138.                                                    7FFF5FB29320 ? 7FFF5FB29380 ?

  139.                                                    7FFF5FB292C0 ? 000000000 ?

  140. ksfdmp ( ) + 63 call ksedmp ( ) 000000003 ? 000000001 ?

  141.                                                    7FFF5FB29320 ? 7FFF5FB29380 ?

  142.                                                    7FFF5FB292C0 ? 000000000 ?

  143. kgerinv ( ) + 161 call ksfdmp ( ) 006AE9A40 ? 000000003 ?

  144.                                                    7FFF5FB29320 ? 7FFF5FB29380 ?

  145.                                                    7FFF5FB292C0 ? 000000000 ?

  146. kgeasnmierr ( ) + 163 call kgerinv ( ) 006AE9A40 ? 7FB8CCE11168 ?

  147.                                                    7FFF5FB29380 ? 7FFF5FB292C0 ?

  148.                                                    000000000 ? 000000000 ?

  149. kcblasm1 ( ) + 113 call kgeasnmierr ( ) 006AE9A40 ? 7FB8CCE11168 ?

  150.                                                    7FFF5FB29380 ? 7FFF5FB292C0 ?

  151.                                                    000000000 ? 000000067 ?

  152. kcblasm ( ) + 52 call kcblasm1 ( ) 7FB8CCB4A980 ? 7FFF5FB292C0 ?

  153.                                                    7FFF5FB29380 ? 7FFF5FB292C0 ?

  154.                                                    000000000 ? 000000067 ?


ORA-600 [kcblasm_1] In 10.2.0.5. (文件 ID 1133845.1)

好吧打patch吧，要不然就用hint/*+ use_nl(xx,xxx,xxxx,xxxx) leading(xxx)*/或者 /*+use_hash()  parallel(n)*/，這個問題的原因就是hash讀取的資料大小超過資料庫的某個限制，要麼不用hash，要不就將hash切片變成小份，避免觸發，當然要考慮use_nl的效率問題。

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/29990276/viewspace-1816489/，如需轉載，請註明出處，否則將追究法律責任。

相關文章