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

本文介绍了解决Oracle 9i RAC数据库创建过程中出现ORA-29807错误的方法。该错误是由于Oracle的一个已知bug导致的,可通过点击Ignore继续安装并运行特定脚本来解决。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

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
基本 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 ***

 

 

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" 按钮:

### 解决 Oracle 19c RAC 使用 SCAN IP 遇到 ORA-12514 错误的方法 #### 一、检查 Listener 日志文件 当遇到 ORA-12514 错误时,应首先查看 Listener 的日志文件来获取更多信息。对于 Oracle RAC 环境而言,SCAN IP 对应的监听器日志通常位于 `/oracle/app/grid/diag/tnslsnr/<节点名称>/listener_scan1/alert/log.xml` 文件内[^1]。 #### 二、验证服务名配置 确认 `tnsnames.ora` 中定义的服务名是否正确无误。该文件存在于 `$ORACLE_HOME/network/admin` 目录下,在此文件中应当能够找到对应数据库实例的服务名 (SERVICE_NAME),这有助于确保客户端请求能被正确路由至目标实例[^2]。 #### 三、调整 listener.ora 设置 如果上述两项均未发现问题,则需进一步审查 `listener.ora` 文件中的设置。特别是针对 RAC 架构下的多实例环境,可能需要特别关注如下参数: ```plaintext LISTENER_SCAN1 = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = zg2-scan.example.com)(PORT = 1521)) ) ) SID_LIST_LISTENER_SCAN1= (SID_LIST= (SID_DESC= (GLOBAL_DBNAME=orclpdb) (ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1) (SID_NAME=orclpdb) ) ) ``` 以上示例展示了如何为 SCAN 列表添加 SID 描述信息,其中包含了全局数据库名称 GLOBAL_DBNAME 和对应的 ORACLE_HOME 路径以及 SID 名称。这些条目应该与实际部署情况相匹配[^4]。 #### 四、重启监听进程和服务注册过程 完成必要的修改后,议执行以下命令重新启动监听程序并促使各节点上的服务再次向监听器注册自己: ```bash $ lsnrctl stop LISTENER_SCAN1 $ lsnrctl start LISTENER_SCAN1 ``` 随后可以通过 `lsnrctl services LISTENER_SCAN1` 来检验是否有预期的服务已经成功挂载到了指定端口上[^3]。
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值