ITPub博客

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

ORA-29807: specified operator does not exist

原创 Linux操作系统 作者:paulyibinyi 时间:2009-02-10 07:49:56 0 删除 编辑

    我们在装完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 ***

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

请登录后发表评论 登录
全部评论
学习数据库

注册时间:2007-12-11

  • 博文量
    902
  • 访问量
    6566654