Contact Premier Online Trainings Today
Premier Online Trainings

Oracle RAC DBA - Virtual IP address is not configured for cluster node

Date Added: 24 Mar.2020 Date Updated: 24 Mar.2020 Oracle RAC DBA Full Blog

virtuval ip address is not configured for cluster node as root user to configure

ISSUE:

virtuval ip address is not configured for cluster node as root user to configure it before performing the create a database operation

 

racvipcluster1.jpg

 

 

 

 

 

 

 

 

 

 

 

 

 

 

There is NO VIP on second node of RAC cluster #

Configured VIP on second node as follows 
 
First node
 
[oracle@jrac1 ~]$ . oraenv
ORACLE_SID = [PROD] ? +ASM1
The Oracle base has been set to /u01/app/oracle
[oracle@jrac1 ~]$ 
[oracle@jrac1 ~]$ srvctl config nodeapps -a
Network exists: 1/192.168.56.0/255.255.255.0/eth0, type static
VIP exists: /jrac1-vip/192.168.56.81/192.168.56.0/255.255.255.0/eth0, hosting node jrac1
[oracle@jrac1 ~]$ 
 
second node
 
[oracle@jrac2 ~]$ . oraenv
ORACLE_SID = [oracle] ? +ASM2
The Oracle base has been set to /u01/app/oracle
[oracle@jrac2 ~]$ 
 
[oracle@jrac2 ~]$ srvctl config nodeapps -a
Network exists: 1/192.168.56.0/255.255.255.0/eth0, type static
VIP exists: /jrac1-vip/192.168.56.81/192.168.56.0/255.255.255.0/eth0, hosting node jrac1
[oracle@jrac2 ~]$ exit
logout
 
 
On second node as a root User 
[root@jrac2 ~]# . oraenv
ORACLE_SID = [+ASM2] ? 
The Oracle base remains unchanged with value /u01/app/oracle
[root@jrac2 ~]# 
[root@jrac2 ~]# srvctl add vip -n jrac2 -k 1 -A 192.168.56.82/255.255.255.0/eth0
[root@jrac2 ~]# 
[root@jrac2 ~]# srvctl start nodeapps -n jrac2
 
[root@jrac2 ~]# srvctl config nodeapps -a
Network exists: 1/192.168.56.0/255.255.255.0/eth0, type static
VIP exists: /jrac1-vip/192.168.56.81/192.168.56.0/255.255.255.0/eth0, hosting node jrac1
VIP exists: /192.168.56.82/192.168.56.82/192.168.56.0/255.255.255.0/eth0, hosting node jrac2
[root@jrac2 ~]# 
 
racvipcluster2.jpg