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

Source: Internet
Author: User
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.

,

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.