株式会社コーソル

コーソルDatabaseエンジニアのブログ

技術ブログ

12.1.0.2 RAC : Grid Infrastructure Management Repositoryについて少し

いっこうに Oracle Database 12.1.0.2 のVMテンプレートがリリースされる気配がないので、 しびれを切らして 12.1.0.2 RAC を自分でインストールして環境を構築しました。

上記の "Automatic Installation of Grid Infrastructure Management Repository" のとおり、Grid Infrastructure Management Repository関連のリソースとプロセスが増えていますね・・・

[root@lc102ru1 ~]# /u01/app/12.1.0.2/grid/bin/crsctl status resource -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.CLU.dg
               ONLINE  ONLINE       lc102ru1                 STABLE
               ONLINE  ONLINE       lc102ru2                 STABLE
               ONLINE  ONLINE       lc102ru3                 STABLE
ora.DB.dg
               ONLINE  ONLINE       lc102ru1                 STABLE
               ONLINE  ONLINE       lc102ru2                 STABLE
               ONLINE  ONLINE       lc102ru3                 STABLE
ora.FRA.dg
               ONLINE  ONLINE       lc102ru1                 STABLE
               ONLINE  ONLINE       lc102ru2                 STABLE
               ONLINE  ONLINE       lc102ru3                 STABLE
ora.LISTENER.lsnr
               ONLINE  ONLINE       lc102ru1                 STABLE
               ONLINE  ONLINE       lc102ru2                 STABLE
               ONLINE  ONLINE       lc102ru3                 STABLE
ora.asm
               ONLINE  ONLINE       lc102ru1                 Started,STABLE
               ONLINE  ONLINE       lc102ru2                 Started,STABLE
               ONLINE  ONLINE       lc102ru3                 Started,STABLE
ora.net1.network
               ONLINE  ONLINE       lc102ru1                 STABLE
               ONLINE  ONLINE       lc102ru2                 STABLE
               ONLINE  ONLINE       lc102ru3                 STABLE
ora.ons
               ONLINE  ONLINE       lc102ru1                 STABLE
               ONLINE  ONLINE       lc102ru2                 STABLE
               ONLINE  ONLINE       lc102ru3                 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       lc102ru1                 STABLE
ora.MGMTLSNR
      1        ONLINE  ONLINE       lc102ru1                 169.254.90.138 172.3
                                                             0.51.1,STABLE
ora.c102ru.db
      1        ONLINE  ONLINE       lc102ru1                 Open,STABLE
      2        ONLINE  ONLINE       lc102ru2                 Open,STABLE
      3        ONLINE  ONLINE       lc102ru3                 Open,STABLE
ora.cvu
      1        ONLINE  ONLINE       lc102ru1                 STABLE
ora.lc102ru1.vip
      1        ONLINE  ONLINE       lc102ru1                 STABLE
ora.lc102ru2.vip
      1        ONLINE  ONLINE       lc102ru2                 STABLE
ora.lc102ru3.vip
      1        ONLINE  ONLINE       lc102ru3                 STABLE
ora.mgmtdb
      1        ONLINE  ONLINE       lc102ru1                 Open,STABLE
ora.oc4j
      1        ONLINE  ONLINE       lc102ru1                 STABLE
ora.scan1.vip
      1        ONLINE  ONLINE       lc102ru1                 STABLE
