管理ポリシー変更に伴うクラスターリソースパラメータの変化

Oracleの管理ポリシーをMANUALからAUTOMATICに変更するとクラスターリソースのパラメータも自動的に変更される。


## サービスの場合
#### 変更前の設定値
```
-- サービスの構成 --
[root@rac19c-node1 ~]# srvctl config service -d orcl -s test_pdb
Service name: test_pdb
Server pool:
Cardinality: 2
Service role: PRIMARY
Management policy: MANUAL　--★
DTP transaction: false
AQ HA notifications: false
Global: false
Commit Outcome: false
Failover type:
Failover method:
Failover retries:
Failover delay:
Failover restore: NONE
Connection Load Balancing Goal: LONG
Runtime Load Balancing Goal: NONE
TAF policy specification: NONE
Edition:
Pluggable database name: pdb
Hub service:
Maximum lag time: ANY
SQL Translation Profile:
Retention: 86400 seconds
Replay Initiation Time: 300 seconds
Drain timeout:
Stop option:
Session State Consistency

-- リソースの構成 --
[root@rac19c-node1 ~]# crsctl stat res ora.orcl.test_pdb.svc -p
NAME=ora.orcl.test_pdb.svc
TYPE=ora.service.type
ACL=owner:oracle:rwx,pgrp:oinstall:r--,other::r--,group:dba:r-x,group:oper:r-x,group:racdba:r-x,user:gri
ACTIONS=isJavaService,group:"dba",group:"oper",group:"racdba",user:"grid",user:"oracle" rf_action,group:
ACTION_SCRIPT=
ACTION_TIMEOUT=60
ACTIVE_PLACEMENT=0
AGENT_FILENAME=%CRS_HOME%/bin/oraagent%CRS_EXE_SUFFIX%
AGENT_PARAMETERS=
ALLOW_RESTART=default
AQ_HA_NOTIFICATION=0
AUTO_START=never　--★
CARDINALITY=2
CHECK_INTERVAL=0
CHECK_TIMEOUT=30
CLB_GOAL=LONG
CLEAN_TIMEOUT=60
COMMIT_OUTCOME=0
CSS_CRITICAL=no
DELETE_TIMEOUT=60
DESCRIPTION=Oracle Service resource
DRAIN_ID=
DRAIN_TIMEOUT=
DTP=0
EDITION=
ENABLED=1
FAILOVER_DELAY=0
FAILOVER_METHOD=
FAILOVER_RESTORE=NONE
FAILOVER_RETRIES=
FAILOVER_TYPE=
FAILURE_INTERVAL=0
FAILURE_THRESHOLD=0
GEN_SERVICE_NAME=test_pdb
GLOBAL=false
GSM_FLAGS=0
HOSTING_MEMBERS=
HUB_SERVICE=
IGNORE_TARGET_ON_FAILURE=no
INSTANCE_FAILOVER=1
INTERMEDIATE_TIMEOUT=0
LOAD=1
LOGGING_LEVEL=1
MANAGEMENT_POLICY=MANUAL
MAX_LAG_TIME=ANY
MODIFY_TIMEOUT=60
NLS_LANG=
OFFLINE_CHECK_INTERVAL=0
PLACEMENT=restricted
PLACEMENT_POLICY=
PLUGGABLE_DATABASE=pdb
RELOCATE_BY_DEPENDENCY=1
RELOCATE_KIND=online
REPLAY_INITIATION_TIME=300
RESET_SESSION_STATE=NONE
RESOURCE_GROUP=
RESTART_ATTEMPTS=0
RESTART_DELAY=0
RETENTION=86400
RF_PARAMETERS=
RF_SERVICE=0
RLB_GOAL=NONE
ROLE=PRIMARY
SCRIPT_TIMEOUT=60
SERVER_CATEGORY=
SERVER_POOLS=ora.orcl_test_pdb
SERVICE_NAME=test_pdb
SERVICE_NAME_PQ=
SERVICE_TYPE=MAIN
SESSION_NOREPLAY=false
SESSION_STATE_CONSISTENCY=DYNAMIC
SQL_TRANSLATION_PROFILE=
START_CONCURRENCY=0
START_DEPENDENCIES=hard(ora.orcl.db,type:ora.cluster_vip_net1.type) weak(type:ora.listener.type) pullup(
START_DEPENDENCIES_RTE_INTERNAL=<xml><Cond name="SERVICE_TYPE">MAIN</Cond><Cond name="isCluster">True</Cname="UPDATE_SERVICE_TYPE">False</Cond><Cond name="SERVICE_CARDINALITY">0</Cond><Cond name="ADD_PULLUP_Aond><Arg name="cluster_vip_net" type="ResList">ora.cluster_vip_net1.type</Arg></xml>
START_DEPENDENCIES_TEMPLATE=<xml><If cond="SERVICE_TYPE" value="PQ"> <Then>hard(global:<Res>{mainServiceard(global:<Res>{hubService}</Res>)</Then> </If><If cond="isCluster" value="True"> <Then><If cond="isCren(<Res>{service}</Res>)<If cond="ADD_PULLUP_ALWAYS_SVC" value="True"> <Then>pullup:always(<Res>global:{sase}</Res>)<If cond="UPDATE_SERVICE_TYPE" value="False"> <Then><If cond="SERVICE_CARDINALITY" value="1"> </If></Then> </If><If cond="ADD_PULLUP_ALWAYS_DB" value="True"> <Then>pullup:always(<Res>{database}</Reen><If cond="DB_MANAGEMENT_POLICY" op="neq" value="NORESTART"> <Then>pullup(<ResTypeList>{cluster_vip_ne</Then> <Else>hard(<Res>{database}</Res>)<If cond="ADD_PULLUP_ALWAYS_DB" value="True"> <Then>pullup:alwaPDATE_VIP_TYPE" value="True"> <Then><If cond="DB_MANAGEMENT_POLICY" op="neq" value="NORESTART"> <Then>pu value="True"> <Then><If cond="SERVICE_CARDINALITY" value="1"> <Then>dispersion(type:ora.service.type)</
START_TIMEOUT=600
STOP_CONCURRENCY=0
STOP_DEPENDENCIES=hard(intermediate:ora.orcl.db,type:ora.cluster_vip_net1.type)
STOP_DEPENDENCIES_RTE_INTERNAL=<xml><Cond name="isCluster">True</Cond><Cond name="isCreatePreconnectSrv"ra.cluster_vip_net1.type</Arg></xml>
STOP_DEPENDENCIES_TEMPLATE=<xml><If cond="isCluster" value="True"> <Then><If cond="isCreatePreconnectSrvatabase}</Res>)<If cond="isCluster" value="True"> <Then>hard(<ResTypeList>{cluster_vip_net}</ResTypeList
STOP_OPTION=
STOP_TIMEOUT=600
TABLE_FAMILY_ID=
TAF_FAILOVER_DELAY=
TAF_POLICY=NONE
TARGET_DEFAULT=default
```
```
管理ポリシーをMANUALからAUTOMATICに変更
[root@rac19c-node1 ~]# srvctl modify service -db orcl -s test_pdb -policy automatic
```
```
サービスの構成
[root@rac19c-node1 ~]# srvctl config service -d orcl -s test_pdb
Service name: test_pdb
Server pool:
Cardinality: 2
Service role: PRIMARY
Management policy: AUTOMATIC　--★
DTP transaction: false
AQ HA notifications: false
Global: false
Commit Outcome: false
Failover type:
Failover method:
Failover retries:
Failover delay:
Failover restore: NONE
Connection Load Balancing Goal: LONG
Runtime Load Balancing Goal: NONE
TAF policy specification: NONE
Edition:
Pluggable database name: pdb
Hub service:
Maximum lag time: ANY
SQL Translation Profile:
Retention: 86400 seconds
Replay Initiation Time: 300 seconds
Drain timeout:
Stop option:
Session State Consistency: DYNAMIC
GSM Flags: 0
Service is enabled
Preferred instances: orcl1,orcl2
Available instances: orcl3
CSS critical: no

リソースの構成
[root@rac19c-node1 ~]# crsctl stat res ora.orcl.test_pdb.svc -p
NAME=ora.orcl.test_pdb.svc
TYPE=ora.service.type
ACL=owner:oracle:rwx,pgrp:oinstall:r--,other::r--,group:dba:r-x,group:oper:r-x,group:racdba:r-x,user:grid:r-x
ACTIONS=isJavaService,group:"dba",group:"oper",group:"racdba",user:"grid",user:"oracle" rf_action,group:"dba",group:"oper",group:"racdba",user:"grid",user:"oracle"
ACTION_SCRIPT=
ACTION_TIMEOUT=60
ACTIVE_PLACEMENT=0
AGENT_FILENAME=%CRS_HOME%/bin/oraagent%CRS_EXE_SUFFIX%
AGENT_PARAMETERS=
ALLOW_RESTART=default
AQ_HA_NOTIFICATION=0
AUTO_START=restore　--★
CARDINALITY=2
CHECK_INTERVAL=0
CHECK_TIMEOUT=30
CLB_GOAL=LONG
CLEAN_TIMEOUT=60
COMMIT_OUTCOME=0
CSS_CRITICAL=no
DELETE_TIMEOUT=60
DESCRIPTION=Oracle Service resource
DRAIN_ID=
DRAIN_TIMEOUT=
DTP=0
EDITION=
ENABLED=1
FAILOVER_DELAY=0
FAILOVER_METHOD=
FAILOVER_RESTORE=NONE
FAILOVER_RETRIES=
FAILOVER_TYPE=
FAILURE_INTERVAL=0
FAILURE_THRESHOLD=0
GEN_SERVICE_NAME=test_pdb
GLOBAL=false
GSM_FLAGS=0
HOSTING_MEMBERS=
HUB_SERVICE=
IGNORE_TARGET_ON_FAILURE=no
INSTANCE_FAILOVER=1
INTERMEDIATE_TIMEOUT=0
LOAD=1
LOGGING_LEVEL=1
MANAGEMENT_POLICY=AUTOMATIC
MAX_LAG_TIME=ANY
MODIFY_TIMEOUT=60
NLS_LANG=
OFFLINE_CHECK_INTERVAL=0
PLACEMENT=restricted
PLACEMENT_POLICY=
PLUGGABLE_DATABASE=pdb
RELOCATE_BY_DEPENDENCY=1
RELOCATE_KIND=online
REPLAY_INITIATION_TIME=300
RESET_SESSION_STATE=NONE
RESOURCE_GROUP=
RESTART_ATTEMPTS=0
RESTART_DELAY=0
RETENTION=86400
RF_PARAMETERS=
RF_SERVICE=0
RLB_GOAL=NONE
ROLE=PRIMARY
SCRIPT_TIMEOUT=60
SERVER_CATEGORY=
SERVER_POOLS=ora.orcl_test_pdb
SERVICE_NAME=test_pdb
SERVICE_NAME_PQ=
SERVICE_TYPE=MAIN
SESSION_NOREPLAY=false
SESSION_STATE_CONSISTENCY=DYNAMIC
SQL_TRANSLATION_PROFILE=
START_CONCURRENCY=0
START_DEPENDENCIES=hard(ora.orcl.db,type:ora.cluster_vip_net1.type) weak(type:ora.listener.type) pullup(type:ora.cluster_vip_net1.type) pullup:always(ora.orcl.db)
START_DEPENDENCIES_RTE_INTERNAL=<xml><Cond name="SERVICE_TYPE">MAIN</Cond><Cond name="isCluster">True</Cond><Cond name="isCreatePreconnectSrv">False</Cond><Arg name="database" type="Res">ora.orcl.db</Arg><Cond name="UPDATE_SERVICE_TYPE">False</Cond><Cond name="SERVICE_CARDINALITY">0</Cond><Cond name="ADD_PULLUP_ALWAYS_DB">False</Cond><Cond name="UPDATE_VIP_TYPE">False</Cond><Cond name="DB_MANAGEMENT_POLICY">MANUAL</Cond><Arg name="cluster_vip_net" type="ResList">ora.cluster_vip_net1.type</Arg></xml>
START_DEPENDENCIES_TEMPLATE=<xml><If cond="SERVICE_TYPE" value="PQ"> <Then>hard(global:<Res>{mainService}</Res>)</Then> <Else>weak(type:ora.listener.type)</Else> </If><If cond="SERVICE_TYPE" value="RF"> <Then>hard(global:<Res>{hubService}</Res>)</Then> </If><If cond="isCluster" value="True"> <Then><If cond="isCreatePreconnectSrv" value="True"> <Then>hard(<Res>global:{service}</Res>)hard(<Res>{database}</Res>)exclusion(<Res>{service}</Res>)<If cond="ADD_PULLUP_ALWAYS_SVC" value="True"> <Then>pullup:always(<Res>global:{service}</Res>)</Then> <Else>pullup(<Res>global:{service}</Res>)</Else> </If></Then> <Else>hard(<Res>{database}</Res>)<If cond="UPDATE_SERVICE_TYPE" value="False"> <Then><If cond="SERVICE_CARDINALITY" value="1"> <Then><If cond="NET_NUM" op="neq" value="-1"> <Then>dispersion(type:ora.service.type)</Then> </If></Then> </If></Then> </If><If cond="ADD_PULLUP_ALWAYS_DB" value="True"> <Then>pullup:always(<Res>{database}</Res>) </Then> <Else>pullup(<Res>{database}</Res>) </Else> </If><If cond="UPDATE_VIP_TYPE" value="False"> <Then><If cond="DB_MANAGEMENT_POLICY" op="neq" value="NORESTART"> <Then>pullup(<ResTypeList>{cluster_vip_net}</ResTypeList>)</Then> </If></Then> </If></Else> </If>hard(<ResTypeList>{cluster_vip_net}</ResTypeList>)</Then> <Else>hard(<Res>{database}</Res>)<If cond="ADD_PULLUP_ALWAYS_DB" value="True"> <Then>pullup:always(<Res>{database}</Res>) </Then> <Else>pullup(<Res>{database}</Res>)</Else> </If></Else> </If><If cond="UPDATE_VIP_TYPE" value="True"> <Then><If cond="DB_MANAGEMENT_POLICY" op="neq" value="NORESTART"> <Then>pullup(<ResTypeList>{cluster_vip_net}</ResTypeList>)</Then> </If></Then> </If><If cond="UPDATE_SERVICE_TYPE" value="True"> <Then><If cond="SERVICE_CARDINALITY" value="1"> <Then>dispersion(type:ora.service.type)</Then> </If></Then> </If></xml>
START_TIMEOUT=600
STOP_CONCURRENCY=0
STOP_DEPENDENCIES=hard(intermediate:ora.orcl.db,type:ora.cluster_vip_net1.type)
STOP_DEPENDENCIES_RTE_INTERNAL=<xml><Cond name="isCluster">True</Cond><Cond name="isCreatePreconnectSrv">False</Cond><Arg name="database" type="Res">ora.orcl.db</Arg><Arg name="cluster_vip_net" type="ResList">ora.cluster_vip_net1.type</Arg></xml>
STOP_DEPENDENCIES_TEMPLATE=<xml><If cond="isCluster" value="True"> <Then><If cond="isCreatePreconnectSrv" value="True"> <Then>hard(<Res>global:{service}</Res>)</Then> </If></Then> </If>hard(<Res>intermediate:{database}</Res>)<If cond="isCluster" value="True"> <Then>hard(<ResTypeList>{cluster_vip_net}</ResTypeList>)</Then> </If></xml>
STOP_OPTION=
STOP_TIMEOUT=600
TABLE_FAMILY_ID=
TAF_FAILOVER_DELAY=
TAF_POLICY=NONE
TARGET_DEFAULT=default
TYPE_VERSION=3.2
UPTIME_THRESHOLD=1h
USER_WORKLOAD=yes
USE_STICKINESS=0
USR_ORA_DISCONNECT=false
USR_ORA_ENV=
USR_ORA_FLAGS=
USR_ORA_OPEN_MODE=
USR_ORA_OPI=false
USR_ORA_STOP_MODE=
WORKLOAD_CPU=0
WORKLOAD_CPU_CAP=0
WORKLOAD_MEMORY_MAX=0
WORKLOAD_MEMORY_TARGET=0
```
#### 変更箇所
```
↓ AUTO_STARTがneverからrestoreに変更された。
AUTO_START=never
AUTO_START=restore

↓ START_DEPENDENCIESのpullupにalwaysが追加された。
START_DEPENDENCIES=hard(ora.orcl.db,type:ora.cluster_vip_net1.type) weak(type:ora.listener.type) pullup(ora.orcl.db,type:ora.cluster_vip_net1.type)
START_DEPENDENCIES=hard(ora.orcl.db,type:ora.cluster_vip_net1.type) weak(type:ora.listener.type) pullup(type:ora.cluster_vip_net1.type) pullup:always(ora.orcl.db)
```
　

