环境说明
上面的大概意思就是AL32UTF8字符集与XML的问题
aix 6.1+ oracle 11.2.0.3 + ASM
报错内容
ora-31061:XDB error . XML event error
ora-19202:Error occurred in XML processing
在进行到 adding oracle spatial的时候就报上面的错误
在metalink上查了下，发现一篇与之相关的bug，文档 ID 1498052.1
应用环境
Oracle Server - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.
Information in this document applies to any platform.
问题描述
On a database using the AL32UTF8 characterset, inserting into an XMLType column fails with the following errors:
ORA-31061: XDB error: XML event error
ORA-19202: Error occurred in XML processing
In line 19222 of orastream:
LPX-00217: invalid character 162 (U+00A2)
Statement which fails:
insert into MY_TABLE values (XMLType(bfilename('MY_COL', 'xxxxxxxxxxxx.xml'),nls_charset_id('AL32UTF8')));
The character (00A2) is a cent sign.
ORA-31061: XDB error: XML event error
ORA-19202: Error occurred in XML processing
In line 19222 of orastream:
LPX-00217: invalid character 162 (U+00A2)
Statement which fails:
insert into MY_TABLE values (XMLType(bfilename('MY_COL', 'xxxxxxxxxxxx.xml'),nls_charset_id('AL32UTF8')));
The character (00A2) is a cent sign.
原因分析
This is caused by the following unpublished bug:
Bug 12812148: ORA-31061 WHEN INSERT INTO XMLTYPE WITH SUPPLEMENTARY CHARACTERS
Bug 12812148: ORA-31061 WHEN INSERT INTO XMLTYPE WITH SUPPLEMENTARY CHARACTERS
解决方法
Bug 12812148 is fixed in 11.2.0.4 and 12.1 (future releases). The fix is also included in the following Windows Patch:
Patch 14613223: ORACLE 11G 11.2.0.3 PATCH 11 BUG FOR WINDOWS (64-BIT AMD64 AND INTEL EM64)
If a patch is not available for your release/platform, please log a Service Request and request a backport.
这个bug需要在11.2.0.4上才修复，补丁只有windows平台的。
我这里选择了忽略该错误
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/28697282/viewspace-1441328/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- CRS-1006 NO more members consider CRS-0215 could not start ora.rac1.vip
- 0506-342 The superblock on /dev/XXX is dirty,Run a full fsck to fix
- aix 无法mount 本地lv
- CRS-0215: Could not start resource 'ora.rac.rac2.inst'.
- Mount 参数配置 For Oracle file when use NFS on NAS devices
- oracle wait events(等待事件) 一览表
- 【BUG】crfclust.dbd变得非常大
- 【BUG】m000.trc ksugetosstat failed: op = ^P^A?`^G, location = SLSSTATMAXCP ()
- how to stop or start arch processes
- dbca建库，报错ORA-01092: ORACLE instance terminated
