11gR2 RACの起動と停止

RAC環境ではクラスタウエアがデータベース、リスナー、vip等を管理しており、これらをリソースと呼んでいます。 本ページでは11gR2 RAC環境における各リソースの管理方法を記載します。

リソースの種類

11gR2 Real Application Clusters(RAC) のインストールページの手順でインストールした環境の場合以下のような種類のリソースが作成されます。 (カッコ内はリソースの名前)

・asmリソース
・DiskGroupリソース(DATA)
・eonsリソース
・onsリソース
・gsdリソース
・oc4jリソース
・networkリソース(net1)
・vipリソース(vip1、vip2、scan1、scan2、scan3)
・listenerリソース(LISTENER、LISTENER_SCAN1、LISTENER_SCAN2、LISTENER_SCAN3)
・dbリソース(rac112)

※acfsリソースはcentOSへインストールした場合作成されません

リソースの自動起動

OS起動時にgrid Infrastructureは自動起動するためASMやnetworkリソース等は自動起動しますが、 db、vip、scanリソース等の自動起動設定は AUTO_START=restore(サーバー停止時と同じ状態に戻す)に設定されているため、 srvctl stop database 等で意図的に停止させた後リブートしても自動起動しません。

サーバー停止時の状態とは crsctl stat res等で表示されるtargetの値に該当すると思われますが、srvctl stop database 等のコマンドではなく、 crsctl stop crsで全てのリソースを一括停止した場合はtargetの値はONLINEのままになるためOS再起動時にdbリソース等は自動起動します。 なお、crsctl stop crsで停止した場合もデータベースはabortではなくshutdown immediateで停止されます。

追記:PSR11.2.0.2以降を適用するとimmediateではなくabortで停止する動作に変更されます。

リソースの手動起動、停止

以下は各リソースに対して個別に停止するコマンドです。クラスタリソースにリソース間に依存性があるため停止する場合は上から停止、起動する場合は下から順番に起動してください。
(※リソース名は11gR2 Real Application Clusters(RAC) のインストールページで設定した場合の名前です)

dbリソース
・全インスタンスの場合
srvctl start database -d rac112
srvctl stop database -d rac112

・特定インスタンスの場合
srvctl start instance -d rac112 -i rac1121
srvctl stop instance -d rac112 -i rac1121

listenerリソース
・scan_listenerの場合(※)
srvctl start scan_listener
srvctl stop scan_listener

・listenerの場合
srvctl start listener -n vm1
srvctl stop listener -n vm1

vipリソース
・scan_vipの場合
srvctl start scan
srvctl stop scan

・vipの場合
srvctl start vip -n vm1
srvctl stop vip -n vm1

oc4j、gsd、ons、eons、vip(scan_vip除く),networkリソース(※1)
srvctl start nodeapps -n vm1
srvctl stop nodeapps -n vm1 (※2)

※1 oc4jとgsdリソースは通常無効化されています。
※2 listenerやscan等のリソースが対象ノードで停止していない場合networkリソースの停止はエラー(CRS-2529)になります

クラスタウエアの起動、停止

クラスタウエアの起動、停止はrootユーザで行います。また、クラスタウエアを停止するとクラスタウエアが管理しているすべてのリソースが停止します

$GRID_HOME/bin/crsctl start crs
$GRID_HOME/bin/crsctl stop crs

リソースの確認

リソースはcrsctlコマンドでリソースの状態やパラメータを確認することができます。

リソースの状態
crsctl status resource -t
・TARGET・・・クラスタウエアが想定している状態
・STATE・・・実際のリソースの状態
・SERVER・・リソースが起動しているサーバ名

以下のような場合はTARGETとSTATEの表示が一致しません。
- 予期せずリソースがダウンした場合
- リソースが起動、停止中の場合

リソースのパラメータ
crsctl status resource -p

参考

・crsctl status resource -tの結果
[ora112@vm1 ~]$ crsctl status resource -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
               ONLINE  ONLINE       vm1
               ONLINE  ONLINE       vm2
ora.LISTENER.lsnr
               ONLINE  ONLINE       vm1
               ONLINE  ONLINE       vm2
ora.asm
               ONLINE  ONLINE       vm1                      Started
               ONLINE  ONLINE       vm2                      Started
ora.eons
               ONLINE  ONLINE       vm1
               ONLINE  ONLINE       vm2
ora.gsd
               OFFLINE OFFLINE      vm1
               OFFLINE OFFLINE      vm2
ora.net1.network
               ONLINE  ONLINE       vm1
               ONLINE  ONLINE       vm2
ora.ons
               ONLINE  ONLINE       vm1
               ONLINE  ONLINE       vm2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       vm2
ora.LISTENER_SCAN2.lsnr
      1        ONLINE  ONLINE       vm1
ora.LISTENER_SCAN3.lsnr
      1        ONLINE  ONLINE       vm1
ora.oc4j
      1        OFFLINE OFFLINE
ora.rac112.db
      1        ONLINE  ONLINE       vm1                      Open
      2        ONLINE  ONLINE       vm2                      Open
ora.scan1.vip
      1        ONLINE  ONLINE       vm2
ora.scan2.vip
      1        ONLINE  ONLINE       vm1
ora.scan3.vip
      1        ONLINE  ONLINE       vm1
ora.vm1.vip
      1        ONLINE  ONLINE       vm1
ora.vm2.vip
      1        ONLINE  ONLINE       vm2
