Skip to main content

Hard dependency with ip address Oracle RAC Cluster.



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

Popular posts from this blog

19C NID ( Rename Database)

 [oracle@localhost ~]$ nid DBNEWID: Release 19.0.0.0.0 - Production on Thu Dec 23 00:05:36 2021 Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved. Keyword     Description                    (Default) ---------------------------------------------------- TARGET      Username/Password              (NONE) DBNAME      New database name              (NONE) LOGFILE     Output Log                     (NONE) REVERT      Revert failed change           NO SETNAME     Set a new database name only   NO APPEND      Append to output log           NO HELP        Displays these messages    ...

ORA-01017/ORA-28000 with AUDIT_TRAIL

With default profile in Oracle 11g, accounts are automatically locked 1 day ( PASSWORD_LOCK_TIME ) after 10 failed login attempt ( FAILED_LOGIN_ATTEMPTS ): SQL > SET lines 200 SQL > SET pages 200 SQL > SELECT * FROM dba_profiles WHERE PROFILE = 'DEFAULT' ORDER BY resource_name; PROFILE                         RESOURCE_NAME                      RESOURCE LIMIT ------------------------------ -------------------------------- -------- ---------------------------------------- DEFAULT                         COMPOSITE_LIMIT                 ...