客户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调用中断。
对于这个错误可以安全的将其忽略掉。
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/4227/viewspace-722853/ ,如需转载,请注明出处,否则将追究法律责任。