ITPub博客

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

ORA-600(qerrmOStart2)(972)错误

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

关于ORA-600[qerrmOStart2]已经碰到第三次不同的错误了,简单记录一下这个问题。

 

 

数据库版本为10.2.0.5 RAC for Linux X86-64,错误信息为:

Fri Jun 29 14:53:29 CST 2012
Errors in file /opt/app/oracle/admin/ora/udump/ora2_ora_5832.trc:
ORA-00600: internal error code, arguments: [qerrmOStart2], [972], [ORA-00972: identifier is too long
], [], [], [], [], []
Fri Jun 29 14:53:36 CST 2012
Trace dumping is performing id=[cdmp_20120629145336]
Fri Jun 29 14:53:36 CST 2012
Errors in file /opt/app/oracle/admin/ora/udump/ora2_ora_5832.trc:
ORA-07445: exception encountered: core dump [qerrmOdcl()+47] [SIGSEGV] [Address not mapped to object] [0x000000008] [] []
ORA-00600: internal error code, arguments: [qerrmOStart2], [972], [ORA-00972: identifier is too long
], [], [], [], [], []
Fri Jun 29 14:53:58 CST 2012
Errors in file /opt/app/oracle/admin/ora/udump/ora2_ora_3843.trc:
ORA-00600: internal error code, arguments: [qerrmOStart2], [972], [ORA-00972: identifier is too long
], [], [], [], [], []
Fri Jun 29 14:53:59 CST 2012
Errors in file /opt/app/oracle/admin/ora/udump/ora2_ora_3843.trc:
ORA-07445: exception encountered: core dump [qerrmOdcl()+47] [SIGSEGV] [Address not mapped to object] [0x000000008] [] []
ORA-00600: internal error code, arguments: [qerrmOStart2], [972], [ORA-00972: identifier is too long
], [], [], [], [], []
Fri Jun 29 14:53:59 CST 2012
Trace dumping is performing id=[cdmp_20120629145359]
Fri Jun 29 14:54:35 CST 2012
Trace dumping is performing id=[cdmp_20120629145500]

和以前一样,导致600错误的根源是第二个参数972错误。由于在SQL处理过程中出现了长度超过30的标识符,从而导致了这个600错误。

因此可以将这个ORA-600[qerrmOStart2][972]等价的当做ORA-00972: identifier is too long错误来处理。

 

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

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

注册时间:2007-12-29

  • 博文量
    1964
  • 访问量
    11085797