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

0    80    1

Tags:

👉 本文共约855个字,系统预计阅读时间或需4分钟。

在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:

本人提供Oracle、MySQL、PG等数据库的培训和考证业务,私聊QQ646634621或微信db_bao,谢谢!

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

  1. Startup the database.

标签:

头像

小麦苗

学习或考证,均可联系麦老师,请加微信db_bao或QQ646634621

您可能还喜欢...

发表回复

您的电子邮箱地址不会被公开。 必填项已用*标注

14 − 7 =

 

嘿,我是小麦,需要帮助随时找我哦
  • 18509239930
  • 个人微信

  • 麦老师QQ聊天
  • 个人邮箱
  • 点击加入QQ群
  • 个人微店

  • 回到顶部
返回顶部