Command error out due
to hard dependency with ip address
[-Node1]/app/grid/oracle/product/11.2.0/grid/bin>./crsctl relocate
resource RDBMS_DB -n Node2
CRS-2527: Unable to start
'RDBMS_DB' because it has a 'hard' dependency on 'sDB'
CRS-2525: All instances of
the resource 'sDB' are already running; relocate is not allowed because the
force option was not specified
CRS-4000: Command Relocate
failed, or completed with errors.
[-Node1]/app/grid/oracle/product/11.2.0/grid/bin>./crsctl relocate
resource sDB -n Node2
CRS-2529: Unable to act on 'DB'
because that would require stopping or relocating 'LISTENER_DB', but the force
option was not specified
CRS-4000: Command Relocate
failed, or completed with errors.
[-Node1]/app/grid/oracle/product/11.2.0/grid/bin>./crsctl relocate
resource LISTENER_DB -n Node2
CRS-2527: Unable to start
'LISTENER_DB' because it has a 'hard' dependency on 'sDB'
CRS-2525: All instances of
the resource 'sDB' are already running; relocate is not allowed because the
force option was not specified
CRS-4000: Command Relocate
failed, or completed with errors.
Find all details about
resource( marked in yellow are IP with listeners)
[-Node1]/app/grid/oracle/product/11.2.0/grid/bin>crsctl stat resource
RDBMS_DB -f
NAME=RDBMS_DB
TYPE=custom_rdbms
STATE=ONLINE
TARGET=ONLINE
ACL=owner:oracle:rwx,pgrp:dba:rwx,other::r--
ACTION_FAILURE_TEMPLATE=
ACTION_SCRIPT=/app/grid/oracle/product/11.2.0/grid/crs/public/act_db.pl
ACTIVE_PLACEMENT=0
AGENT_FILENAME=%CRS_HOME%/bin/scriptagent
AUTO_START=restore
CARDINALITY=1
CARDINALITY_ID=0
CHECK_INTERVAL=60
CREATION_SEED=188
DEFAULT_TEMPLATE=
DEGREE=1
DESCRIPTION=
ENABLED=1
FAILOVER_DELAY=0
FAILURE_INTERVAL=0
FAILURE_THRESHOLD=0
HOSTING_MEMBERS=Node1
ID=RDBMS_DB
LOAD=1
LOGGING_LEVEL=1
NOT_RESTARTING_TEMPLATE=
OFFLINE_CHECK_INTERVAL=0
ORA_HOME=/app/oracle/product/11.1.0/db
ORA_SID=DB
PLACEMENT=favored
PROFILE_CHANGE_TEMPLATE=
RESTART_ATTEMPTS=5
SCRIPT_TIMEOUT=60
SERVER_POOLS=
START_DEPENDENCIES=hard(ora.DATA_VMEITPRE.dg,ora.acfs.vg_DB.acfs,LISTENER_DB,sDB) weak(LISTENER_DB,uniform:ora.ons,uniform:ora.eons)
pullup(ora.DATA_VMEITPRE.dg)
START_TIMEOUT=60
STATE_CHANGE_TEMPLATE=
STOP_DEPENDENCIES=hard(intermediate:ora.asm,shutdown:ora.DATA_VMEITPRE.dg,shutdown:ora.acfs.vg_DB.acfs,shutdown:LISTENER_DB,shutdown:sDB)
STOP_TIMEOUT=60
UPTIME_THRESHOLD=1h
Resources are able to
move to other node once IP sDB
relocated to other node.
Stop Resources.
[-Node1]/app/grid/oracle/product/11.2.0/grid/bin>./crsctl stop res
LISTENER_DB
CRS-2673: Attempting to stop
'LISTENER_DB' on 'Node1'
CRS-2677: Stop of 'LISTENER_DB'
on 'Node1' succeeded
[-Node1]/app/grid/oracle/product/11.2.0/grid/bin>crsctl stop res
RDBMS_DB
CRS-2673: Attempting to stop
'RDBMS_DB' on 'Node1'
CRS-2677: Stop of 'RDBMS_DB'
on 'Node1' succeeded
[-Node1]/app/grid/oracle/product/11.2.0/grid/bin>crsctl stop res
RDBMS_DB
CRS-2673: Attempting to stop
'RDBMS_DB' on 'Node1'
CRS-2677: Stop of 'RDBMS_DB'
on 'Node1' succeeded
[-Node1]/app/grid/oracle/product/11.2.0/grid/bin>./crsctl relocate
resource sDB -n Node2
CRS-2673: Attempting to stop
'sDB' on 'Node1'
CRS-2677: Stop of 'sDB' on 'Node1'
succeeded
CRS-2672: Attempting to start
'sDB' on 'Node2'
CRS-2676: Start of 'sDB' on 'Node2'
succeeded
Start Resources:-
[-Node1]/app/grid/oracle/product/11.2.0/grid/bin>crsctl start res
LISTENER_DB
CRS-2672: Attempting to start
'LISTENER_DB' on 'Node2'
CRS-2676: Start of 'LISTENER_DB'
on 'Node2' succeeded
[-Node1]/app/grid/oracle/product/11.2.0/grid/bin>crsctl start res
RDBMS_DB
CRS-2672: Attempting to start
'RDBMS_DB' on 'Node2'
CRS-2676: Start of 'RDBMS_DB'
on 'Node2' succeeded
[-Node1]/app/grid/oracle/product/11.2.0/grid/bin>crsctl start res
RDBMS_DB
CRS-2672: Attempting to start
'RDBMS_DB' on 'Node2'
CRS-2676: Start of 'RDBMS_DB'
on 'Node2' succeeded
Comments
Post a Comment