问题描述
客户9208环境出现ORA-600[kgavsd_3]错误。
错误信息为:
Thu DEC 15 15:47:57 2011 Errors IN file /oracle/admin/orcl/udump/orcl2_ora_659472.trc: ORA-00600: internal error code, arguments: [kgavsd_3], [0], [], [], [], [], [], [] ORA-00604: error occurred at recursive SQL level 2 ORA-03113: end-of-file ON communication channel ORA-03113: end-of-file ON communication channel ORA-06512: at "DB_USER.P_JOB", line 79 ORA-06512: at line 3 ORA-06508: PL/SQL: could NOT find program unit being called ORA-06512: at line 1 Thu DEC 15 15:47:58 2011 Trace dumping IS performing id=[cdmp_20111215154758]
专家解答
类似的错误还出现过两次,一次也是ORA-3113错误导致的:
Thu DEC 15 16:49:00 2011 Errors IN file /oracle/admin/orcl/udump/orcl2_ora_906034.trc: ORA-00600: internal error code, arguments: [kgavsd_3], [0], [], [], [], [], [], [] ORA-00604: error occurred at recursive SQL level 1 ORA-03113: end-of-file ON communication channel Thu DEC 15 16:49:02 2011 Trace dumping IS performing id=[cdmp_20111215164902]
而另一次是被用户取消所致:
Mon Jan 2 18:21:50 2012 Errors IN file /oracle/admin/orcl/udump/orcl2_ora_630794.trc: ORA-00600: internal error code, arguments: [kgavsd_3], [0], [], [], [], [], [], [] ORA-00604: error occurred at recursive SQL level 1 ORA-01013: USER requested cancel OF CURRENT operation Mon Jan 2 18:21:51 2012 Trace dumping IS performing id=[cdmp_20120102182151]
根据这三个错误综合判断,可以判断问题和Ora-600 kgavsd_3 [ID 403575.1]描述的一致,客户使用的多半是SQL DEVELOPER之类的工具,在使用DEBUG调试PL/SQL代码是出现了错误或中止了会话,导致DBMS_PIPE调用中断。
对于这个错误可以安全的将其忽略掉。
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。