ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-600(kgavsd_3)错误

ORA-600(kgavsd_3)错误

原创 Linux操作系统 作者:yangtingkun 时间:2012-05-05 23:53:59 0 删除 编辑

客户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博客 ” ,链接:http://blog.itpub.net/4227/viewspace-722853/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
暂无介绍

注册时间:2007-12-29

  • 博文量
    1955
  • 访问量
    10367081