ITPub博客

首页 > Linux操作系统 > Linux操作系统 > [原创]10202 上的又一新BUG(外部表的读取)

[原创]10202 上的又一新BUG(外部表的读取)

原创 Linux操作系统 作者:ZALBB 时间:2019-04-10 11:06:05 0 删除 编辑

WINDOWS2003,64B,ORACLE10202,

现象:使用外部表读取数据时,系统报:KUP-00552错误。

状况:

select">SYS@NCBI>select count(*) from T123456;
select count(*) from T123456
*
ERROR at line 1:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-00552: internal XAD package failed to load
ORA-06512: at "SYS.ORACLE_LOADER", line 19


Elapsed: 00:00:00.29


我根据错误信息:KUP-00552: internal XAD package failed to load
在METALINK上查找到相关文档。按照ORACLE的文档(Doc ID:
373168.1 )处理后,问题解决。其解释:

The issue is likely caused by Bug 5172459: 'KUP-00552 WHEN QUERYING EXTERNAL
TABLES IN 10.2.0.2' which is still open and active.

According to Bug 5172459, the problem appears to be that the
messages file for external tables ( kup.msb ) for non-english systems

解决方法:

Need to replace the language specific (non-english) kup.msb file
with the english version.

1. cd $ORACLE_HOME/rdbms/mesg
2. Replace with your installed languages file.
mv KUP.msb to KUP.msb.BAK
3. Copy version over current copy of kup msb file.
cp kupus.msb to KUP.msb
4. re-run the select against the external table

我实际的操作过程,就是:

该目录:$ORACLE_HOME/rdbms/mesg 下有两个文件:
kupzhs.msb 和 kupus.msb, 其默认使用了kupzhs.msb
此时,我把kupzhs.msb 重新命名为 kupzhs.msb.bak
之后在测试, OK:

select">SYS@NCBI>select count(*) from T123456;

COUNT(*)
----------
407

Elapsed: 00:00:01.01
SELECT">SYS@NCBI>SELECT * FROM V$VERSION;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bi
PL/SQL Release 10.2.0.2.0 - Production
CORE 10.2.0.2.0 Production
TNS for 64-bit Windows: Version 10.2.0.2.0 - Production
NLSRTL Version 10.2.0.2.0 - Production

Elapsed: 00:00:00.01
SYS@NCBI>

我猜测:数据库之所以默认选择使用kupzhs.msb 文件,是因为:
操作系统的控制面板下的 regional and language options 选项
里选择了(chinese RPC), 若改为(Englist United States), 则
数据库可能会使用 kupus.msb, 但这只是我的猜测,限于环境,我
无法作测试.

另外,文档上解释: 该BUG可能出现在所以平台上,

Oracle Server - Enterprise Edition - Version: 10.2.0.2.0
This problem can occur on any platform.

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

请登录后发表评论 登录
全部评论

注册时间:2018-08-15

  • 博文量
    46
  • 访问量
    34489