ORA-00600:internalerrorcode,arguments:[evapth:unexpec
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了ORA-00600:internalerrorcode,arguments:[evapth:unexpec,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含4292字,纯文字阅读大概需要7分钟。
内容图文
正看着书呢,突然收到监控平台发来的一条短信:数据出现了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_id<>t5.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.1 PURPOSE: This article represents a partially published OERI note. It has been published because the ORA-600 error has been reported 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 information will 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 Oracle Support Services for further analysis. Known Issues: Bug# 5262483 See Note:5262483.8 OERI[evapth : unexpected evaluation] from CONNECT BY query Fixed: 10.2.0.5, 11.2 Bug# 5234295 See Note:5234295.8 OERI[evapth : unexpected evaluation] from SYS_CONNECT_BY_PATH Fixed: 10.2.0.5, 11.1.0.6 Bug# 3703176 See Note:3703176.8 OERI[evapth : unexpected evaluation] selecting from set view using SYS_CONNECT_BY_PATH Fixed: 9.2.0.7, 10.1.0.4, 10.2.0.1 Bug# 3365439 See Note:3365439.8 OERI[evapth : unexpected evaluation] using SYS_CONNECT_BY_PATH Fixed: 9.2.0.7, 10.1.0.4, 10.2.0.1 Bug# 2627306 See Note:2627306.8 OERI:[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]
内容总结
以上是互联网集市为您收集整理的ORA-00600:internalerrorcode,arguments:[evapth:unexpec全部内容,希望文章能够帮你解决ORA-00600:internalerrorcode,arguments:[evapth:unexpec所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。