Oracle11gR201 encountered ORA-19202 and ORA-31154 errors when creating a database

OS Version: RHEL5.6-x86-64DB version: Oracle11.2.0.1 today when using dbca to create a database, an error occurred at the place where the progress bar is 61%, an XML file parsing error occurs

OS Version: RHEL5.6-x86-64DB version: Oracle 11.2.0.1 today when using dbca to create a database, an error occurred in the progress bar of 61%, an XML file parsing error

OS Version: RHEL5.6-x86-64

DB version: Oracle 11.2.0.1

When I used dbca to create a database today, an error occurred in the progress bar of 61%, and an XML file parsing error occurred:

[Thread-71] [17:59:31. 528 CST] [BasicStep. handleNonIgnorableError: 431]
The ORA-19202: Error occurred in XML processing
: Msg
[Thread-73] [21:15:46. 317 CST] [SQLEngine. done: 2148] Done called
[Thread-73] [21:15:46. 317 CST] [SQLEngine. spoolOff: 2008] Setting spool off =/soft/oracle/export toollogs/dbca/srcbda/cwmlite. log
[Thread-73] [21:15:46. 318 CST] [BasicStep. configureSettings: 304] messageHandler being set = oracle. sysman. assistants. util. UIMessageHandler @ 6719b1ca
Oracle. sysman. assistants. util. step. StepExecutionException:
The ORA-19202: Error occurred in XML processing

At oracle.sysman.assistants.util.step.dboption.CWMLiteDBOptionStep.exe cuteImpl (CWMLiteDBOptionStep. java: 168)
At oracle.sysman.assistants.util.step.BasicStep.exe cute (BasicStep. java: 210)
At oracle.sysman.assistants.util.step.Step.exe cute (Step. java: 140)
At oracle. sysman. assistants. util. step. StepContext $ ModeRunner. run (StepContext. java: 2667)
At java. lang. Thread. run (Thread. java: 595)

One strange problem is that I have already created twoASMThe only difference is that the created database is supported.File System.

So I checked the MOS and found that this is an Oracle file in 11.2.0.1.Bug 9242171The patch p9242171 has been fixed in 11.2.0.2.

Just put the patch on. I suddenly felt that Oracle11g had a good Bug!

[Oracle @ instsvr1 ~] $ Unzip p92421720.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/export toollogs/opatch/opatch2012-03-06_12-48-52PM.log

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

ApplySession applying interim patch '000000' 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 '000000' for restore. This might take a while...
Backing up files affected by the patch '000000' 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/xdbmig. 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/xdbmig. SQL"
ApplySession adding interim patch '000000' 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.

Zookeeper -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

[MOS documentation]

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

Time modified: 08---2010 type PROBLEM status PUBLISHED

In this Document

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
The ORA-19202: Error occurred in XML processing
LSX-00023: unknown namespace URI


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

SolutionThis 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.

,