11gR201创建数据库时遭遇ORA-19202和ORA-31154的错误
来源:互联网 发布:nba2k16罗伊捏脸数据 编辑:程序博客网 时间:2024/06/08 06:40
OS版本:RHEL5.6-x86-64
DB版本: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 9242171Abstract: INVALID XML DOCUMENT ERROR WHILE CREATING RAC DATABASE
Solution
This issue is fixed in release 11.2.0.2For release 11.2.0.1 install generic patch 9242171
There is no workaround for this issue.
- 11gR201创建数据库时遭遇ORA-19202和ORA-31154的错误
- 遭遇ORA-16047错误
- 遭遇ora-7445错误
- 遭遇ORA-01552错误
- 遭遇ORA-01552错误
- Oracle 数据库登录时出现ORA-12514 、ORA-01034、ORA-27101、ORA-01033 错误的解决
- Exadata遭遇ORA-27603和ORA-27626
- ORACLE9: 创建数据库 ora-01041 : hostdef 错误
- Oracle11gR2 创建数据库错误问题 ORA-12801
- 在linux上IMP6GB数据时遭遇ORA-3113"经典错误"的解决办法参考文档
- 在Windows上调整SGA大小遭遇ora-27100、ora-27102错误的处理方法
- 在Windows上调整SGA大小遭遇ORA-27100、ORA-27102错误的处理方法
- 手动创建数据库以及解决ora-01092和ora-12560
- expdp遭遇ORA-39006、ORA-39065、ORA-01403、ORA-39097错误
- RAC重启遭遇ORA-01078、ORA-01565、ORA-17503、ORA-12547错误
- eclispe连接oracle数据库的ORA-00604 ORA-12705错误
- 创建ora 数据库
- Oracle 11g参数修改错误导致数据库无法启动的处理方法.[ORA-01034,ORA-27101,ORA-00824]
- Nop-Profiler的改进方向,通过Miniprofiler设置仅对某些条件下的访问开放profiler trace<七>
- simplescalar under Ubuntu/在Ubuntu10.04下安装simplescalar
- Robotium_创建自己的证书文件以及为apk/zip文件签名
- 风雨20年:我所积累的20条编程经验
- Qzone背后的故事:沉甸甸的爱,沉甸甸的疼
- 11gR201创建数据库时遭遇ORA-19202和ORA-31154的错误
- Nop -关于Nopcommerce中的短消息模块<八>
- U盘的热拔插/自动挂载跟linux2.6 kernel、 udev、 hal、 dbus 、gnome-mount 、thunar的关系
- oracle删除表的所有数据truncate table
- python学习(一)
- UVa 10304. Optimal Binary Search Tree
- Linux下C语言编程
- SQL多表查询中的分页,字段组合综合实例解析
- python学习(二)