ORA - 29807

最新推荐文章于 2025-12-10 22:03:01 发布

原创最新推荐文章于 2025-12-10 22:03:01 发布 · 807 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

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

Oracle BUG 专栏收录该内容

2 篇文章

订阅专栏

ORA - 29807

***

Specified operator does not exist

***

指定的操作员不存在,这是一个Oracle系统存在的固定BUG,在创建DBCA时可以忽略继续安装.

***

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:2686156),并且可被忽略.要继续数据库创建过程,请单击"Ignore"按钮, 安装完成后,在$ORACLE_HOME/rdbms/admin 目录下运行 utlrp.sql, 用于修补ORA-29807 错误.

修复这个BUG，登陆SQLPLUS

SQL*Plus: Release 9.2.0.8.0 - Production on Tue Aug 10 10:15:42 2010

SQL> conn as sysdba
Enter user-name: sysdba
Enter password:
Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 235999648 bytes
Fixed Size                   450976 bytes
Variable Size             201326592 bytes
Database Buffers           33554432 bytes
Redo Buffers                 667648 bytes
Database mounted.
Database opened.

SQL> @/oracle/9i/rdbms/admin/utlrp.sql

PL/SQL procedure successfully completed.

Table created.

Index created.

Table created.

View created.

Package created.

No errors.

Package body created.

No errors.

PL/SQL procedure successfully completed.