Step1:
Update /etc/hosts file with new Goldengate VIP
vi /etc/hosts
#Goldengate
192.168.1.23 goldengate-vip gg-vip
##Update /etc/hosts Completed##
Step2:
Create new vip with root user using "appvipcfg"
/u01/app/12.1.0.2/grid/bin/appvipcfg create -network=1 -ip=192.168.1.23 -vipname=goldengate-vip -user=root
#-----
[root@tnc1 ~]# crsctl stat res -p |grep -ie .network -ie subnet |grep -ie name -ie subnet
REGISTRATION_INVITED_SUBNETS=
NAME=ora.net1.network
USR_ORA_SUBNET=192.168.1.0
Step3:
Set permissions for oracle on new goldengate VIP
[root@tnc1 ~]# /u01/app/12.1.0.2/grid/bin/crsctl setperm resource goldengate-vip -u user:oracle:r-x
#------
checking status of resources
[root@tnc1 ~]# crsctl status resource -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.FRA.dg
ONLINE ONLINE tnc1 STABLE
ONLINE ONLINE tnc2 STABLE
ora.GRID.dg
ONLINE ONLINE tnc1 STABLE
ONLINE ONLINE tnc2 STABLE
ora.LISTENER.lsnr
ONLINE ONLINE tnc1 STABLE
ONLINE OFFLINE tnc2 STABLE
ora.NEVOT.dg
ONLINE ONLINE tnc1 STABLE
ONLINE ONLINE tnc2 STABLE
ora.OCNEW.dg
ONLINE ONLINE tnc1 STABLE
ONLINE ONLINE tnc2 STABLE
ora.SDXH.dg
ONLINE ONLINE tnc1 STABLE
ONLINE ONLINE tnc2 STABLE
ora.asm
ONLINE ONLINE tnc1 Started,STABLE
ONLINE ONLINE tnc2 Started,STABLE
ora.net1.network
ONLINE ONLINE tnc1 STABLE
ONLINE OFFLINE tnc2 STABLE
ora.ons
ONLINE ONLINE tnc1 STABLE
ONLINE OFFLINE tnc2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
goldengate-vip
1 OFFLINE OFFLINE STABLE
ora.LISTENER_SCAN1.lsnr
Step4:
Start new Goldengate VIP with Oracle User:
[oracle@tnc1 ~]$ crsctl start resource goldengate-vip
CRS-2672: Attempting to start 'goldengate-vip' on 'tnc2'
CRS-2676: Start of 'goldengate-vip' on 'tnc2' succeeded
[oracle@tnc1 ~]$ crsctl status resource goldengate-vip
NAME=goldengate-vip
TYPE=app.appvipx.type
TARGET=ONLINE
STATE=ONLINE on tnc2
Step5:
ping new Goldengate VIP
[oracle@tnc1 ~]$ ping -c4 goldengate-vip
PING goldengate-vip (10.10.10.191) 56(84) bytes of data.
64 bytes from goldengate-vip (10.10.10.191): icmp_seq=1 ttl=64 time=2.43 ms
64 bytes from goldengate-vip (10.10.10.191): icmp_seq=2 ttl=64 time=0.328 ms
64 bytes from goldengate-vip (10.10.10.191): icmp_seq=3 ttl=64 time=0.458 ms
64 bytes from goldengate-vip (10.10.10.191): icmp_seq=4 ttl=64 time=0.476 ms
--- goldengate-vip ping statistics ---
4 packets transmitted, 4 received, 0% packet loss, time 3010ms
rtt min/avg/max/mdev = 0.328/0.923/2.431/0.872 ms
New VIP is configured for Goldengate for Automatic Failover
--Nikhil Tatineni--
--12c GoldenGate--