This discussion is archived
7 Replies Latest reply: Jun 25, 2013 3:16 AM by user12022918 RSS

Why starting a custom vip cluster start all databases?

Mr.D. Explorer
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points