ORA-29807: specified operator does not exist

   dbca 创建数据库是出现两个 ORACLE 的两个错误

1   ORA-29807: specified operator does not exist
     在数据库创建过程的“创建数据字典视图”阶段中，您将接收到一个 ORA-29807 错误。如果您搜索日志文件，您将看到以下内容：

    drop operator XMLSequence

    * ERROR at line 1:

    ORA-29807:specified operator does not exist

    这是一个已知的问题 (Bug:2686156)，并且可被忽略。要继续数据库创建过程，请单击 “Ignore” 按钮

     安装完成后，在$ORACLE_HOME/rdbms/admin 目录下运行utlrp.sql ，用于修补ORA-29807 错误。

     解释

     ORA-29807: specified operator does not exist
    This is a known issue (bug 2925665). You can click on the "Ignore" button to continue.
    Once DBCA has completed database creation, remember to run the 'prvtxml.plb' scrīpt
    from $ORACLE_HOME/rdbms/admin independently, as the user SYS. It is also advised
    to run the 'utlrp.sql' scrīpt to ensure that there are no invalid objects in the database at this time.

 

   修复这个 BUG ，登陆 SQLPLUS

  # sqlplus "sys/system as sysdba"

 

   SQL*Plus: Release 9.2.0.4.0 - Production on Thu Nov 1 15:52:14 2007

 

   Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

 

   Connected to:

   Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production

   With the Partitioning, OLAP and Oracle Data Mining options

   JServer Release 9.2.0.4.0 - Production

 

   SQL>@/oracle/app/oracle/product/9.2.0.4/rdbms/admin/ utlrp.sql

   问题好象已经解决

转载于:https://www.cnblogs.com/CBDoctor/archive/2013/03/19/2969511.html