集群状态:
[root@rac1 oracle]# crsctl check crs
Failure 1 contacting CSS daemon
Cannot communicate with CRS
Cannot communicate with EVM
1、两个节点分别删除集群配置
$CRS_HOME/install/rootdelete.sh
2、任何一节点删除集群
$CRS_HOME/install/rootdeinstall.sh
3、节点一重新执行root.sh脚本
./root.sh
4、节点二执行root.sh脚本
./root.sh
5、节点二执行vipca配置vip资源
(这里我们需要执行netca来配置监听信息)
6、使用oracle用户注册ASM
srvctl add asm -n rac1 -i +ASM1 -o /u01/app/oracle/product/db
srvctl add asm -n rac2 -i +ASM2 -o /u01/app/oracle/product/db
7、启动ASM资源
srvctl start asm -n rac1
srvctl start asm -n rac2
若在启动时报ORA-27550错误。是因为RAC无法确定使用哪个网卡作为Private Interconnect,
解决方法:在两个ASM的pfile文件里添加如下参数:
+ASM1.cluster_interconnects='10.10.10.10'
+ASM2.cluster_interconnects='10.10.10.20'
8、手工向OCR中添加DB信息:
[oracle@rac1 ~]$ srvctl add database -d orcl -o /u01/app/oracle/product/db
手工添加实例信息:
[oracle@rac1 ~]$ srvctl add instance -d orcl -i orcl1 -n rac1
[oracle@rac1 ~]$ srvctl add instance -d orcl -i orcl2 -n rac2
9、修改实例和ASM实例的依赖关系:
[oracle@rac1 ~]$ srvctl modify instance -d orcl -i orcl1 -s +ASM1
[oracle@rac1 ~]$ srvctl modify instance -d orcl -i orcl2 -s +ASM2
10、启动数据库:
[oracle@rac1 ~]$ srvctl start database -d orcl
[oracle@rac1 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.orcl.db application ONLINE ONLINE rac2
ora....l1.inst application ONLINE ONLINE rac1
ora....l2.inst application ONLINE ONLINE rac2
ora....SM1.asm application ONLINE ONLINE rac1
ora....C1.lsnr application ONLINE ONLINE rac1
ora.rac1.gsd application ONLINE ONLINE rac1
ora.rac1.ons application ONLINE ONLINE rac1
ora.rac1.vip application ONLINE ONLINE rac1
ora....SM2.asm application ONLINE ONLINE rac2
ora....C2.lsnr application ONLINE ONLINE rac2
ora.rac2.gsd application ONLINE ONLINE rac2
ora.rac2.ons application ONLINE ONLINE rac2
ora.rac2.vip application ONLINE ONLINE rac2
所有实例启动成功。
如果启动过程中也和起订ASM一样报错:
若也出现ORA-27550错误。也是因为RAC无法确定使用哪个网卡作为Private Interconnect,修改pfile参数在重启动即可解决。
SQL>alter system set cluster_interconnects='10.10.10.10' scope=spfile sid='orcl1';
SQL>alter system set cluster_interconnects='10.10.10.20' scope=spfile sid='orcl2';