Oracle 9i RAC建库过程报错：ORA-29807: specified operator does not exist

Oracle 9i RAC建库过程报错：ORA-29807: specified operator does not exist

这是oracle bug，针对这个bug描述如下：

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' script. from

$ORACLE_HOME/rdbms/admin independently, as the user SYS. It is also advised to run the

'utlrp.sql' script. to ensure that there are no invalid objects in the database at this

time.

解决方法：

安装完成后，执行以下两个脚本后可解决：

SQL> conn / as sysdba

Connected.

SQL>@$ORACLE_HOME/rdbms/admin/prvtxml.plb

SQL>@$ORACLE_HOME/rdbms/admin/utlrp.sql

 

 

 

这是Oracle 的bug , 可以忽略掉，安装完成后，在$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' script 
from $ORACLE_HOME/rdbms/admin independently, as the user SYS. It is also advised 
to run the 'utlrp.sql' script to ensure that there are no invalid objects in the database at this time.[@more@]

 

我们在装完oracle 9i软件后,用dbca工具创建数据库到一半时,有时会出现

ORA-29807: specified operator does not exist,这个时候我们安确定后,就能顺利执行,和创建数据库成功

,那为什么在创建过程中会出现这个错误呢,查了下metalink是bug,bug号为4270038 可以ignore掉

以下是bug说明

10.9 Bug 4270038

When using Database Configuration Assistant in standalone mode to create a database, the following error will occur:

ORA-29807: specified operator does not exist

Workaround:

Click Ignore.

其实和bug 2925665是同一个错误

 

Bug 号	2925665
已归档	24-APR-2003	已更新	11-DEC-2003
产品	Oracle Database Configuration Assistant	产品版本	9.2.0.3
平台	Microsoft Windows 2000	平台版本	2000
数据库版本	9.2.0.3	影响平台	Generic
优先级	Severe Loss of Service	状态	Closed, Code fix resolution verified
基本 Bug	N/A	修复产品版本	10.1.0.0

问题陈述:

WHILE CREATING DB BY DBCA, IT SHOWS ORA-29807 ERROR.

 

---

 

 

*** 04/24/03 06:14 pm ***

=========================

.

=========================

PROBLEM:

While creating DB by DBCA, it shows ORA-29807 error.

.

=========================

DIAGONOSTIC ANALYSIS:

During 'Creating Data Dictionary Views', DBCA shows ORA-29807 error.

.

This error outputs to 'CreateDBCatalog.log'.

---

drop operator XMLSequence

*

ERROR at line 1:

ORA-29807: specified operator does not exist

---

.

=========================

WORKAROUND:

Ignore this error.

.

========================

RELATED BUGS:

BUG#2686156

---

---

.

.

=========================

REPRODUCIBILITY:

100%

This is reproduced in Windows, Linux, Solaris, HP-UX, so should be

generic issue.

.

=========================

TESTCASE:

None. Please see 'Testcase step-by-step instructions:'

.

[Testcase step-by-step instructions:]

1. Start up DBCA.

2. Choose 'Create a database' on the first page and hit next.

3. Choose 'New Database' on the next page and proceed to last page

with default options selected.

4. Hit finish.

.

It starts creating database but during 'Creating Data Dictionary Views'

it gives the following error.

.

'ORA-29807: specified operator does not exist'

.

=========================

STACK TRACE:

None.

.

=========================

SUPPORTING INFORMATION:

None.

.

=========================

24 HOUR CONTACT INFORMATION FOR P1 BUGS:

N/A

.

=========================

DIAL-IN INFORMATION:

N/A

.

=========================

IMPACT DATE:

*** 04/24/03 06:17 pm *** (CHG: Sta->11)

*** 04/24/03 06:17 pm ***

*** 05/16/03 03:29 am ***

*** 06/20/03 03:17 am ***

*** 06/20/03 07:14 am *** (CHG: Asg->NEW OWNER)

*** 06/20/03 07:14 am *** (CHG: DevPri->2)

*** 06/20/03 11:29 am *** (CHG: Sta->80)

*** 06/20/03 11:29 am *** (CHG: Fixed->10.1.0.0)

*** 06/20/03 11:29 am ***

*** 12/11/03 04:08 pm *** (CHG: Sta->74)

*** 12/11/03 04:08 pm ***

 

 

ORA-01430 错误
在数据库创建过程的“增加 Oracle Spatial”阶段中，您将接收到一个 ORA-01430 错误。如果您搜索日志文件，您将看到以下内容：
(SDO_ROOT_MBR mdsys.sdo_geometry)
*
ERROR at line 2:
ORA-01430:column being added already exists in table
这是一个已知的问题，并可被忽略。要继续数据库创建过程，请单击 "Ignore" 按钮：