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
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 ~]#