Oracle数据库出现ORA-29807: specified operator does not exist
Oracle数据库出现ORA-29807: specified operator does not exist
我们在装完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 existWorkaround:Click Ignore.
其实和bug 2925665是同一个错误
[table=98%]
[td=20%]Bug 号2925665
已归档24-APR-2003已更新11-DEC-2003
[td=20%]产品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
基本 BugN/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 ***