7 Replies Latest reply: Jun 25, 2013 5:16 AM by user12022918 RSS

    Why starting a custom vip cluster start all databases?

    Mr.D.
      Hi,
      i've a 11.2 with 4 nodes cluster env.
      I've created a custom vip as per note:

      *11gR2 VIP Does not Fail Over After Public Network Issue if Application VIP is ONLINE and Added With "appvipcfg create" [ID 1457380.1]*

      This is the type:
      # crsctl status type app.appvip_net1.type -p
      ATTRIBUTE=BASE_TYPE
      DEFAULT_VALUE=ora.cluster_vip_net1.type
      TYPE=STRING
      FLAGS=READONLY CONFIG REQUIRED
      ATTRIBUTE=TYPE_ACL
      DEFAULT_VALUE=owner:grid:rwx,pgrp:oinstall:rwx,other::r--
      TYPE=STRING
      FLAGS=READONLY CONFIG REQUIRED
      ATTRIBUTE=TYPE_NAME
      DEFAULT_VALUE=app.appvip_net1.type
      TYPE=STRING
      FLAGS=READONLY CONFIG REQUIRED
      and this is the vip resource:
      # crsctl status res ora.myvip.vip -p
      NAME=ora.myvip.vip
      TYPE=app.appvip_net1.type
      ACL=owner:root:rwx,pgrp:system:r-x,other::r--,user:grid:r-x,user:oraclex
      ACTION_FAILURE_TEMPLATE=
      ACTION_SCRIPT=
      ACTIVE_PLACEMENT=1
      AGENT_FILENAME=%CRS_HOME%/bin/orarootagent%CRS_EXE_SUFFIX%
      AUTO_START=restore
      CARDINALITY=1
      CHECK_INTERVAL=60
      CHECK_TIMEOUT=30
      DEFAULT_TEMPLATE=PROPERTY(RESOURCE_CLASS=vip)
      DEGREE=1
      DESCRIPTION=CRS resource type definition for cluster-aware VIP
      ENABLED=1
      FAILOVER_DELAY=0
      FAILURE_INTERVAL=0
      FAILURE_THRESHOLD=0
      GEN_USR_ORA_STATIC_VIP=
      GEN_USR_ORA_VIP=
      HOSTING_MEMBERS=node1 node2 node3 node4
      LOAD=1
      LOGGING_LEVEL=1
      NLS_LANG=
      NOT_RESTARTING_TEMPLATE=
      OFFLINE_CHECK_INTERVAL=0
      PLACEMENT=favored
      PROFILE_CHANGE_TEMPLATE=
      RESTART_ATTEMPTS=2
      SCRIPT_TIMEOUT=60
      SERVER_POOLS=*
      START_DEPENDENCIES=hard(ora.net1.network) pullup(ora.net1.network)
      START_TIMEOUT=100
      STATE_CHANGE_TEMPLATE=
      STOP_DEPENDENCIES=hard(ora.net1.network)
      STOP_TIMEOUT=100
      TYPE_VERSION=2.1
      UPTIME_THRESHOLD=1h
      USR_ORA_ENV=
      USR_ORA_VIP=10.4.33.123
      VERSION=
      In the cluster there are 2 rac dabase with only 2 active instances.
      When i relocate the vip from 1 node to another one, cluster try to start other inactive database instance.
      Why this? There is no start dependencies!

      Thank you.

      Edited by: Mr.D. on 12-dic-2012 2.41