正看着书呢，突然收到监控平台发来的一条短信：数据出现了ora-00600: internal error code, arguments: [evapth : unexpected ev
正看着书呢，突然收到监控平台发来的一条短信：数据出现了ora-00600: internal error code, arguments: [evapth : unexpected evaluation], [], [], [], [], [], [], []的内部错误，赶紧跑去机房看一下，结果被告知是这个错误是有个哥们在执行一个sql后造成的，还好只是虚惊一场，不过自己还是想把这问题搞个明白。
服务器：aix 5309
数据库：oracle 10.2.0.4
当时那哥们正在执行的语句是：
select distinct t1.loan_no ,--,
       t.customer_cname ,
       t3.industry_class1_name ,
       t3.industry_class1_code,
       t3.industry_class2_name,
       t3.industry_class2_code,
       t3.industry_class3_name,
       t3.industry_class3_code,
       t3.industry_class4_name,
       t3.industry_class4_code,
       t.customer_scale 大中小微分类,
       t7.second_type,
       t7.first_type,
       t7.path_code,
       t7.path_name,
       t2.loan_start_date,
       t2.mature_date,
       t2.loan_amt  发放金额,
       t2.cmis_five_class,
       t1.loan_amt 贷款余额,
       t4.sec_code,
       t4.sec_name,
       t4.fir_code,
       t4.fir_name,
       t.customer_id
      -- sum(t1.loan_amt)
  from srcb_ods.c_customer_info t,srcb_fsd.cl_loan_acct t1,srcb_fsd.cl_loan t2,
  srcb_fsd.country_standard_industry_clas t3,srcb_fsd.com_bank_hierarchy t4,srcb_fsd.prod_map_tbl t6,
  (select t5.loan_type_id,connect_by_root t5.loan_type_id as second_type, connect_by_root t5.upper_loan_type_id as first_type,
sys_connect_by_path(t5.loan_type_id, '/') as path_code,sys_connect_by_path(t5.loan_type_name, '/') as path_name
  from los.loan_type_info@los t5 start with t5.loan_type_idt5.upper_loan_type_id
connect by nocycle prior t5.loan_type_id = t5.upper_loan_type_id) t7
 where t.data_date = '20120229'
   and t1.fdate='20120229'
   and t.customer_id=t1.client_no
   and t2.fdate='20120229'
   and t1.loan_no=t2.loan_no
   and substr(t.industry_id,2)=t3.industry_class4_code
   and t2.loan_branch=t4.fir_code
   and t4.fiv_code='00001'
   and t1.settle_ind='n'
  -- and t.customer_scale='01'
   and t2.loan_cate='01'
   and t2.loan_sub_type=t6.fsd_prod_code
   and t6.s_prod_code=t7.loan_type_id
   order by t4.sec_code,t4.fir_code,t.customer_id
在网上google和在mos上查了一些，都说是因为使用了sys_connect_by_path的原因，注意sql中的红色部分，单独执行红色sql是没问题的，，但是如果整个sql语句一起执行的话就会报错。这说明该错误不是那个子sql造成的，而是与其他语句结合才会出现的错误(bug)。
注明：不过还发现一个比较奇怪的问题，就是同样是这条语句，我在另一套环境执行则是没问题的。不知道为何，两套环境的数据库补丁集神马都是一样的。
直接附官文：
ora-600 [evapth : unexpected evaluation] [id 284511.1]
修改时间 19-dec-2011     类型 reference     状态 published 
note: for additional ora-600 related information please read note:146580.1purpose: this article represents a partially published oeri note.it has been published because the ora-600 error has beenreported in at least one confirmed bug.therefore, the suggestions section of this article may help in terms of identifying the cause of the error.this specific ora-600 error may be considered for full publication at a later date. if/when fully published, additional informationwill be available here on the nature of this error.error: ora-600 [evapth : unexpected evaluation] [a] [b] [c] [d] [e]suggestions:if the known issues section below does not help in terms of identifying a solution, please submit the trace files and alert.log to oraclesupport services for further analysis.known issues:bug# 5262483 see note:5262483.8oeri[evapth : unexpected evaluation] from connect by queryfixed: 10.2.0.5, 11.2bug# 5234295 see note:5234295.8oeri[evapth : unexpected evaluation] from sys_connect_by_pathfixed: 10.2.0.5, 11.1.0.6bug# 3703176 see note:3703176.8oeri[evapth : unexpected evaluation] selecting from set view using sys_connect_by_pathfixed: 9.2.0.7, 10.1.0.4, 10.2.0.1bug# 3365439 see note:3365439.8oeri[evapth : unexpected evaluation] using sys_connect_by_pathfixed: 9.2.0.7, 10.1.0.4, 10.2.0.1bug# 2627306 see note:2627306.8oeri:[evapth : unexpected evaluation] using sys_connect_by_path()fixed: 9.2.0.4, 10.1.0.2
bug 5234295 - oeri[evapth : unexpected evaluation] from sys_connect_by_path [id 5234295.8]