Tuesday, May 3, 2016

Virtual IP address is not configured for cluster node

scenario:# Creating database using dbca in RAC cluster & failed with following error. 
Virtual IP address is not configured for cluster node " run /u01/app/11.2.0/grid/bin/srvctl as root to configure before performing the "create a database" operation 



-------#
We found, there is NO VIP on second node of RAC cluster #
Configured VIP on second node as follows 

On Node 1#
[oracle@tnc1 ~]$ srvctl config nodeapps -a
Network exists: 1/192.168.1.0/255.255.255.0/eth0, type static
VIP exists: /tnc1-vip/192.168.1.11/192.168.1.0/255.255.255.0/eth0, hosting node tnc1

On Node 2 #  As a root User #
[root@tnc2 grid]# srvctl add vip -n tnc2 -k 1 -A 192.168.1.21/255.255.255.0/eth0
[root@tnc2 grid]# srvctl start nodeapps -n tnc2

[root@tnc2 grid]# srvctl config nodeapps -a
Network exists: 1/192.168.1.0/255.255.255.0/eth0, type static
VIP exists: /tnc1-vip/192.168.1.11/192.168.1.0/255.255.255.0/eth0, hosting node tnc1
VIP exists: /192.168.1.21/192.168.1.21/192.168.1.0/255.255.255.0/eth0, hosting node tnc2

After creating VIP, Installed database successfully 

---Nikhil Tatineni--
---12c RAC---





Querys to monitor RAC

following few  Query's will help to find out culprits-  Query to check long running transaction from last 8 hours  Col Sid Fo...