今天小麦苗给大家分享的是将RAC软件转换为单实例软件。
将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部分,我们可以删除,也可以保留。
注意:本文内容太多,公众号有字数限制,全文可以参考http://blog.itpub.net/26736162/viewspace-2155632/