## DBの場合
#### 変更前
```
-- DBの構成 --
[root@rac19c-node1 ~]# srvctl config db -d orcl
Database unique name: orcl
Database name: orcl
Oracle home: /u01/app/oracle/product/19.0.0/dbhome_1
Oracle user: oracle
Spfile: +DATA/ORCL/PARAMETERFILE/spfile.275.1102246209
Password file: +DATA/ORCL/PASSWORD/pwdorcl.256.1102242983
Domain: oracle.com
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: MANUAL　--★
Server pools:
Disk Groups: DATA,RECO
Mount point paths:
Services: aaa,orcl_cdb,orcl_pdb,test_pdb
Type: RAC
Start concurrency:
Stop concurrency:
OSDBA group: dba
OSOPER group: oper
Database instances: orcl1,orcl2,orcl3
Configured nodes: rac19c-node1,rac19c-node2,rac19c-node3
CSS critical: no
CPU count: 0
Memory target: 0
Maximum memory: 0
Default network number for database services:
Database is administrator managed

--リソースの構成 --
[root@rac19c-node1 ~]# crsctl stat res ora.orcl.db -p
NAME=ora.orcl.db
TYPE=ora.database.type
ACL=owner:oracle:rwx,pgrp:oinstall:r--,other::r--,group:dba:r-x,group:oper:r-x,group:racdba:r-x,user:grid:r-x
ACTIONS=relocate_client,group:"dba",group:"oper",group:"racdba",user:"grid",user:"oracle" status_target,group:"dba",group:"oper",group:"racdba",user:"grid",user:"oracle" listJavaServices,group:"dba",group:"oper",group:"racdba",user:"grid",user:"oracle" isPUJSDone,group:"dba",group:"oper",group:"racdba",user:"grid",user:"oracle" unmonitor,user:"grid" serviceDrain,group:"dba",group:"oper",group:"racdba",user:"grid",user:"oracle" monitor,user:"grid" startoption,group:"dba",group:"oper",group:"racdba",user:"grid",user:"oracle"
ACTION_SCRIPT=
ACTION_START_OPTION=
ACTION_TIMEOUT=600
ACTIVE_PLACEMENT=0
AGENT_FILENAME=%CRS_HOME%/bin/oraagent%CRS_EXE_SUFFIX%
ALLOW_RESTART=default
AUTO_START=never　--★
CARDINALITY=3
CHECK_INTERVAL=900
CHECK_TIMEOUT=30
CLEAN_TIMEOUT=60
CLUSTER_DATABASE=true
CSS_CRITICAL=no
DATABASE_TYPE=RAC
DB_UNIQUE_NAME=orcl
DEFAULT_NETNUM=
DELETE_TIMEOUT=60
DESCRIPTION=Oracle Database resource
DISABLED_REASON=
DRAIN_ID=
DRAIN_TIMEOUT=
ENABLED=1
FAILOVER_DELAY=0
FAILURE_INTERVAL=60
FAILURE_THRESHOLD=1
GEN_AUDIT_FILE_DEST=/u01/app/oracle/admin/orcl/adump
GEN_RESTART=
GEN_RESTART@SERVERNAME(rac19c-node1)=StartCompleted
GEN_RESTART@SERVERNAME(rac19c-node2)=StartCompleted
GEN_RESTART@SERVERNAME(rac19c-node3)=StartCompleted
GEN_START_OPTIONS=
GEN_USR_ORA_INST_NAME=
GEN_USR_ORA_INST_NAME@SERVERNAME(rac19c-node1)=orcl1
GEN_USR_ORA_INST_NAME@SERVERNAME(rac19c-node2)=orcl2
GEN_USR_ORA_INST_NAME@SERVERNAME(rac19c-node3)=orcl3
HOSTING_MEMBERS=
IGNORE_TARGET_ON_FAILURE=no
INSTANCE_FAILOVER=0
INTERMEDIATE_TIMEOUT=0
JAVA_SERVICES=
LOAD=1
LOGGING_LEVEL=1
MANAGEMENT_POLICY=MANUAL
MODIFY_TIMEOUT=60
NLS_LANG=
OFFLINE_CHECK_INTERVAL=0
ONLINE_RELOCATION_TIMEOUT=0
ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1
ORACLE_HOME_OLD=
PATCH_IN_PROGRESS=false
PLACEMENT=restricted
PWFILE=+DATA/ORCL/PASSWORD/pwdorcl.256.1102242983
RANK=0
RELOCATE_ACTION=0
RELOCATE_BY_DEPENDENCY=1
RELOCATE_KIND=offline
RESOURCE_GROUP=
RESTART_ATTEMPTS=1
RESTART_DELAY=0
ROLE=PRIMARY
SCRIPT_TIMEOUT=60
SERVER_CATEGORY=
SERVER_POOLS=ora.orcl
SERVER_POOLS_PQ=
SERVER_POOLS_RF=
SERVICE_NAMES=
SPFILE=+DATA/ORCL/PARAMETERFILE/spfile.275.1102246209
START_CONCURRENCY=0
START_DEPENDENCIES=hard(uniform:global:ora.DATA.dg,uniform:global:ora.RECO.dg) weak(type:ora.listener.type,global:type:ora.scan_listener.type,uniform:ora.ons,global:ora.gns)
START_DEPENDENCIES_RTE_INTERNAL=<xml><Cond name="ASMClientMode">False</Cond><Cond name="ASMmode">remote</Cond><Arg name="dg" type="ResList">ora.DATA.dg,ora.RECO.dg</Arg><Arg name="acfs_or_nfs" type="ResList"></Arg><Cond name="OHResExist">False</Cond><Cond name="DATABASE_TYPE">RAC</Cond><Cond name="MANAGEMENT_POLICY">MANUAL</Cond><Arg name="acfs_and_nfs" type="ResList"></Arg></xml>
START_DEPENDENCIES_TEMPLATE=<xml>hard(<If cond="ASMClientMode" op="neq" value="True"><Then><If cond="ASMmode" value="remote"><Then><ResList>uniform:global:{dg}</ResList>,</Then><Else><ResList>{dg}</ResList>,</Else></If></Then></If><ResList>{acfs_or_nfs}</ResList><If cond="OHResExist" value="True"><Then>,<Res>{oraclehome}</Res></Then></If>) weak(<If cond="DATABASE_TYPE" op="eql" value="RAC|RACOneNode"><Then>type:ora.listener.type,global:type:ora.scan_listener.type,uniform:ora.ons,global:ora.gns</Then><Else>type:ora.listener.type,uniform:ora.ons</Else></If>) dispersion(<If cond="DATABASE_TYPE" value="RACOneNode"><Then><If cond="DB_CENTRIC" value="False"><Then>type:ora.database.type</Then></If></Then></If>) pullup(<If cond="ASMClientMode" op="neq" value="True"><Then><If cond="MANAGEMENT_POLICY" op="neql" value="MANUAL|NORESTART"><Then><If cond="ASMmode" value="remote"><Then><ResList>global:{dg}</ResList>,</Then><Else><ResList>{dg}</ResList>,</Else></If></Then></If></Then></If><ResList>{acfs_and_nfs}</ResList><If cond="OHResExist" value="True"><Then>,<Res>{oraclehome}</Res></Then></If>)</xml>
START_TIMEOUT=600
STOP_CONCURRENCY=0
STOP_DEPENDENCIES=hard(global::intermediate:ora.asm,global:shutdown:ora.DATA.dg,global:shutdown:ora.RECO.dg)
STOP_DEPENDENCIES_RTE_INTERNAL=<xml><Cond name="ASMClientMode">False</Cond><Cond name="DGExist">True</Cond><Cond name="ASMmode">remote</Cond><Arg name="dg" type="ResList">ora.DATA.dg,ora.RECO.dg</Arg><Arg name="acfs_same_as_oh" type="Res"></Arg><Arg name="acfs" type="ResList"></Arg><Cond name="OHResExist">False</Cond></xml>
STOP_DEPENDENCIES_TEMPLATE=<xml><If cond="ASMClientMode" op="neq" value="True"><Then><If cond="DGExist" value="True"><Then><If cond="ASMmode" value="remote"> <Then>hard(global:intermediate:ora.asm,<ResList>global:shutdown:{dg}</ResList>)</Then> <Else>hard(intermediate:ora.asm,<ResList>shutdown:{dg}</ResList>)</Else> </If></Then> </If>hard(<Res>{acfs_same_as_oh}</Res>,<ResList>intermediate:{acfs}</ResList>)</Then> <Else>hard(intermediate:<Res>{nfs}</Res>)</Else> </If><If cond="OHResExist" value="True"><Then>hard(intermediate: <Res>{oraclehome}</Res>)</Then></If></xml>
STOP_TIMEOUT=600
TARGET_DEFAULT=default
TARGET_NAME=
TARGET_TYPE=
TYPE_VERSION=3.3
UPTIME_THRESHOLD=1h
USER_WORKLOAD=yes
USE_QOS_DATA=no
USE_STICKINESS=0
USR_ORA_DB_NAME=orcl
USR_ORA_DOMAIN=oracle.com
USR_ORA_ENV=
USR_ORA_FLAGS=
USR_ORA_INST_NAME=
USR_ORA_INST_NAME@SERVERNAME(rac19c-node1)=orcl1
USR_ORA_INST_NAME@SERVERNAME(rac19c-node2)=orcl2
USR_ORA_INST_NAME@SERVERNAME(rac19c-node3)=orcl3
USR_ORA_OPEN_MODE=open
USR_ORA_OPI=false
USR_ORA_STOP_MODE=immediate
WORKLOAD_CPU=0
WORKLOAD_CPU_CAP=0
WORKLOAD_MEMORY_MAX=0
WORKLOAD_MEMORY_TARGET=0
```
```
[root@rac19c-node1 ~]# srvctl modify database -d orcl -policy AUTOMATIC
```
#### 変更後
```
[root@rac19c-node1 ~]# srvctl config db -d orcl
Database unique name: orcl
Database name: orcl
Oracle home: /u01/app/oracle/product/19.0.0/dbhome_1
Oracle user: oracle
Spfile: +DATA/ORCL/PARAMETERFILE/spfile.275.1102246209
Password file: +DATA/ORCL/PASSWORD/pwdorcl.256.1102242983
Domain: oracle.com
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC　--★
Server pools:
Disk Groups: DATA,RECO
Mount point paths:
Services: aaa,orcl_cdb,orcl_pdb,test_pdb
Type: RAC
Start concurrency:
Stop concurrency:
OSDBA group: dba
OSOPER group: oper
Database instances: orcl1,orcl2,orcl3
Configured nodes: rac19c-node1,rac19c-node2,rac19c-node3
CSS critical: no
CPU count: 0
Memory target: 0
Maximum memory: 0
Default network number for database services:
Database is administrator managed

[root@rac19c-node1 ~]# crsctl stat res ora.orcl.db -p
NAME=ora.orcl.db
TYPE=ora.database.type
ACL=owner:oracle:rwx,pgrp:oinstall:r--,other::r--,group:dba:r-x,group:oper:r-x,group:racdba:r-x,user:grid:r-x
ACTIONS=relocate_client,group:"dba",group:"oper",group:"racdba",user:"grid",user:"oracle" status_target,group:"dba",group:"oper",group:"racdba",user:"grid",user:"oracle" listJavaServices,group:"dba",group:"oper",group:"racdba",user:"grid",user:"oracle" isPUJSDone,group:"dba",group:"oper",group:"racdba",user:"grid",user:"oracle" unmonitor,user:"grid" serviceDrain,group:"dba",group:"oper",group:"racdba",user:"grid",user:"oracle" monitor,user:"grid" startoption,group:"dba",group:"oper",group:"racdba",user:"grid",user:"oracle"
ACTION_SCRIPT=
ACTION_START_OPTION=
ACTION_TIMEOUT=600
ACTIVE_PLACEMENT=0
AGENT_FILENAME=%CRS_HOME%/bin/oraagent%CRS_EXE_SUFFIX%
ALLOW_RESTART=default
AUTO_START=restore　--★
CARDINALITY=3
CHECK_INTERVAL=900
CHECK_TIMEOUT=30
CLEAN_TIMEOUT=60
CLUSTER_DATABASE=true
CSS_CRITICAL=no
DATABASE_TYPE=RAC
DB_UNIQUE_NAME=orcl
DEFAULT_NETNUM=
DELETE_TIMEOUT=60
DESCRIPTION=Oracle Database resource
DISABLED_REASON=
DRAIN_ID=
DRAIN_TIMEOUT=
ENABLED=1
FAILOVER_DELAY=0
FAILURE_INTERVAL=60
FAILURE_THRESHOLD=1
GEN_AUDIT_FILE_DEST=/u01/app/oracle/admin/orcl/adump
GEN_RESTART=
GEN_RESTART@SERVERNAME(rac19c-node1)=StartCompleted
GEN_RESTART@SERVERNAME(rac19c-node2)=StartCompleted
GEN_RESTART@SERVERNAME(rac19c-node3)=StartCompleted
GEN_START_OPTIONS=
GEN_USR_ORA_INST_NAME=
GEN_USR_ORA_INST_NAME@SERVERNAME(rac19c-node1)=orcl1
GEN_USR_ORA_INST_NAME@SERVERNAME(rac19c-node2)=orcl2
GEN_USR_ORA_INST_NAME@SERVERNAME(rac19c-node3)=orcl3
HOSTING_MEMBERS=
IGNORE_TARGET_ON_FAILURE=no
INSTANCE_FAILOVER=0
INTERMEDIATE_TIMEOUT=0
JAVA_SERVICES=
LOAD=1
LOGGING_LEVEL=1
MANAGEMENT_POLICY=AUTOMATIC
MODIFY_TIMEOUT=60
NLS_LANG=
OFFLINE_CHECK_INTERVAL=0
ONLINE_RELOCATION_TIMEOUT=0
ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1
ORACLE_HOME_OLD=
PATCH_IN_PROGRESS=false
PLACEMENT=restricted
PWFILE=+DATA/ORCL/PASSWORD/pwdorcl.256.1102242983
RANK=0
RELOCATE_ACTION=0
RELOCATE_BY_DEPENDENCY=1
RELOCATE_KIND=offline
RESOURCE_GROUP=
RESTART_ATTEMPTS=2
RESTART_DELAY=0
ROLE=PRIMARY
SCRIPT_TIMEOUT=60
SERVER_CATEGORY=
SERVER_POOLS=ora.orcl
SERVER_POOLS_PQ=
SERVER_POOLS_RF=
SERVICE_NAMES=
SPFILE=+DATA/ORCL/PARAMETERFILE/spfile.275.1102246209
START_CONCURRENCY=0
START_DEPENDENCIES=hard(uniform:global:ora.DATA.dg,uniform:global:ora.RECO.dg) weak(type:ora.listener.type,global:type:ora.scan_listener.type,uniform:ora.ons,global:ora.gns) pullup(global:ora.DATA.dg,global:ora.RECO.dg)
START_DEPENDENCIES_RTE_INTERNAL=<xml><Cond name="ASMClientMode">False</Cond><Cond name="ASMmode">remote</Cond><Arg name="dg" type="ResList">ora.DATA.dg,ora.RECO.dg</Arg><Arg name="acfs_or_nfs" type="ResList"></Arg><Cond name="OHResExist">False</Cond><Cond name="DATABASE_TYPE">RAC</Cond><Cond name="MANAGEMENT_POLICY">AUTOMATIC</Cond><Arg name="acfs_and_nfs" type="ResList"></Arg></xml>
START_DEPENDENCIES_TEMPLATE=<xml>hard(<If cond="ASMClientMode" op="neq" value="True"><Then><If cond="ASMmode" value="remote"><Then><ResList>uniform:global:{dg}</ResList>,</Then><Else><ResList>{dg}</ResList>,</Else></If></Then></If><ResList>{acfs_or_nfs}</ResList><If cond="OHResExist" value="True"><Then>,<Res>{oraclehome}</Res></Then></If>) weak(<If cond="DATABASE_TYPE" op="eql" value="RAC|RACOneNode"><Then>type:ora.listener.type,global:type:ora.scan_listener.type,uniform:ora.ons,global:ora.gns</Then><Else>type:ora.listener.type,uniform:ora.ons</Else></If>) dispersion(<If cond="DATABASE_TYPE" value="RACOneNode"><Then><If cond="DB_CENTRIC" value="False"><Then>type:ora.database.type</Then></If></Then></If>) pullup(<If cond="ASMClientMode" op="neq" value="True"><Then><If cond="MANAGEMENT_POLICY" op="neql" value="MANUAL|NORESTART"><Then><If cond="ASMmode" value="remote"><Then><ResList>global:{dg}</ResList>,</Then><Else><ResList>{dg}</ResList>,</Else></If></Then></If></Then></If><ResList>{acfs_and_nfs}</ResList><If cond="OHResExist" value="True"><Then>,<Res>{oraclehome}</Res></Then></If>)</xml>
START_TIMEOUT=600
STOP_CONCURRENCY=0
STOP_DEPENDENCIES=hard(global:intermediate:ora.asm,global:shutdown:ora.DATA.dg,global:shutdown:ora.RECO.dg)
STOP_DEPENDENCIES_RTE_INTERNAL=<xml><Cond name="ASMClientMode">False</Cond><Cond name="DGExist">True</Cond><Cond name="ASMmode">remote</Cond><Arg name="dg" type="ResList">ora.DATA.dg,ora.RECO.dg</Arg><Arg name="acfs_same_as_oh" type="Res"></Arg><Arg name="acfs" type="ResList"></Arg><Cond name="OHResExist">False</Cond></xml>
STOP_DEPENDENCIES_TEMPLATE=<xml><If cond="ASMClientMode" op="neq" value="True"><Then><If cond="DGExist" value="True"><Then><If cond="ASMmode" value="remote"> <Then>hard(global:intermediate:ora.asm,<ResList>global:shutdown:{dg}</ResList>)</Then> <Else>hard(intermediate:ora.asm,<ResList>shutdown:{dg}</ResList>)</Else> </If></Then> </If>hard(<Res>{acfs_same_as_oh}</Res>,<ResList>intermediate:{acfs}</ResList>)</Then> <Else>hard(intermediate:<Res>{nfs}</Res>)</Else> </If><If cond="OHResExist" value="True"><Then>hard(intermediate: <Res>{oraclehome}</Res>)</Then></If></xml>
STOP_TIMEOUT=600
TARGET_DEFAULT=default
TARGET_NAME=
TARGET_TYPE=
TYPE_VERSION=3.3
UPTIME_THRESHOLD=1h
USER_WORKLOAD=yes
USE_QOS_DATA=no
USE_STICKINESS=0
USR_ORA_DB_NAME=orcl
USR_ORA_DOMAIN=oracle.com
USR_ORA_ENV=
USR_ORA_FLAGS=
USR_ORA_INST_NAME=
USR_ORA_INST_NAME@SERVERNAME(rac19c-node1)=orcl1
USR_ORA_INST_NAME@SERVERNAME(rac19c-node2)=orcl2
USR_ORA_INST_NAME@SERVERNAME(rac19c-node3)=orcl3
USR_ORA_OPEN_MODE=open
USR_ORA_OPI=false
USR_ORA_STOP_MODE=immediate
WORKLOAD_CPU=0
WORKLOAD_CPU_CAP=0
WORKLOAD_MEMORY_MAX=0
WORKLOAD_MEMORY_TARGET=0
```
#### 変更点
```
AUTO_START=never
AUTO_START=restore

MANAGEMENT_POLICY=MANUAL
MANAGEMENT_POLICY=AUTOMATIC

START_DEPENDENCIES=hard(uniform:global:ora.DATA.dg,uniform:global:ora.RECO.dg) weak(type:ora.listener.type,global:type:ora.scan_listener.type,uniform:ora.ons,global:ora.gns)
START_DEPENDENCIES=hard(uniform:global:ora.DATA.dg,uniform:global:ora.RECO.dg) weak(type:ora.listener.type,global:type:ora.scan_listener.type,uniform:ora.ons,global:ora.gns) pullup(global:ora.DATA.dg,global:ora.RECO.dg)
```