Oracle 11gR201创建数据库时遭遇ORA-19202和ORA-31154的错误

OS版本：RHEL5.6-x86-64DB版本：Oracle 11.2.0.1今天在使用dbca创建数据库时，在进度条为61%的地方出错了，出现了XML文件解析错误的情况：[Thread-71] [ 2012-03-05 17:59:31.528 CST ] [BasicStep.handleNonIgnorableError:431] ORA-31154: invalid XML document
ORA-19202: Error occurred in XML processing
:msg
[Thread-73] [ 2012-03-05 21:15:46.317 CST ] [SQLEngine.done:2148] Done called
[Thread-73] [ 2012-03-05 21:15:46.317 CST ] [SQLEngine.spoolOff:2008] Setting spool off = /soft/oracle/cfgtoollogs/dbca/srcbda/cwmlite.log
[Thread-73] [ 2012-03-05 21:15:46.318 CST ] [BasicStep.configureSettings:304] messageHandler being set=oracle.sysman.assistants.util.UIMessageHandler@6719b1ca
oracle.sysman.assistants.util.step.StepExecutionException: ORA-31154: invalid XML document
ORA-19202: Error occurred in XML processing

        at oracle.sysman.assistants.util.step.dboption.CWMLiteDBOptionStep.executeImpl（CWMLiteDBOptionStep.java:168）
        at oracle.sysman.assistants.util.step.BasicStep.execute（BasicStep.java:210）
        at oracle.sysman.assistants.util.step.Step.execute（Step.java:140）
        at oracle.sysman.assistants.util.step.StepContext$ModeRunner.run（StepContext.java:2667）
        at java.lang.Thread.run（Thread.java:595）
而且很奇怪的一个问题是，我之前在这台服务器上已经创建过两个使用ASM的数据库了，都没有问题，唯一不同的地方就是支持创建的数据库使用的文件系统。于是在MOS上查了一下，发现这是Oracle在11.2.0.1里面的一个Bug 9242171，在11.2.0.2里面已经修复，不过还好有相应的补丁p9242171。
把补丁打上去就好了，忽然觉得Oracle11g好的Bug啊，哎！[oracle@instsvr1 ~]$ unzip p9242171_112010_Generic.zip
[oracle@instsvr1 ~]$ cd /home/oracle/9242171[oracle@instsvr1 9242171]$ /soft/oracle/product/11.2.0/dbh/OPatch/opatch apply
Invoking OPatch 11.1.0.6.6

Oracle Interim Patch Installer version 11.1.0.6.6
Copyright （c） 2009, Oracle Corporation. All rights reserved.

Oracle Home       : /soft/oracle/product/11.2.0/dbh
Central Inventory : /soft/oraInventory
   from           : /etc/oraInst.loc
OPatch version    : 11.1.0.6.6
OUI version       : 11.2.0.1.0
OUI location      : /soft/oracle/product/11.2.0/dbh/oui
Log file location : /soft/oracle/product/11.2.0/dbh/cfgtoollogs/opatch/opatch2012-03-06_12-48-52PM.log

Patch history file: /soft/oracle/product/11.2.0/dbh/cfgtoollogs/opatch/opatch_history.txt

ApplySession applying interim patch "9242171" to OH "/soft/oracle/product/11.2.0/dbh"

Running prerequisite checks...

OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.

Backing up files and inventory （not for auto-rollback） for the Oracle Home
Backing up files affected by the patch "9242171" for restore. This might take a while...
Backing up files affected by the patch "9242171" for rollback. This might take a while...

Patching component oracle.rdbms, 11.2.0.1.0...
Copying file to "/soft/oracle/product/11.2.0/dbh/rdbms/admin/catqm.sql"
Copying file to "/soft/oracle/product/11.2.0/dbh/rdbms/admin/xdbe111.sql"
Copying file to "/soft/oracle/product/11.2.0/dbh/rdbms/admin/xdbdbmig.sql"

Patching component oracle.rdbms.dbscripts, 11.2.0.1.0...
Copying file to "/soft/oracle/product/11.2.0/dbh/rdbms/admin/catqm.sql"
Copying file to "/soft/oracle/product/11.2.0/dbh/rdbms/admin/xdbe111.sql"
Copying file to "/soft/oracle/product/11.2.0/dbh/rdbms/admin/xdbdbmig.sql"
ApplySession adding interim patch "9242171" to inventory

Verifying the update...
Inventory check OK: Patch ID 9242171 is registered in Oracle Home inventory with proper meta-data.
Files check OK: Files from Patch ID 9242171 are present in Oracle Home.

OPatch succeeded.

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------【MOS文档】

ORA-31154, ORA-19202, LSX-00023 Creating XDB Enabled Database Using DBCA [ID 1207444.1]

		修改时间 08-OCT-2010 类型 PROBLEM 状态 PUBLISHED

In this Document
  Symptoms
  Cause
  Solution

Applies to:

Oracle Server - Enterprise Edition - Version: 11.2.0.1 and later [Release: 11.2 and later ]
Information in this document applies to any platform.

Symptoms

During database creation process using DBCA the creation fails when it reaches the XDB configuration.

From the xdb_protocol.log:

ERROR at line 1:
ORA-31154: invalid XML document
ORA-19202: Error occurred in XML processing
LSX-00023: unknown namespace URI

Cause

The error is reasoned by unpublished Bug 9242171
Abstract: INVALID XML DOCUMENT ERROR WHILE CREATING RAC DATABASE

Solution

This issue is fixed in release 11.2.0.2
For release 11.2.0.1 install generic patch 9242171

There is no workaround for this issue.DBCA创建ASM数据库时遇到ORA-01031Oracle 11.2.0.1关于NLS_LENGTH_SEMANTICS的一个Bug相关资讯 Oracle错误代码

Oracle错误代码大全（02/16/2015 21:31:57）
Oracle中登陆时报ORA-28000: the （03/06/2013 20:06:23）
Oracle 11g startup时报ORA-03113 （02/21/2013 17:25:55）

Oracle Grid Control OUI-25031错（03/09/2013 09:01:36）
ORA-04091:触发器/函数不能读（02/25/2013 08:28:13）
Oracle错误 ORA-12514 解决方法（02/18/2013 08:50:10）

本文评论查看全部评论（0）