NON-RAC Database Startup Giving Error ORA-29702 (Doc ID 433310.1)

rongshiyuan發表於2014-05-13
DatabaseError

NON-RAC Database Startup Giving Error ORA-29702 (Doc ID 433310.1)


In this Document

Symptoms
Cause
Solution

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 and later
Oracle Solaris on SPARC (64-bit)
***Checked for relevance on 15-Jun-2012***

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.




來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/17252115/viewspace-1160556/，如需轉載，請註明出處，否則將追究法律責任。

相關文章