--------------------------------------------------------------------------------
[root@lc102ru1 ~]# ps -U 'oracle,grid' -o pid,cmd --sort=cmd
  PID CMD
 4586 asm_asmb_+ASM1
 4435 asm_ckpt_+ASM1
 4427 asm_dbw0_+ASM1
 4401 asm_dia0_+ASM1
 4393 asm_diag_+ASM1
 4483 asm_gcr0_+ASM1
 4381 asm_gen0_+ASM1
 4455 asm_gmon_+ASM1
 4467 asm_lck0_+ASM1
 4423 asm_lck1_+ASM1
 4431 asm_lgwr_+ASM1
 4409 asm_lmd0_+ASM1
 4419 asm_lmhb_+ASM1
 4405 asm_lmon_+ASM1
 4413 asm_lms0_+ASM1
 4443 asm_lreg_+ASM1
 4385 asm_mman_+ASM1
 4463 asm_mmnl_+ASM1
 4459 asm_mmon_+ASM1
 4397 asm_ping_+ASM1
 4367 asm_pmon_+ASM1
 4371 asm_psp0_+ASM1
 4447 asm_pxmn_+ASM1
 4451 asm_rbal_+ASM1
 4439 asm_smon_+ASM1
 4375 asm_vktm_+ASM1
 3770 /u01/app/12.1.0.2/grid/bin/evmd.bin
 3801 /u01/app/12.1.0.2/grid/bin/evmlogger.bin -o /u01/app/12.1.0.2/grid/log/[HOSTNAME
 3807 /u01/app/12.1.0.2/grid/bin/gipcd.bin
 3785 /u01/app/12.1.0.2/grid/bin/gpnpd.bin
 4901 /u01/app/12.1.0.2/grid/jdk/bin/java -server -Xms128M -Xmx384M -Djava.awt.headles
 5568 mdb_aqpc_-MGMTDB
 5240 mdb_asmb_-MGMTDB
 5594 mdb_cjq0_-MGMTDB
 5185 mdb_ckpt_-MGMTDB
 5265 mdb_d000_-MGMTDB
 5160 mdb_dbrm_-MGMTDB
 5172 mdb_dbw0_-MGMTDB
 5168 mdb_dia0_-MGMTDB
 5156 mdb_diag_-MGMTDB
 5144 mdb_gen0_-MGMTDB
 5194 mdb_lg00_-MGMTDB
 5206 mdb_lg01_-MGMTDB
 5178 mdb_lgwr_-MGMTDB
 5216 mdb_lreg_-MGMTDB
 5271 mdb_mark_-MGMTDB
 5148 mdb_mman_-MGMTDB
 5255 mdb_mmnl_-MGMTDB
 5248 mdb_mmon_-MGMTDB
 5120 mdb_pmon_-MGMTDB
 5125 mdb_psp0_-MGMTDB
 5224 mdb_pxmn_-MGMTDB
 6085 mdb_q002_-MGMTDB
 6093 mdb_q004_-MGMTDB
 6077 mdb_qm02_-MGMTDB
 5230 mdb_rbal_-MGMTDB
 5283 mdb_s000_-MGMTDB
 5534 mdb_smco_-MGMTDB
 5200 mdb_smon_-MGMTDB
 5518 mdb_tmon_-MGMTDB
 5522 mdb_tt00_-MGMTDB
 5164 mdb_vkrm_-MGMTDB
 5138 mdb_vktm_-MGMTDB
 5538 mdb_w000_-MGMTDB
 5542 mdb_w001_-MGMTDB
14478 mdb_w002_-MGMTDB
 3769 /u01/app/12.1.0.2/grid/bin/mdnsd.bin
 4038 /u01/app/12.1.0.2/grid/bin/ocssd.bin
 4823 /u01/app/12.1.0.2/grid/opmn/bin/ons -d
 4824 /u01/app/12.1.0.2/grid/opmn/bin/ons -d
 5249 ora_acms_c102ru1
 5590 ora_aqpc_c102ru1
 5371 ora_asmb_c102ru1
 5697 ora_cjq0_c102ru1
 5334 ora_ckpt_c102ru1
 5387 ora_d000_c102ru1
 5223 ora_dbrm_c102ru1
 5326 ora_dbw0_c102ru1
 5263 ora_dia0_c102ru1
 5214 ora_diag_c102ru1
 5399 ora_gcr0_c102ru1
 5188 ora_gen0_c102ru1
 5582 ora_gtx0_c102ru1
 5442 ora_lck0_c102ru1
 5322 ora_lck1_c102ru1
 5338 ora_lg00_c102ru1
 5346 ora_lg01_c102ru1
 5330 ora_lgwr_c102ru1
 5287 ora_lmd0_c102ru1
 5318 ora_lmhb_c102ru1
 5274 ora_lmon_c102ru1
 5299 ora_lms0_c102ru1
 5354 ora_lreg_c102ru1
 5391 ora_mark_c102ru1
 5196 ora_mman_c102ru1
 5381 ora_mmnl_c102ru1
 5375 ora_mmon_c102ru1
 5526 ora_p000_c102ru1
 5530 ora_p001_c102ru1
 5710 ora_p002_c102ru1
 5718 ora_p003_c102ru1
 5722 ora_p004_c102ru1
 5726 ora_p005_c102ru1
 5730 ora_p006_c102ru1
 5734 ora_p007_c102ru1
 5241 ora_ping_c102ru1
 5129 ora_pmon_c102ru1
13113 ora_ppa6_c102ru1
12973 ora_ppa7_c102ru1
 5133 ora_psp0_c102ru1
 5359 ora_pxmn_c102ru1
 6167 ora_q001_c102ru1
 6175 ora_q003_c102ru1
13071 ora_q005_c102ru1
14491 ora_q006_c102ru1
 6162 ora_qm02_c102ru1
12969 ora_qm03_c102ru1
 6171 ora_qm05_c102ru1
 5367 ora_rbal_c102ru1
 5586 ora_rcbg_c102ru1
 5350 ora_reco_c102ru1
 5311 ora_rms0_c102ru1
 5415 ora_rmv0_c102ru1
 5453 ora_rsmn_c102ru1
 5395 ora_s000_c102ru1
 5562 ora_smco_c102ru1
 5342 ora_smon_c102ru1
 5554 ora_tmon_c102ru1
 5558 ora_tt00_c102ru1
 5232 ora_vkrm_c102ru1
 5177 ora_vktm_c102ru1
 5566 ora_w000_c102ru1
 5574 ora_w001_c102ru1
14498 ora_w002_c102ru1
 3753 /u01/app/12.1.0.2/grid/bin/oraagent.bin
 4649 /u01/app/12.1.0.2/grid/bin/oraagent.bin
 5042 /u01/app/12.1.0.2/grid/bin/oraagent.bin
12906 oracle-MGMTDB (LOCAL=NO)
 4582 oracle+ASM1_ocr (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
 4591 oracle+ASM1_asmb_+asm1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
 4746 oracle+ASM1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
 4757 oracle+ASM1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
 4768 oracle+ASM1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
 5254 oracle+ASM1_asmb_-mgmtdb (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
 5379 oracle+ASM1_asmb_c102ru1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
 5740 oraclec102ru1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
 5745 oraclec102ru1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
 5805 oracle-MGMTDB (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
 5855 oracle-MGMTDB (LOCAL=NO)
 5889 oracle-MGMTDB (LOCAL=NO)
 4792 /u01/app/12.1.0.2/grid/bin/scriptagent.bin
 4797 /u01/app/12.1.0.2/grid/bin/tnslsnr MGMTLSNR -no_crs_notify -inherit
 4947 /u01/app/12.1.0.2/grid/bin/tnslsnr LISTENER -no_crs_notify -inherit
 4967 /u01/app/12.1.0.2/grid/bin/tnslsnr LISTENER_SCAN1 -no_crs_notify -inherit

MGMTDB は、Grid Infrastructure Management Repository に相当するOracleデータベースのようです。あまり細かく調べていませんが、構成ファイルはクラスタ共有記憶域用のASMディスクグループに作成されるようです。これに伴い記憶域に関するサイズの要件も大きくなってるような・・・

SQL> SELECT concat('+'||gname, sys_connect_by_path(aname, '/')) full_alias_path
  2    FROM (SELECT g.name gname, a.parent_index pindex,a.name aname, a.reference_index rindex
  3            FROM v$asm_alias a, v$asm_diskgroup g
  4           WHERE a.group_number = g.group_number
  5             AND g.name = 'CLU')
  6    START WITH (mod(pindex, power(2, 24))) = 0
  7    CONNECT BY PRIOR rindex = pindex;

FULL_ALIAS_PATH
----------------------------------------------------------------------------------------------------------------------------------------------------------------
+CLU/lc102ru-cluster
+CLU/lc102ru-cluster/ASMPARAMETERFILE
+CLU/lc102ru-cluster/ASMPARAMETERFILE/REGISTRY.253.859900561
+CLU/lc102ru-cluster/OCRFILE
+CLU/lc102ru-cluster/OCRFILE/REGISTRY.255.859900565
+CLU/ASM
+CLU/ASM/PASSWORD
+CLU/ASM/PASSWORD/pwdasm.256.859900563
+CLU/_MGMTDB
+CLU/_MGMTDB/DATAFILE
+CLU/_MGMTDB/DATAFILE/UNDOTBS1.259.859901875
+CLU/_MGMTDB/DATAFILE/SYSTEM.258.859901849
+CLU/_MGMTDB/DATAFILE/SYSAUX.257.859901827
+CLU/_MGMTDB/CONTROLFILE
+CLU/_MGMTDB/CONTROLFILE/Current.260.859901917
+CLU/_MGMTDB/ONLINELOG
+CLU/_MGMTDB/ONLINELOG/group_1.261.859901919
+CLU/_MGMTDB/ONLINELOG/group_3.263.859901923
+CLU/_MGMTDB/ONLINELOG/group_2.262.859901921
+CLU/_MGMTDB/TEMPFILE
+CLU/_MGMTDB/TEMPFILE/TEMP.264.859901927
+CLU/_MGMTDB/FD9AC0F7C36E4438E043B6A9E80A24D5
+CLU/_MGMTDB/FD9AC0F7C36E4438E043B6A9E80A24D5/DATAFILE
+CLU/_MGMTDB/FD9AC0F7C36E4438E043B6A9E80A24D5/DATAFILE/SYSTEM.265.859901931
+CLU/_MGMTDB/FD9AC0F7C36E4438E043B6A9E80A24D5/DATAFILE/SYSAUX.266.859901931
+CLU/_MGMTDB/FD9AC0F7C36E4438E043B6A9E80A24D5/DATAFILE/pdbseed_temp012014-10-02_01-39-20-PM.dbf
+CLU/_MGMTDB/046A33303A972A4DE05301331FAC38E3
+CLU/_MGMTDB/046A33303A972A4DE05301331FAC38E3/TEMPFILE
+CLU/_MGMTDB/046A33303A972A4DE05301331FAC38E3/TEMPFILE/TEMP.267.859901961
+CLU/_MGMTDB/PARAMETERFILE
+CLU/_MGMTDB/PARAMETERFILE/spfile.268.859902035
+CLU/_MGMTDB/FD9B43BF6A646F8CE043B6A9E80A2815
+CLU/_MGMTDB/FD9B43BF6A646F8CE043B6A9E80A2815/DATAFILE
+CLU/_MGMTDB/FD9B43BF6A646F8CE043B6A9E80A2815/DATAFILE/lc102ru_cluster_temp012014-10-02_01-44-31-PM.dbf
+CLU/_MGMTDB/FD9B43BF6A646F8CE043B6A9E80A2815/DATAFILE/SYSTEM.270.859902183
+CLU/_MGMTDB/FD9B43BF6A646F8CE043B6A9E80A2815/DATAFILE/SYSMGMTDATA.269.859902183
+CLU/_MGMTDB/FD9B43BF6A646F8CE043B6A9E80A2815/DATAFILE/SYSAUX.271.859902183
+CLU/_MGMTDB/FD9B43BF6A646F8CE043B6A9E80A2815/DATAFILE/SYSGRIDHOMEDATA.272.859902183
+CLU/_MGMTDB/FD9B43BF6A646F8CE043B6A9E80A2815/DATAFILE/SYSMGMTDATADB.273.859902183
+CLU/_MGMTDB/FD9B43BF6A646F8CE043B6A9E80A2815/DATAFILE/USERS.274.859902183
+CLU/_MGMTDB/046A45BD88D43573E05301331FACC6C5
+CLU/_MGMTDB/046A45BD88D43573E05301331FACC6C5/TEMPFILE
+CLU/_MGMTDB/046A45BD88D43573E05301331FACC6C5/TEMPFILE/TEMP.275.859902271
+CLU/orapwasm

44 rows selected.

プロフィール

On7tWW6m1Ul4

渡部 亮太

・Oracle ACE
・AWS Certified Solutions Architect - Associate
・ORACLE MASTER Platinum Oracle Database 11g, 12c 他多数

カテゴリー

アーカイブ