正看着书呢，突然收到监控平台发来的一条短信：数据出现了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]
版权声明：本文内容由互联网用户自发贡献，该文观点仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容， 请发送邮件至253000106@qq.com举报，一经查实，本站将立刻删除。
发布者：PHP中文网，转转请注明出处：https://www.chuangxiangniao.com/p/1919215.html
