将RAC软件转换为单实例软件

在rac环境中，只有在集群正常启动的情况下才能创建和启动单实例的数据库，否则报错：

[oracle@raclhr-11gR2-N1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Tue Jun 5 09:40:26 2018

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to an idle instance.

SYS@OGGS> startup

ORA-29702: error occurred in Cluster Group Service operation

SYS@OGGS>

解决办法：

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

1. Shutdown the database completely.

2. Relink with RAC OFF ，use oracle owner:

$ cd $ORACLE_HOME/rdbms/lib

$ make -f ins_rdbms.mk rac_off

$ make -f ins_rdbms.mk ioracle

1.Startup the database.

至于grid部分，我们可以删除，也可以保留。

单击此项可从收藏夹中删除 NON-RAC Database Startup Giving Error ORA-29702 (文档 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 Database - Enterprise Edition - Version 10.2.0.3 and later
Oracle Solaris on SPARC (64-bit)
Checked for relevance on 15-Jun-2012
Checked for relevance on 27-Aug-2014
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.