ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-29807: specified operator does not exist

ORA-29807: specified operator does not exist

原创 Linux操作系统 作者:gengzhizhen 时间:2009-02-27 11:38:16 0 删除 编辑
dbca创建数据库是出现两个ORACLE的两个错误
1ORA-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

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

下一篇: 今天太高兴
请登录后发表评论 登录
全部评论

注册时间:2009-02-09

  • 博文量
    119
  • 访问量
    206191