2 Replies Latest reply: Mar 16, 2013 7:34 AM by 606331 RSS

    UNABLETO PING APPLICATION VIP IN 11G R2 RAC

    935328
      Hi,

      I have 3-Node RAC running on OEL 5.4 and cluster version is 11.2.0.1. Some other required information are given below:-

      GNS is configured using static IP 192.9.201.180
      Corporate domain is example.com and GNS sub domain is cluster01.example.com

      I created an application VIP resource using command appvipcfg.

      # [root@host01 ~]# appvipcfg create -network=1 -ip=192.9.201.120 -vipname=myappvip1 -user=grid
      Production Copyright 2007, 2008, Oracle.All rights reserved
      2012-08-29 03:06:00: Creating Resource Type
      2012-08-29 03:06:00: Executing cmd: /u01/app/11.2.0/grid/bin/crsctl add type app.appvip.type -basetype cluster_resource -file /u01/app/11.2.0/grid/crs/template/appvip.type
      2012-08-29 03:06:01: Create the Resource
      2012-08-29 03:06:01: Executing cmd: /u01/app/11.2.0/grid/bin/crsctl add resource myappvip1 -type app.appvip.type -attr USR_ORA_VIP=192.9.201.120,START_DEPENDENCIES=hard(ora.net1.network) pullup(ora.net1.network),STOP_DEPENDENCIES=hard(ora.net1.network),ACL='owner:root:rwx,pgrp:root:r-x,other::r--,user:grid:r-x'

      I checked the status of the resource obviously it is offline now

      [grid@host01 ~]$ crsctl stat res myappvip1 -p
      NAME=myappvip1
      TYPE=app.appvip.type
      ACL=owner:root:rwx,pgrp:root:r-x,other::r--,user:grid:r-x
      ACTION_FAILURE_TEMPLATE=
      ACTION_SCRIPT=
      ACTIVE_PLACEMENT=0
      AGENT_FILENAME=%CRS_HOME%/bin/orarootagent%CRS_EXE_SUFFIX%
      AUTO_START=restore
      CARDINALITY=1
      CHECK_INTERVAL=1
      DEFAULT_TEMPLATE=
      DEGREE=1
      DESCRIPTION=Application VIP
      ENABLED=1
      FAILOVER_DELAY=0
      FAILURE_INTERVAL=0
      FAILURE_THRESHOLD=0
      HOSTING_MEMBERS=
      LOAD=1
      LOGGING_LEVEL=1
      NLS_LANG=US7ASCII
      NOT_RESTARTING_TEMPLATE=
      OFFLINE_CHECK_INTERVAL=0
      PLACEMENT=balanced
      PROFILE_CHANGE_TEMPLATE=
      RESTART_ATTEMPTS=0
      SCRIPT_TIMEOUT=60
      SERVER_POOLS=*
      START_DEPENDENCIES=hard(ora.net1.network) pullup(ora.net1.network)
      START_TIMEOUT=0
      STATE_CHANGE_TEMPLATE=
      STOP_DEPENDENCIES=hard(ora.net1.network)
      STOP_TIMEOUT=0
      UPTIME_THRESHOLD=7d
      USR_ORA_ENV=
      USR_ORA_VIP=192.9.201.120
      VERSION=11.2.0.1.0

      Now I started the resource

      [grid@host01 ~]$ crsctl start res myappvip1
      CRS-2672: Attempting to start 'myappvip1' on 'host03'
      CRS-2676: Start of 'myappvip1' on 'host03' succeeded

      As you can see it is started on host03..Now check the status of the resource

      [grid@host01 ~]$ crsctl stat res myappvip1 -p
      NAME=myappvip1
      TYPE=app.appvip.type
      ACL=owner:root:rwx,pgrp:root:r-x,other::r--,user:grid:r-x
      ACTION_FAILURE_TEMPLATE=
      ACTION_SCRIPT=
      ACTIVE_PLACEMENT=0
      AGENT_FILENAME=%CRS_HOME%/bin/orarootagent%CRS_EXE_SUFFIX%
      AUTO_START=restore
      CARDINALITY=1
      CHECK_INTERVAL=1
      DEFAULT_TEMPLATE=
      DEGREE=1
      DESCRIPTION=Application VIP
      ENABLED=1
      FAILOVER_DELAY=0
      FAILURE_INTERVAL=0
      FAILURE_THRESHOLD=0
      HOSTING_MEMBERS=
      LOAD=1
      LOGGING_LEVEL=1
      NLS_LANG=US7ASCII
      NOT_RESTARTING_TEMPLATE=
      OFFLINE_CHECK_INTERVAL=0
      PLACEMENT=balanced
      PROFILE_CHANGE_TEMPLATE=
      RESTART_ATTEMPTS=0
      SCRIPT_TIMEOUT=60
      SERVER_POOLS=*
      START_DEPENDENCIES=hard(ora.net1.network) pullup(ora.net1.network)
      START_TIMEOUT=0
      STATE_CHANGE_TEMPLATE=
      STOP_DEPENDENCIES=hard(ora.net1.network)
      STOP_TIMEOUT=0
      UPTIME_THRESHOLD=7d
      USR_ORA_ENV=
      USR_ORA_VIP=192.9.201.250
      VERSION=11.2.0.1.0

      I wonder IP got changed for myappvip1...I understand IP is assigned through DHCP as GNS is already configured but the problem is I am not able to ping application VIP resource using their name myappvip1 as you can see in below output.

      [grid@host01 ~]$ ping -c 3 192.9.201.250
      PING 192.9.201.250 (192.9.201.250) 56(84) bytes of data.
      64 bytes from 192.9.201.250: icmp_seq=1 ttl=64 time=0.799 ms
      64 bytes from 192.9.201.250: icmp_seq=2 ttl=64 time=0.176 ms
      64 bytes from 192.9.201.250: icmp_seq=3 ttl=64 time=0.179 ms

      --- 192.9.201.250 ping statistics ---
      3 packets transmitted, 3 received, 0% packet loss, time 2441ms
      rtt min/avg/max/mdev = 0.176/0.384/0.799/0.293 ms
      [grid@host01 ~]$
      [grid@host01 ~]$
      [grid@host01 ~]$
      [grid@host01 ~]$ ping myappvip1
      ping: unknown host myappvip1
      [grid@host01 ~]$
      [grid@host01 ~]$
      [grid@host01 ~]$ ping host01.cluster01.example.com
      PING host01.cluster01.example.com (192.9.201.244) 56(84) bytes of data.
      64 bytes from 192.9.201.244: icmp_seq=1 ttl=64 time=0.022 ms
      64 bytes from 192.9.201.244: icmp_seq=2 ttl=64 time=0.033 ms

      --- host01.cluster01.example.com ping statistics ---
      2 packets transmitted, 2 received, 0% packet loss, time 1205ms
      rtt min/avg/max/mdev = 0.022/0.027/0.033/0.007 ms


      [grid@host01 ~]$
      [grid@host01 ~]$ ping myappvip1.cluster01.example.com
      ping: unknown host myappvip1.cluster01.example.com

      I cannot use application VIP resource name in my action script as I am not able to ping it and even I cannot use Application VIP address as it is getting change whenever it failover to another node.

      Please help me how could I fix this problem?