・リソースを一通り起動した状態のoracle関連のプロセス
[ora112@vm1 ~]$ ps aux
USER       PID %CPU %MEM    VSZ   RSS TTY      STAT START   TIME COMMAND
ora112    3542  0.0  0.7 331944 24296 ?        Ssl  14:50   0:02 /app/11.2.0/grid/bin/oraagent.bin
ora112    3555  0.0  0.2  69400  8796 ?        Sl   14:50   0:00 /app/11.2.0/grid/bin/gipcd.bin
ora112    3560  0.0  0.4  83316 12740 ?        Ssl  14:50   0:00 /app/11.2.0/grid/bin/mdnsd.bin
ora112    3576  0.0  0.6 140024 20432 ?        Ssl  14:50   0:00 /app/11.2.0/grid/bin/gpnpd.bin
root      3587  0.0  7.7 240496 239504 ?       SLl  14:50   0:00 /app/11.2.0/grid/bin/cssdmonitor
root      3606  0.0  7.7 240500 239572 ?       SLl  14:50   0:00 /app/11.2.0/grid/bin/cssdagent
root      3608  0.0  0.5 262116 17124 ?        Ssl  14:50   0:00 /app/11.2.0/grid/bin/orarootagent.bin
ora112    3638  0.0  0.4  98064 12520 ?        Sl   14:50   0:00 /app/11.2.0/grid/bin/diskmon.bin -d -f
ora112    3643  0.0  8.3 261332 260048 ?       SLl  14:50   0:01 /app/11.2.0/grid/bin/ocssd.bin
root      3719  0.0  0.4 134928 14748 ?        Sl   14:51   0:00 /app/11.2.0/grid/bin/octssd.bin reboot
ora112    3736  0.0  0.7 225972 23864 ?        Ssl  14:51   0:00 /app/11.2.0/grid/bin/evmd.bin
ora112    3795  0.0  0.5 420232 16060 ?        Ss   14:51   0:00 asm_pmon_+ASM1
ora112    3797  0.0  0.3 419592 12284 ?        Ss   14:51   0:00 asm_vktm_+ASM1
ora112    3803  0.0  0.4 419976 13668 ?        Ss   14:51   0:00 asm_gen0_+ASM1
ora112    3806  0.0  0.6 425572 19780 ?        Ss   14:51   0:00 asm_diag_+ASM1
ora112    3808  0.0  0.4 419592 12872 ?        Ss   14:51   0:00 asm_ping_+ASM1
ora112    3810  0.0  0.3 419592 12428 ?        Ss   14:51   0:00 asm_psp0_+ASM1
ora112    3812  0.0  0.7 427876 24296 ?        Ss   14:51   0:00 asm_dia0_+ASM1
ora112    3814  0.0  0.7 426796 22640 ?        Ss   14:51   0:00 asm_lmon_+ASM1
ora112    3816  0.0  0.7 430344 23904 ?        Ss   14:51   0:00 asm_lmd0_+ASM1
ora112    3825  0.0  0.8 430344 25504 ?        Ss   14:51   0:00 asm_lms0_+ASM1
ora112    3829  0.0  0.3 419592 12400 ?        Ss   14:51   0:00 asm_lmhb_+ASM1
ora112    3831  0.0  0.4 419592 12440 ?        Ss   14:51   0:00 asm_mman_+ASM1
ora112    3833  0.0  0.5 421668 16600 ?        Ss   14:51   0:00 asm_dbw0_+ASM1
ora112    3835  0.0  0.5 420828 16460 ?        Ss   14:51   0:00 asm_lgwr_+ASM1
ora112    3837  0.0  0.4 419592 14048 ?        Ss   14:51   0:00 asm_ckpt_+ASM1
ora112    3839  0.0  0.3 419592 12408 ?        Ss   14:51   0:00 asm_smon_+ASM1
ora112    3841  0.0  0.6 422432 21468 ?        Ss   14:51   0:00 asm_rbal_+ASM1
ora112    3843  0.0  0.5 421800 17072 ?        Ss   14:51   0:00 asm_gmon_+ASM1
ora112    3845  0.0  0.4 419592 13100 ?        Ss   14:51   0:00 asm_mmon_+ASM1
ora112    3847  0.0  0.4 419592 13908 ?        Ss   14:51   0:00 asm_mmnl_+ASM1
ora112    3849  0.0  0.2  47628  7872 ?        S    14:51   0:00 /app/11.2.0/grid/bin/oclskd.bin
ora112    3853  0.0  0.4 420516 15460 ?        Ss   14:51   0:00 asm_lck0_+ASM1
root      3883  0.1  1.6 567568 52160 ?        Ssl  14:51   0:03 /app/11.2.0/grid/bin/crsd.bin reboot
ora112    3896  0.0  0.4 419956 14704 ?        Ss   14:51   0:00 asm_asmb_+ASM1
ora112    3898  0.0  0.5 420056 16276 ?        Ss   14:51   0:00 oracle+ASM1_asmb_+asm1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
root      3925  0.0  0.2  47628  7888 ?        S    14:51   0:00 /app/11.2.0/grid/bin/oclskd.bin
ora112    3930  0.0  0.7 421984 22100 ?        Ss   14:51   0:00 oracle+ASM1_ocr (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
ora112    3978  0.0  0.3  48996 10024 ?        S    14:51   0:00 /app/11.2.0/grid/bin/evmlogger.bin -o /app/11.2.0/grid/evm/log/evmlogger.info -l /app/11.2.0/grid/evm/l
root      4020  0.1  0.4 589108 14484 ?        Ssl  14:51   0:03 /app/11.2.0/grid/bin/orarootagent.bin
ora112    4025  0.0  0.8 796260 27012 ?        Ssl  14:51   0:01 /app/11.2.0/grid/bin/oraagent.bin
ora112    4108  0.0  0.1  34312  3372 ?        Ss   14:51   0:00 /app/11.2.0/grid/opmn/bin/ons -d
ora112    4109  0.0  0.1  35572  5284 ?        Sl   14:51   0:00 /app/11.2.0/grid/opmn/bin/ons -d
ora112    4158  0.0  1.4 1052072 45016 ?       Sl   14:51   0:02 /app/11.2.0/grid/jdk/jre//bin/java -Doracle.supercluster.cluster.server=eonsd -Djava.net.preferIPv4Stac
ora112    5552  0.0  0.3  42196  9460 ?        Ssl  15:30   0:00 /app/11.2.0/grid/bin/tnslsnr LISTENER -inherit
ora112    5589  0.0  0.3  42196  9432 ?        Ssl  15:30   0:00 /app/11.2.0/grid/bin/tnslsnr LISTENER_SCAN1 -inherit
ora112    5599  0.0  0.3  42196  9432 ?        Ssl  15:30   0:00 /app/11.2.0/grid/bin/tnslsnr LISTENER_SCAN2 -inherit
ora112    5609  0.0  0.3  42192  9432 ?        Ssl  15:30   0:00 /app/11.2.0/grid/bin/tnslsnr LISTENER_SCAN3 -inherit
ora112    5693  0.0  0.4 419956 14060 ?        Ss   15:31   0:00 asm_o000_+ASM1
ora112    5695  0.0  0.5 420556 16424 ?        Ss   15:31   0:00 oracle+ASM1_o000_+asm1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
ora112    5721  0.0  0.5 1414372 18404 ?       Ss   15:31   0:00 ora_pmon_rac1121
ora112    5723  0.0  0.4 1413476 13884 ?       Ss   15:31   0:00 ora_vktm_rac1121
ora112    5727  0.0  0.8 1415184 26448 ?       Ss   15:31   0:00 ora_gen0_rac1121
ora112    5729  0.0  0.6 1419472 21400 ?       Ss   15:31   0:00 ora_diag_rac1121
ora112    5731  0.0  0.7 1415020 23824 ?       Ss   15:31   0:00 ora_dbrm_rac1121
ora112    5733  0.0  0.4 1413540 14516 ?       Ss   15:31   0:00 ora_ping_rac1121
ora112    5735  0.0  0.4 1413476 14076 ?       Ss   15:31   0:00 ora_psp0_rac1121
ora112    5737  0.0  0.4 1413476 13968 ?       Ss   15:31   0:00 ora_acms_rac1121
ora112    5739  0.0  0.8 1421776 26812 ?       Ss   15:31   0:00 ora_dia0_rac1121
ora112    5741  0.0  0.8 1420764 26324 ?       Ss   15:31   0:00 ora_lmon_rac1121
ora112    5743  0.0  0.9 1428324 30128 ?       Ss   15:31   0:00 ora_lmd0_rac1121
ora112    5745  0.0  1.3 1428324 42640 ?       Ss   15:31   0:00 ora_lms0_rac1121
ora112    5749  0.0  0.4 1413476 14056 ?       Ss   15:31   0:00 ora_rms0_rac1121
ora112    5751  0.0  0.4 1413476 13964 ?       Ss   15:31   0:00 ora_lmhb_rac1121
ora112    5753  0.8  1.1 1413476 35848 ?       Ss   15:31   0:02 ora_mman_rac1121
ora112    5755  0.0  0.6 1419224 21644 ?       Ss   15:31   0:00 ora_dbw0_rac1121
ora112    5757  0.0  1.7 1437008 53628 ?       Ss   15:31   0:00 ora_lgwr_rac1121
ora112    5759  0.0  0.6 1415336 21304 ?       Ss   15:31   0:00 ora_ckpt_rac1121
ora112    5761  0.0  1.0 1415040 31436 ?       Ss   15:31   0:00 ora_smon_rac1121
ora112    5763  0.0  0.7 1415012 21924 ?       Ss   15:31   0:00 ora_reco_rac1121
ora112    5765  0.0  0.5 1413904 16572 ?       Ss   15:31   0:00 ora_rbal_rac1121
ora112    5767  0.0  0.6 1414172 18760 ?       Ss   15:31   0:00 ora_asmb_rac1121
ora112    5769  0.1  2.0 1418628 63164 ?       Ss   15:31   0:00 ora_mmon_rac1121
ora112    5771  0.0  0.5 1413476 18584 ?       Ss   15:31   0:00 ora_mmnl_rac1121
ora112    5773  0.0  0.5 420072 16352 ?        Ss   15:31   0:00 oracle+ASM1_asmb_rac1121 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
ora112    5775  0.0  0.7 1421156 22024 ?       Ss   15:31   0:00 ora_mark_rac1121
ora112    5784  0.1  0.8 1414416 26536 ?       Ss   15:31   0:00 ora_lck0_rac1121
ora112    5786  0.0  0.6 1419492 20480 ?       Ss   15:31   0:00 ora_rsmn_rac1121
ora112    5814  0.0  0.5 1413836 15700 ?       Ss   15:31   0:00 ora_o000_rac1121
ora112    5816  0.0  0.5 420524 16832 ?        Ss   15:31   0:00 oracle+ASM1_o000_rac1121 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
ora112    5819  0.0  0.5 1413836 15652 ?       Ss   15:31   0:00 ora_o001_rac1121
ora112    5822  0.0  0.5 420524 16528 ?        Ss   15:31   0:00 oracle+ASM1_o001_rac1121 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
ora112    5825  0.0  0.4 1413476 14068 ?       Ss   15:31   0:00 ora_gtx0_rac1121
ora112    5827  0.0  0.6 1414028 19240 ?       Ss   15:31   0:00 ora_rcbg_rac1121
ora112    5829  0.0  0.5 1413988 16500 ?       Ss   15:31   0:00 ora_qmnc_rac1121
ora112    5845  0.0  1.0 1415264 32224 ?       Ss   15:31   0:00 oraclerac1121 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
ora112    5868  0.0  0.8 1416048 25868 ?       Ss   15:31   0:00 ora_q000_rac1121
ora112    5870  0.0  0.5 1413472 16700 ?       Ss   15:31   0:00 ora_q001_rac1121
・crsctl status resource -pの結果
[ora112@vm1 ~]$ crsctl status resource -p
NAME=ora.DATA.dg
TYPE=ora.diskgroup.type
ACL=owner:ora112:rwx,pgrp:oinstall:rwx,other::r--
ACTION_FAILURE_TEMPLATE=
ACTION_SCRIPT=
AGENT_FILENAME=%CRS_HOME%/bin/oraagent%CRS_EXE_SUFFIX%
ALIAS_NAME=
AUTO_START=never
CHECK_INTERVAL=300
CHECK_TIMEOUT=600
DEFAULT_TEMPLATE=
DEGREE=1
DESCRIPTION=CRS resource type definition for ASM disk group resource
ENABLED=1
LOAD=1
LOGGING_LEVEL=1
NLS_LANG=
NOT_RESTARTING_TEMPLATE=
OFFLINE_CHECK_INTERVAL=0
PROFILE_CHANGE_TEMPLATE=
RESTART_ATTEMPTS=5
SCRIPT_TIMEOUT=60
START_DEPENDENCIES=hard(ora.asm) pullup(ora.asm)
START_TIMEOUT=900
STATE_CHANGE_TEMPLATE=
STOP_DEPENDENCIES=hard(intermediate:ora.asm)
STOP_TIMEOUT=180
UPTIME_THRESHOLD=1d
USR_ORA_ENV=
USR_ORA_OPI=false
USR_ORA_STOP_MODE=
VERSION=11.2.0.1.0

NAME=ora.LISTENER.lsnr
TYPE=ora.listener.type
ACL=owner:ora112:rwx,pgrp:oinstall:rwx,other::r--
ACTION_FAILURE_TEMPLATE=
ACTION_SCRIPT=%CRS_HOME%/bin/racgwrap%CRS_SCRIPT_SUFFIX%
AGENT_FILENAME=%CRS_HOME%/bin/oraagent%CRS_EXE_SUFFIX%
ALIAS_NAME=ora.%CRS_CSS_NODENAME_LOWER_CASE%.LISTENER_%CRS_CSS_NODENAME_UPPER_CASE%.lsnr
AUTO_START=restore
CHECK_INTERVAL=60
DEFAULT_TEMPLATE=PROPERTY(RESOURCE_CLASS=listener) PROPERTY(LISTENER_NAME=PARSE(%NAME%, ., 2))
DEGREE=1
DESCRIPTION=Oracle Listener resource
ENABLED=1
ENDPOINTS=TCP:1521
LOAD=1
LOGGING_LEVEL=1
NLS_LANG=
NOT_RESTARTING_TEMPLATE=
OFFLINE_CHECK_INTERVAL=0
ORACLE_HOME=%CRS_HOME%
PORT=1521
PROFILE_CHANGE_TEMPLATE=
RESTART_ATTEMPTS=5
SCRIPT_TIMEOUT=60
START_DEPENDENCIES=hard(type:ora.cluster_vip_net1.type) pullup(type:ora.cluster_vip_net1.type)
START_TIMEOUT=180
STATE_CHANGE_TEMPLATE=
STOP_DEPENDENCIES=hard(intermediate:type:ora.cluster_vip_net1.type)
STOP_TIMEOUT=0
UPTIME_THRESHOLD=1d
USR_ORA_ENV=ORACLE_BASE=/app/ora112
USR_ORA_OPI=false
VERSION=11.2.0.1.0

NAME=ora.LISTENER_SCAN1.lsnr
TYPE=ora.scan_listener.type
ACL=owner:ora112:rwx,pgrp:oinstall:r-x,other::r--
ACTION_FAILURE_TEMPLATE=
ACTION_SCRIPT=
ACTIVE_PLACEMENT=1
AGENT_FILENAME=%CRS_HOME%/bin/oraagent%CRS_EXE_SUFFIX%
AUTO_START=restore
CARDINALITY=1
CHECK_INTERVAL=60
DEFAULT_TEMPLATE=PROPERTY(RESOURCE_CLASS=scan_listener) PROPERTY(LISTENER_NAME=PARSE(%NAME%, ., 2))
DEGREE=1
DESCRIPTION=Oracle SCAN listener resource
ENABLED=1
ENDPOINTS=TCP:1521
FAILOVER_DELAY=0
FAILURE_INTERVAL=0
FAILURE_THRESHOLD=0
HOSTING_MEMBERS=
LOAD=1
LOGGING_LEVEL=1
NLS_LANG=
NOT_RESTARTING_TEMPLATE=
OFFLINE_CHECK_INTERVAL=0
PLACEMENT=balanced
PORT=1521
PROFILE_CHANGE_TEMPLATE=
RESTART_ATTEMPTS=5
SCRIPT_TIMEOUT=60
SERVER_POOLS=*
START_DEPENDENCIES=hard(ora.scan1.vip) dispersion:active(type:ora.scan_listener.type) pullup(ora.scan1.vip)
START_TIMEOUT=180
STATE_CHANGE_TEMPLATE=
STOP_DEPENDENCIES=hard(intermediate:ora.scan1.vip)
STOP_TIMEOUT=0
UPTIME_THRESHOLD=1d
USR_ORA_ENV=
USR_ORA_OPI=false
VERSION=11.2.0.1.0

NAME=ora.LISTENER_SCAN2.lsnr
TYPE=ora.scan_listener.type
ACL=owner:ora112:rwx,pgrp:oinstall:r-x,other::r--
ACTION_FAILURE_TEMPLATE=
ACTION_SCRIPT=
ACTIVE_PLACEMENT=1
AGENT_FILENAME=%CRS_HOME%/bin/oraagent%CRS_EXE_SUFFIX%
AUTO_START=restore
CARDINALITY=1
CHECK_INTERVAL=60
DEFAULT_TEMPLATE=PROPERTY(RESOURCE_CLASS=scan_listener) PROPERTY(LISTENER_NAME=PARSE(%NAME%, ., 2))
DEGREE=1
DESCRIPTION=Oracle SCAN listener resource
ENABLED=1
ENDPOINTS=TCP:1521
FAILOVER_DELAY=0
FAILURE_INTERVAL=0
FAILURE_THRESHOLD=0
HOSTING_MEMBERS=
LOAD=1
LOGGING_LEVEL=1
NLS_LANG=
NOT_RESTARTING_TEMPLATE=
OFFLINE_CHECK_INTERVAL=0
PLACEMENT=balanced
PORT=1521
PROFILE_CHANGE_TEMPLATE=
RESTART_ATTEMPTS=5
SCRIPT_TIMEOUT=60
SERVER_POOLS=*
START_DEPENDENCIES=hard(ora.scan2.vip) dispersion:active(type:ora.scan_listener.type) pullup(ora.scan2.vip)
START_TIMEOUT=180
STATE_CHANGE_TEMPLATE=
STOP_DEPENDENCIES=hard(intermediate:ora.scan2.vip)
STOP_TIMEOUT=0
UPTIME_THRESHOLD=1d
USR_ORA_ENV=
USR_ORA_OPI=false
VERSION=11.2.0.1.0

NAME=ora.LISTENER_SCAN3.lsnr
TYPE=ora.scan_listener.type
ACL=owner:ora112:rwx,pgrp:oinstall:r-x,other::r--
ACTION_FAILURE_TEMPLATE=
ACTION_SCRIPT=
ACTIVE_PLACEMENT=1
AGENT_FILENAME=%CRS_HOME%/bin/oraagent%CRS_EXE_SUFFIX%
AUTO_START=restore
CARDINALITY=1
CHECK_INTERVAL=60
DEFAULT_TEMPLATE=PROPERTY(RESOURCE_CLASS=scan_listener) PROPERTY(LISTENER_NAME=PARSE(%NAME%, ., 2))
DEGREE=1
DESCRIPTION=Oracle SCAN listener resource
ENABLED=1
ENDPOINTS=TCP:1521
FAILOVER_DELAY=0
FAILURE_INTERVAL=0
FAILURE_THRESHOLD=0
HOSTING_MEMBERS=
LOAD=1
LOGGING_LEVEL=1
NLS_LANG=
NOT_RESTARTING_TEMPLATE=
OFFLINE_CHECK_INTERVAL=0
PLACEMENT=balanced
PORT=1521
PROFILE_CHANGE_TEMPLATE=
RESTART_ATTEMPTS=5
SCRIPT_TIMEOUT=60
SERVER_POOLS=*
START_DEPENDENCIES=hard(ora.scan3.vip) dispersion:active(type:ora.scan_listener.type) pullup(ora.scan3.vip)
START_TIMEOUT=180
STATE_CHANGE_TEMPLATE=
STOP_DEPENDENCIES=hard(intermediate:ora.scan3.vip)
STOP_TIMEOUT=0
UPTIME_THRESHOLD=1d
USR_ORA_ENV=
USR_ORA_OPI=false
VERSION=11.2.0.1.0

NAME=ora.asm
TYPE=ora.asm.type
ACL=owner:ora112:rwx,pgrp:oinstall:rwx,other::r--
ACTION_FAILURE_TEMPLATE=
ACTION_SCRIPT=
AGENT_FILENAME=%CRS_HOME%/bin/oraagent%CRS_EXE_SUFFIX%
ALIAS_NAME=ora.%CRS_CSS_NODENAME%.ASM%CRS_CSS_NODENUMBER%.asm
AUTO_START=never
CHECK_INTERVAL=60
CHECK_TIMEOUT=600
DEFAULT_TEMPLATE=PROPERTY(RESOURCE_CLASS=asm) ELEMENT(INSTANCE_NAME= %GEN_USR_ORA_INST_NAME%)
DEGREE=1
DESCRIPTION=Oracle ASM resource
ENABLED=1
GEN_USR_ORA_INST_NAME=
GEN_USR_ORA_INST_NAME@SERVERNAME(vm1)=+ASM1
GEN_USR_ORA_INST_NAME@SERVERNAME(vm2)=+ASM2
LOAD=1
LOGGING_LEVEL=1
NLS_LANG=
NOT_RESTARTING_TEMPLATE=
OFFLINE_CHECK_INTERVAL=0
PROFILE_CHANGE_TEMPLATE=
RESTART_ATTEMPTS=5
SCRIPT_TIMEOUT=60
START_DEPENDENCIES=weak(ora.LISTENER.lsnr)
START_TIMEOUT=900
STATE_CHANGE_TEMPLATE=
STOP_DEPENDENCIES=
STOP_TIMEOUT=600
UPTIME_THRESHOLD=1d
USR_ORA_ENV=
USR_ORA_INST_NAME=+ASM%CRS_CSS_NODENUMBER%
USR_ORA_OPEN_MODE=mount
USR_ORA_OPI=false
USR_ORA_STOP_MODE=immediate
VERSION=11.2.0.1.0

NAME=ora.eons
TYPE=ora.eons.type
ACL=owner:ora112:rwx,pgrp:oinstall:r-x,other::r--
ACTION_FAILURE_TEMPLATE=
ACTION_SCRIPT=
AGENT_FILENAME=%CRS_HOME%/bin/oraagent%CRS_EXE_SUFFIX%
ALIAS_NAME=
AUTO_START=always
CHECK_INTERVAL=60
CHECK_TIMEOUT=120
DEFAULT_TEMPLATE=
DEGREE=1
DESCRIPTION=Oracle eONS resource
DISCOVERY_METHOD=multicast
ENABLED=1
LOAD=1
LOGGING_LEVEL=1
MCAST_ADDRESS=234.32.152.189:16021
MEMBER_LIST=
NLS_LANG=
NOT_RESTARTING_TEMPLATE=
OFFLINE_CHECK_INTERVAL=0
PORT=2016
PROFILE_CHANGE_TEMPLATE=
PROPERTIES=
RESTART_ATTEMPTS=3
SCRIPT_TIMEOUT=60
START_DEPENDENCIES=
START_TIMEOUT=300
STATE_CHANGE_TEMPLATE=
STOP_DEPENDENCIES=
STOP_TIMEOUT=120
UPTIME_THRESHOLD=1d
USR_ORA_ENV=
VERSION=11.2.0.1.0

NAME=ora.gsd
TYPE=ora.gsd.type
ACL=owner:ora112:rwx,pgrp:oinstall:r-x,other::r--
ACTION_FAILURE_TEMPLATE=
ACTION_SCRIPT=
AGENT_FILENAME=%CRS_HOME%/bin/oraagent%CRS_EXE_SUFFIX%
ALIAS_NAME=ora.%CRS_CSS_NODENAME%.gsd
AUTO_START=always
CHECK_INTERVAL=60
DEFAULT_TEMPLATE=
DEGREE=1
DESCRIPTION=Oracle GSD resource
ENABLED=0
LOAD=1
LOGGING_LEVEL=1
NLS_LANG=
NOT_RESTARTING_TEMPLATE=
OFFLINE_CHECK_INTERVAL=0
PROFILE_CHANGE_TEMPLATE=
RESTART_ATTEMPTS=5
SCRIPT_TIMEOUT=60
START_DEPENDENCIES=
START_TIMEOUT=0
STATE_CHANGE_TEMPLATE=
STOP_DEPENDENCIES=
STOP_TIMEOUT=0
UPTIME_THRESHOLD=1d
USR_ORA_ENV=
VERSION=11.2.0.1.0

NAME=ora.net1.network
TYPE=ora.network.type
ACL=owner:root:rwx,pgrp:root:r-x,other::r--,group:oinstall:r-x,user:ora112:r-x
ACTION_FAILURE_TEMPLATE=
ACTION_SCRIPT=
AGENT_FILENAME=%CRS_HOME%/bin/orarootagent%CRS_EXE_SUFFIX%
ALIAS_NAME=
AUTO_START=restore
CHECK_INTERVAL=1
DEFAULT_TEMPLATE=
DEGREE=1
DESCRIPTION=Oracle Network resource
ENABLED=1
LOAD=1
LOGGING_LEVEL=1
NLS_LANG=
NOT_RESTARTING_TEMPLATE=
OFFLINE_CHECK_INTERVAL=60
PROFILE_CHANGE_TEMPLATE=
RESTART_ATTEMPTS=5
SCRIPT_TIMEOUT=60
START_DEPENDENCIES=
START_TIMEOUT=0
STATE_CHANGE_TEMPLATE=
STOP_DEPENDENCIES=
STOP_TIMEOUT=0
UPTIME_THRESHOLD=1d
USR_ORA_AUTO=
USR_ORA_ENV=
USR_ORA_IF=eth0
USR_ORA_NETMASK=255.255.255.0
USR_ORA_SUBNET=192.168.1.0
VERSION=11.2.0.1.0

NAME=ora.oc4j
TYPE=ora.oc4j.type
ACL=owner:ora112:rwx,pgrp:oinstall:rwx,other::r--
ACTION_FAILURE_TEMPLATE=
ACTION_SCRIPT=%CRS_HOME%/bin/oc4jctl%CRS_SCRIPT_SUFFIX%
ACTIVE_PLACEMENT=1
AGENT_FILENAME=%CRS_HOME%/bin/scriptagent
AUTO_START=restore
CARDINALITY=1
CHECK_INTERVAL=60
DEFAULT_TEMPLATE=
DEGREE=1
DESCRIPTION=Oracle OC4J resource
ENABLED=0
FAILOVER_DELAY=0
FAILURE_INTERVAL=0
FAILURE_THRESHOLD=0
HOSTING_MEMBERS=
LOAD=1
LOGGING_LEVEL=1
NLS_LANG=
NOT_RESTARTING_TEMPLATE=
OFFLINE_CHECK_INTERVAL=0
PLACEMENT=balanced
PORT=23792
PROFILE_CHANGE_TEMPLATE=
RESTART_ATTEMPTS=5
SCRIPT_TIMEOUT=60
SERVER_POOLS=*
START_DEPENDENCIES=
START_TIMEOUT=300
STATE_CHANGE_TEMPLATE=
STOP_DEPENDENCIES=
STOP_TIMEOUT=120
UPTIME_THRESHOLD=1d
USR_ORA_ENV=
VERSION=11.2.0.1.0

NAME=ora.ons
TYPE=ora.ons.type
ACL=owner:ora112:rwx,pgrp:oinstall:r-x,other::r--
ACTION_FAILURE_TEMPLATE=
ACTION_SCRIPT=
AGENT_FILENAME=%CRS_HOME%/bin/oraagent%CRS_EXE_SUFFIX%
ALIAS_NAME=ora.%CRS_CSS_NODENAME%.ons
AUTO_START=always
CHECK_INTERVAL=60
DEFAULT_TEMPLATE=
DEGREE=1
DESCRIPTION=Oracle ONS resource
ENABLED=1
LOAD=1
LOCAL_PORT=6100
LOGGING_LEVEL=1
NLS_LANG=
NOT_RESTARTING_TEMPLATE=
OFFLINE_CHECK_INTERVAL=0
PROFILE_CHANGE_TEMPLATE=
REMOTE_HOSTS=
REMOTE_PORT=6200
RESTART_ATTEMPTS=3
SCRIPT_TIMEOUT=60
START_DEPENDENCIES=hard(ora.net1.network) pullup(ora.net1.network)
START_TIMEOUT=0
STATE_CHANGE_TEMPLATE=
STOP_DEPENDENCIES=hard(ora.net1.network)
STOP_TIMEOUT=0
UPTIME_THRESHOLD=1d
USR_ORA_ENV=
VERSION=11.2.0.1.0

NAME=ora.rac112.db
TYPE=ora.database.type
ACL=owner:ora112:rwx,pgrp:oinstall:rwx,other::r--
ACTION_FAILURE_TEMPLATE=
ACTION_SCRIPT=
ACTIVE_PLACEMENT=1
AGENT_FILENAME=%CRS_HOME%/bin/oraagent%CRS_EXE_SUFFIX%
AUTO_START=restore
CARDINALITY=2
CHECK_INTERVAL=1
CHECK_TIMEOUT=600
CLUSTER_DATABASE=true
DB_UNIQUE_NAME=rac112
DEFAULT_TEMPLATE=PROPERTY(RESOURCE_CLASS=database) PROPERTY(DB_UNIQUE_NAME= CONCAT(PARSE(%NAME%, ., 2), %USR_ORA_DOMAIN%, .)) ELEMENT(INSTANCE_NAME= %GEN_USR_ORA_INST_NAME%)
DEGREE=1
DESCRIPTION=Oracle Database resource
ENABLED=1
FAILOVER_DELAY=0
FAILURE_INTERVAL=60
FAILURE_THRESHOLD=1
GEN_AUDIT_FILE_DEST=/app/admin/rac112/adump
GEN_USR_ORA_INST_NAME=
GEN_USR_ORA_INST_NAME@SERVERNAME(vm1)=rac1121
GEN_USR_ORA_INST_NAME@SERVERNAME(vm2)=rac1122
HOSTING_MEMBERS=
INSTANCE_FAILOVER=0
LOAD=1
LOGGING_LEVEL=1
MANAGEMENT_POLICY=AUTOMATIC
NLS_LANG=
NOT_RESTARTING_TEMPLATE=
OFFLINE_CHECK_INTERVAL=0
ORACLE_HOME=/app/11.2.0/db
PLACEMENT=restricted
PROFILE_CHANGE_TEMPLATE=
RESTART_ATTEMPTS=2
ROLE=PRIMARY
SCRIPT_TIMEOUT=60
SERVER_POOLS=ora.rac112
SPFILE=+DATA/rac112/spfilerac112.ora
START_DEPENDENCIES=hard(ora.DATA.dg) weak(type:ora.listener.type,global:type:ora.scan_listener.type,uniform:ora.ons,uniform:ora.eons) pullup(ora.DATA.dg)
START_TIMEOUT=600
STATE_CHANGE_TEMPLATE=
STOP_DEPENDENCIES=hard(intermediate:ora.asm,shutdown:ora.DATA.dg)
STOP_TIMEOUT=600
UPTIME_THRESHOLD=1h
USR_ORA_DB_NAME=rac112
USR_ORA_DOMAIN=
USR_ORA_ENV=
USR_ORA_FLAGS=
USR_ORA_INST_NAME=
USR_ORA_INST_NAME@SERVERNAME(vm1)=rac1121
USR_ORA_INST_NAME@SERVERNAME(vm2)=rac1122
USR_ORA_OPEN_MODE=open
USR_ORA_OPI=false
USR_ORA_STOP_MODE=immediate
VERSION=11.2.0.1.0

NAME=ora.scan1.vip
TYPE=ora.scan_vip.type
ACL=owner:root:rwx,pgrp:root:r-x,other::r--,group:oinstall:r-x,user:ora112:r-x
ACTION_FAILURE_TEMPLATE=
ACTION_SCRIPT=
ACTIVE_PLACEMENT=1
AGENT_FILENAME=%CRS_HOME%/bin/orarootagent%CRS_EXE_SUFFIX%
AUTO_START=restore
CARDINALITY=1
CHECK_INTERVAL=1
DEFAULT_TEMPLATE=PROPERTY(RESOURCE_CLASS=scan_vip)
DEGREE=1
DESCRIPTION=Oracle SCAN VIP resource
ENABLED=1
FAILOVER_DELAY=0
FAILURE_INTERVAL=0
FAILURE_THRESHOLD=0
HOSTING_MEMBERS=
LOAD=1
LOGGING_LEVEL=1
NLS_LANG=
NOT_RESTARTING_TEMPLATE=
OFFLINE_CHECK_INTERVAL=0
PLACEMENT=balanced
PROFILE_CHANGE_TEMPLATE=
RESTART_ATTEMPTS=0
SCAN_NAME=cluster1
SCRIPT_TIMEOUT=60
SERVER_POOLS=*
START_DEPENDENCIES=hard(ora.net1.network) dispersion:active(type:ora.scan_vip.type) pullup(ora.net1.network)
START_TIMEOUT=0
STATE_CHANGE_TEMPLATE=
STOP_DEPENDENCIES=hard(ora.net1.network)
STOP_TIMEOUT=0
UPTIME_THRESHOLD=1h
USR_ORA_ENV=
USR_ORA_VIP=192.168.1.10
VERSION=11.2.0.1.0

NAME=ora.scan2.vip
TYPE=ora.scan_vip.type
ACL=owner:root:rwx,pgrp:root:r-x,other::r--,group:oinstall:r-x,user:ora112:r-x
ACTION_FAILURE_TEMPLATE=
ACTION_SCRIPT=
ACTIVE_PLACEMENT=1
AGENT_FILENAME=%CRS_HOME%/bin/orarootagent%CRS_EXE_SUFFIX%
AUTO_START=restore
CARDINALITY=1
CHECK_INTERVAL=1
DEFAULT_TEMPLATE=PROPERTY(RESOURCE_CLASS=scan_vip)
DEGREE=1
DESCRIPTION=Oracle SCAN VIP resource
ENABLED=1
FAILOVER_DELAY=0
FAILURE_INTERVAL=0
FAILURE_THRESHOLD=0
HOSTING_MEMBERS=
LOAD=1
LOGGING_LEVEL=1
NLS_LANG=
NOT_RESTARTING_TEMPLATE=
OFFLINE_CHECK_INTERVAL=0
PLACEMENT=balanced
PROFILE_CHANGE_TEMPLATE=
RESTART_ATTEMPTS=0
SCAN_NAME=cluster1
SCRIPT_TIMEOUT=60
SERVER_POOLS=*
START_DEPENDENCIES=hard(ora.net1.network) dispersion:active(type:ora.scan_vip.type) pullup(ora.net1.network)
START_TIMEOUT=0
STATE_CHANGE_TEMPLATE=
STOP_DEPENDENCIES=hard(ora.net1.network)
STOP_TIMEOUT=0
UPTIME_THRESHOLD=1h
USR_ORA_ENV=
USR_ORA_VIP=192.168.1.11
VERSION=11.2.0.1.0

NAME=ora.scan3.vip
TYPE=ora.scan_vip.type
ACL=owner:root:rwx,pgrp:root:r-x,other::r--,group:oinstall:r-x,user:ora112:r-x
ACTION_FAILURE_TEMPLATE=
ACTION_SCRIPT=
ACTIVE_PLACEMENT=1
AGENT_FILENAME=%CRS_HOME%/bin/orarootagent%CRS_EXE_SUFFIX%
AUTO_START=restore
CARDINALITY=1
CHECK_INTERVAL=1
DEFAULT_TEMPLATE=PROPERTY(RESOURCE_CLASS=scan_vip)
DEGREE=1
DESCRIPTION=Oracle SCAN VIP resource
ENABLED=1
FAILOVER_DELAY=0
FAILURE_INTERVAL=0
FAILURE_THRESHOLD=0
HOSTING_MEMBERS=
LOAD=1
LOGGING_LEVEL=1
NLS_LANG=
NOT_RESTARTING_TEMPLATE=
OFFLINE_CHECK_INTERVAL=0
PLACEMENT=balanced
PROFILE_CHANGE_TEMPLATE=
RESTART_ATTEMPTS=0
SCAN_NAME=cluster1
SCRIPT_TIMEOUT=60
SERVER_POOLS=*
START_DEPENDENCIES=hard(ora.net1.network) dispersion:active(type:ora.scan_vip.type) pullup(ora.net1.network)
START_TIMEOUT=0
STATE_CHANGE_TEMPLATE=
STOP_DEPENDENCIES=hard(ora.net1.network)
STOP_TIMEOUT=0
UPTIME_THRESHOLD=1h
USR_ORA_ENV=
USR_ORA_VIP=192.168.1.9
VERSION=11.2.0.1.0

NAME=ora.vm1.vip
TYPE=ora.cluster_vip_net1.type
ACL=owner:root:rwx,pgrp:root:r-x,other::r--,group:oinstall:r-x,user:ora112:r-x
ACTION_FAILURE_TEMPLATE=
ACTION_SCRIPT=
ACTIVE_PLACEMENT=1
AGENT_FILENAME=%CRS_HOME%/bin/orarootagent%CRS_EXE_SUFFIX%
AUTO_START=restore
CARDINALITY=1
CHECK_INTERVAL=1
DEFAULT_TEMPLATE=PROPERTY(RESOURCE_CLASS=vip)
DEGREE=1
DESCRIPTION=Oracle VIP resource
ENABLED=1
FAILOVER_DELAY=0
FAILURE_INTERVAL=0
FAILURE_THRESHOLD=0
HOSTING_MEMBERS=vm1
LOAD=1
LOGGING_LEVEL=1
NLS_LANG=
NOT_RESTARTING_TEMPLATE=
OFFLINE_CHECK_INTERVAL=0
PLACEMENT=favored
PROFILE_CHANGE_TEMPLATE=
RESTART_ATTEMPTS=0
SCRIPT_TIMEOUT=60
SERVER_POOLS=*
START_DEPENDENCIES=hard(ora.net1.network) pullup(ora.net1.network)
START_TIMEOUT=0
STATE_CHANGE_TEMPLATE=
STOP_DEPENDENCIES=hard(ora.net1.network)
STOP_TIMEOUT=0
UPTIME_THRESHOLD=1h
USR_ORA_ENV=
USR_ORA_VIP=vip1
VERSION=11.2.0.1.0

NAME=ora.vm2.vip
TYPE=ora.cluster_vip_net1.type
ACL=owner:root:rwx,pgrp:root:r-x,other::r--,group:oinstall:r-x,user:ora112:r-x
ACTION_FAILURE_TEMPLATE=
ACTION_SCRIPT=
ACTIVE_PLACEMENT=1
AGENT_FILENAME=%CRS_HOME%/bin/orarootagent%CRS_EXE_SUFFIX%
AUTO_START=restore
CARDINALITY=1
CHECK_INTERVAL=1
DEFAULT_TEMPLATE=PROPERTY(RESOURCE_CLASS=vip)
DEGREE=1
DESCRIPTION=Oracle VIP resource
ENABLED=1
FAILOVER_DELAY=0
FAILURE_INTERVAL=0
FAILURE_THRESHOLD=0
HOSTING_MEMBERS=vm2
LOAD=1
LOGGING_LEVEL=1
NLS_LANG=
NOT_RESTARTING_TEMPLATE=
OFFLINE_CHECK_INTERVAL=0
PLACEMENT=favored
PROFILE_CHANGE_TEMPLATE=
RESTART_ATTEMPTS=0
SCRIPT_TIMEOUT=60
SERVER_POOLS=*
START_DEPENDENCIES=hard(ora.net1.network) pullup(ora.net1.network)
START_TIMEOUT=0
STATE_CHANGE_TEMPLATE=
STOP_DEPENDENCIES=hard(ora.net1.network)
STOP_TIMEOUT=0
UPTIME_THRESHOLD=1h
USR_ORA_ENV=
USR_ORA_VIP=vip2
VERSION=11.2.0.1.0

マニュアル

11.2マニュアル
Real Application Clusters管理およびデプロイメント・ガイド11g リリース2(11.2)
Clusterware管理およびデプロイメント・ガイド11gリリース2(11.2)
カスタム検索

★ORACLE案件承ります
▼ORACLE掲示板