9i升级patchset后dbca建库报错bug

环境
操作系统：linux RHEL4.7
数据库软件版本：9.2.0.8

dbca建库，选择自定义数据库，在创建数据字典时一直报错(如图)，$ORACLE_BASE/admin/{ORACLE_SID}/create/CreateDBCatalog.log查看内容报错停留在
No errors.
No errors.
drop operator XMLSequence
*
ERROR at line 1:
ORA-29807: specified operator does not exis

 

metalink上给出解决方法ignore忽略即可，ID 237486.1。或为oracle的bug，在打上9i数据库patchset后建库的报错

ORA-29807 Signalled While Creating Database using DBCA [ID 237486.1]

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

Checked for relevance on 13-Mar-2007

fact: Oracle Server - Enterprise Edition 9.2
fact: Oracle Database Configuration Assistant  9.2
symptom: Error during Database Creation Process (DCP)
symptom: 'drop operator XMLSequence' fails
symptom: ORA-29807: Specified operator does not exist
change: A patchset has been installed on the Oracle Server 9.2.0.1 base
release
cause: The error is not masked by DBCA as an ignorable one

 

fix:

Ignore the error

QQ20111216143751.jpg

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/24005010/viewspace-713439/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24005010/viewspace-713439/