Friday, March 4, 2016

Oracle GoldenGate: Creating Virtual IP address (VIP) to manage high availability


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--

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...