ORA-29807: specified operator does not exist

it2022-05-08  6

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

相关资源:垃圾分类数据集及代码

最新回复(0)