NON-RAC Database Startup Giving Error ORA-29702 [ID 433310.1]

		修改时间 27-JUL-2010 类型 PROBLEM 状态 MODERATED

In this Document
Symptoms
Cause
Solution

Platforms: 1-914CU;

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.3 to 10.2.0.5 - Release: 10.2 to 10.2
Oracle Solaris on SPARC (64-bit)
***Checked for relevance on 25-Jul-2010***

Symptoms

While starting up the database, Getting error ORA-29702

Messages in the Alert Log file:

Cluster communication is configured to use the following interface(s) for this instance 192.168.193.2
Wed May 23 16:00:55 2007
cluster interconnect IPC version:Oracle UDP/IP (generic)
WARNING: Failed to set buffer limit on IPC interconnect socket Oracle requires that the
SocketReceive buffer size be tunable upto 1MB
Please make sure the kernel parameterwhich limits SO_RCVBUF value set by applications is atleast 1MB
MMNL started with pid=15, OS id=14908
Wed May 23 16:00:56 2007
starting up 1 shared server(s) ...
USER: terminating instance due to error 29702
Instance terminated by USER, pid = 14841

.

Cause

RDBMS install is not running on RAC but still it is assuming it to be RAC instance.

Cluster information required according to alert.log

.

Solution

1. Shutdown the database completely.

2. Relink with RAC OFF :

$ cd $ORACLE_HOME/rdbms/lib

$ make -f ins_rdbms.mk rac_off

$ make -f ins_rdbms.mk ioracle

3. Startup the database.

显示相关信息 相关的

产品

Oracle Database Products > Oracle Database > Oracle Database > Oracle Server - Enterprise Edition

错误

ORA-29702; ERROR 29702

[@more@]

ITPub博客

NON-RAC Database Startup Giving Error ORA-29702 [ID 433310.1]

Applies to:

Symptoms

Cause

Solution

最新文章