ITPub博客

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

ORA-600(kgantc_1)错误

原创 Linux操作系统 作者:yangtingkun 时间:2011-08-04 23:45:31 0 删除 编辑

客户碰到了这个错误,在这个错误出现同时,伴随着大量PL/SQL相关的错误信息。

 

 

详细的错误信息为:

Errors in file /opt/oracle/diag/rdbms/mobiledb_n/mobiledb/trace/mobiledb_ora_3450.trc (incident=48961):
ORA-00600:
内部错误代码, 参数: [kgantc_1], [0], [1], [], [], [], [], [], [], [], [], []
ORA-00604:
递归 SQL 级别 1 出现错误
ORA-06510: PL/SQL:
用户定义的异常错误未得到处理
ORA-06512:
"SYS.PBREAK", line 1087
ORA-06512:
"SYS.PBSDE", line 201
ORA-06510: PL/SQL:
用户定义的异常错误未得到处理
ORA-06512:
line 1
ORA-06510: PL/SQL:
用户定义的异常错误未得到处理
ORA-00604:
递归 SQL 级别 1 出现错误
ORA-06510: PL/SQL:
用户定义的异常错误未得到处理
ORA-06512:
"SYS.PBREAK", line 1087
ORA-06512:
"SYS.PBSDE", line 201
ORA-06510: PL/SQL:
用户定义的异常错误未得到处理
ORA-06512:
line 1
ORA-06512:
"HCONTENT.INFODLFLOG", line 13
ORA-06512:
line 3
Incident details in: /opt/oracle/diag/rdbms/mobiledb_n/mobiledb/incident/incdir_48961/mobiledb_ora_3450_i48961.trc
Thu Aug 04 12:17:41 2011
Dumping diagnostic data in directory=[cdmp_20110804121741], requested by (instance=1, sid=3450), summary=[incident=48961].
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file /opt/oracle/diag/rdbms/mobiledb_n/mobiledb/trace/mobiledb_ora_3450.trc:
ORA-00600:
内部错误代码, 参数: [kgantc_1], [0], [1], [], [], [], [], [], [], [], [], []
ORA-00604:
递归 SQL 级别 1 出现错误
ORA-06510: PL/SQL:
用户定义的异常错误未得到处理
.
.
.
Errors in file /opt/oracle/diag/rdbms/mobiledb_n/mobiledb/trace/mobiledb_ora_3450.trc:
ORA-00600:
内部错误代码, 参数: [kgantc_1], [0], [1], [], [], [], [], [], [], [], [], []
ORA-00604:
递归 SQL 级别 1 出现错误
ORA-06510: PL/SQL:
用户定义的异常错误未得到处理
ORA-06512:
"SYS.PBREAK", line 1087
ORA-06512:
"SYS.PBSDE", line 201
ORA-06510: PL/SQL:
用户定义的异常错误未得到处理
ORA-06512:
line 1
ORA-06510: PL/SQL:
用户定义的异常错误未得到处理
ORA-00604:
递归 SQL 级别 1 出现错误
ORA-06510: PL/SQL:
用户定义的异常错误未得到处理
ORA-06512:
"SYS.PBREAK", line 1087
ORA-06512:
"SYS.PBSDE", line 201
ORA-06510: PL/SQL:
用户定义的异常错误未得到处理
ORA-06512:
line 1
ORA-06512:
"HCONTENT.INFODLFLOG", line 13
ORA-06512:
line 3
Dumping diagnostic data in directory=[cdmp_20110804121745], requested by (instance=1, sid=3450), summary=[abnormal process termination].
Thu Aug 04 12:17:45 2011
Errors in file /opt/oracle/diag/rdbms/mobiledb_n/mobiledb/trace/mobiledb_ora_3450.trc (incident=60001):
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [kgantc_1], [0], [1], [], [], [], [], [], [], [], [], []
ORA-00604: error occurred at recursive SQL level 1
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "SYS.PBREAK", line 1087
ORA-06512: at "SYS.PBSDE", line 201
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at line 1
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-00604: error occurred at recursive SQL level 1
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "SYS.PBREAK", line 1087
ORA-06512: at "SYS.PBSDE", line 201
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at line 1
ORA-06512: at "HCONTENT.INFODLFLOG", line 13
ORA-06512: at line 3
Incident details in: /opt/oracle/diag/rdbms/mobiledb_n/mobiledb/incident/incdir_60001/mobiledb_ora_3450_i60001.trc
Errors in file /opt/oracle/diag/rdbms/mobiledb_n/mobiledb/incident/incdir_60001/mobiledb_ora_3450_i60001.trc:
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [kgantc_1], [0], [1], [], [], [], [], [], [], [], [], []
ORA-00604: error occurred at recursive SQL level 1
.
.
.

客户的数据库版本是11.2.0.2,而metalink上并没有这么新的版本的说明。不过Oracle的官方记录了类似情况,由于缺少权限,导致PL/SQL出现大量错误,从而最终引发了ORA-600(kgantc_1)的错误。

观察除了ORA-600(kgantc_1)以外的错误信息,问题多半是由于“PL/SQL: 用户定义的异常错误未得到处理”所致。和客户的DBA沟通,确认问题发生时刻,有开发程序员通过PLSQL DEVELOPER工具的DEBUG功能来执行PL/SQL代码。

显然是由于DEBUG过程中,出现了自定义的异常没有捕获的情况,从而引发了这个600错误。而解决问题的方法也很简单,如果不能避免DEBUG程序,那么起码在DEBUG的时候,确保捕获了所有的异常,并不会再次抛出。

 

 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/4227/viewspace-704166/,如需转载,请注明出处,否则将追究法律责任。

上一篇: ORA-600(17281)错误
请登录后发表评论 登录
全部评论
暂无介绍

注册时间:2007-12-29

  • 博文量
    1955
  • 访问量
    10539154