技術ブログ
技術ブログ
いっこうに 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.
プロフィール
渡部 亮太
・Oracle ACE
・AWS Certified Solutions Architect - Associate
・ORACLE MASTER Platinum Oracle Database 11g, 12c 他多数
カテゴリー
アーカイブ
2024年
2023年
2022年
2021年
2020年
2019年
2018年
2017年
2016年
2015年
2014年
2013年
2012年
2000年