Chinaunix首页 | 论坛 | 博客
  • 博客访问: 195883
  • 博文数量: 33
  • 博客积分: 2020
  • 博客等级: 大尉
  • 技术积分: 380
  • 用 户 组: 普通用户
  • 注册时间: 2007-12-20 14:56
文章分类

全部博文(33)

文章存档

2010年(26)

2009年(7)

我的朋友

分类: Oracle

2010-08-11 13:14:36

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

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

In this Document
  
  
  


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.
阅读(2281) | 评论(0) | 转发(0) |
0

上一篇:ora-08104

下一篇:一个同事赠言

给主人留下些什么吧!~~