TOP

Oracle 11gR201创建数据库时遭遇ORA-19202和ORA-31154的错误(一)
2014-11-24 18:40:58 】 浏览:10218
Tags:Oracle 11gR201 创建 数据库时 遭遇 ORA-19202 ORA-31154 错误

OS版本:RHEL5.6-x86-64


今天在使用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 i

请关注公众号获取更多资料


Oracle 11gR201创建数据库时遭遇ORA-19202和ORA-31154的错误(一) https://www.cppentry.com/bencandy.php?fid=57&id=86594

首页 上一页 1 2 下一页 尾页 1/2/2
】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
上一篇DBCA创建ASM数据库时遇到ORA-01031 下一篇Oracle 11.2.0.1关于NLS_LENGTH_S..