ora_29807

最新推荐文章于 2024-10-07 12:14:39 发布

原创最新推荐文章于 2024-10-07 12:14:39 发布 · 393 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#oracle #database #数据库 #button #user #sql

在数据库创建过程的“创建数据字典视图”阶段中，您将接收到一个 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
问题好象已经解决