0 积分	1 好友	4 主题

发消息

[常规总体性能调优] ORA-00600[qctchr : bfl]

1^#

发表于 2012-12-20 14:18:55 | 查看: 7452| 回复: 4

环境：windows 2008 64bit+oracle11.2.0.1 RAC
问题描述：
通过sql server的透明网关，在oracle建立了一个名字叫hkdata的dblink，通过dblink访问sqlserver中的数据，用如下语句建立了一个视图（其中称重记录是sqlserver中的一个表名）：
create or replace view v_hkdb1 as
select "编号" as bdh,
   "收货单位" as shdw,
   "车牌号" as ch,
   "货名" as wpmc,
   "毛重" / 1000 as mz,
   "皮重" / 1000 as pz,
   "净重" / 1000 as jszl,
   '吨' as dw,
   "单价" as dj,
   "金额" as je,
   "送货单位" as ghdw,
   "操作员" as sby1bh
  from 称重记录@hkdata ;

执行中提示ORA-600错误，以下是alter日志部分：
ORA-00600: 内部错误代码, 参数: [qctchr : bfl], [52], [17], [2], [871], [1], [0], [], [], [], [], []
Thu Dec 20 13:12:33 2012
Errors in file e:\app\administrator\diag\rdbms\power\power1\trace\power1_ora_8224.trc  (incident=26978):
附件中是power1_ora_8224.trc

烦请大师们给点指导意见，谢谢！

power1_ora_8224.txt

3.6 KB, 下载次数: 712

分享0

收藏0 回复只看该作者道具举报

Liu Maclean(刘相兵

2^#

发表于 2012-12-20 14:34:43

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production + Windows NT Version V6.1 Service Pack 1

*** 2012-12-20 13:16:12.272
Incident 28819 created, dump file: e:\app\administrator\diag\rdbms\power\power1\incident\incdir_28819\power1_ora_8224_i28819.trc
ORA-00600: 内部错误代码, 参数: [HO define: Long fetch], [], [], [], [], [], [], [], [], [], [], []
DDE: Problem Key 'ORA 600 [qctchr : bfl]' was flood controlled (0x2) (incident: 28820)
*** 2012-12-20 13:18:36.229
ORA-00600: 内部错误代码, 参数: [qctchr : bfl], [52], [17], [2], [871], [1], [0], [], [], [], [], []
DDE: Problem Key 'ORA 600 [qctchr : bfl]' was flood controlled (0x2) (incident: 28821)

复制代码

提供的TRACE中无明确有用信息

回复只看该作者道具举报

Liu Maclean(刘相兵

3^#

发表于 2012-12-20 14:37:51

可能相关的 BUG:

Bug 8655191 ORA-600 [qctchr : bfl] [32767] from PLSQL in multibyte database

Ora-00600 [Ho Define: Long Fetch] With a Gateway Database Link

Applies to:
Oracle Database Gateway for SQL Server - Version 11.1.0.6 to 11.2.0.2 [Release 11.1 to 11.2]
Information in this document applies to any platform.
Symptoms
Accessing a table from a MS SQL Server DB via Database Gateway for MS SQL Server, an error occurs:
ORA-00600: internal error code, arguments: [HO define: Long fetch], [], [], [], [], [], [], []
Cause
Your problem occurs because in your SQL SERVER object (table or view), you have more than one column which is translated to LONG columns (in trace we get LONGVARCHAR).
Unfortunately, in Oracle we have limitations with LONG columns:
A table can contain only one LONG column.
See Note 463115.1 Restrictions on LONG Datatype