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平台的。
我这里选择了忽略该错误