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

點選( 此處 )摺疊或開啟

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
    

14. 
    

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
    

29. 
    

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的效率問題。