在每个 DB VM 中创建至少一个实例。可为每个 DB 主目录创建多个 DB 实例。可创建的实例总数受可用磁盘空间量的限制。
% mcmu tenant -I -c
在以下示例中,选择了一个 RAC 实例,因此 mcmu 会提示您从每个节点中选择一个 VM。
Database Instance Profile Description Select Database Instance Type [SINGLE/RAC/RACONE] : rac Select Database Instance Template: Data Warehouse(DW) / Online Transaction Processing(OLTP) [DW/OLTP] : dw List of Character Set [1] AL32UTF8 [2] AR8ADOS710 [3] AR8ADOS710T [4] AR8ADOS720 [5] AR8ADOS720T [6] AR8APTEC715 [7] AR8APTEC715T [8] AR8ARABICMACS [9] AR8ASMO708PLUS [10] AR8ASMO8X [11] AR8HPARABIC8T [12] AR8ISO8859P6 [13] AR8MSWIN1256 [14] AR8MUSSAD768 [15] AR8MUSSAD768T [16] AR8NAFITHA711 [17] AR8NAFITHA711T [18] AR8NAFITHA721 [19] AR8NAFITHA721T [20] AR8SAKHR706 [21] AR8SAKHR707 [22] AR8SAKHR707T [23] AZ8ISO8859P9E [24] BG8MSWIN [25] BG8PC437S [26] BLT8CP921 [27] BLT8ISO8859P13 [28] BLT8MSWIN1257 [29] BLT8PC775 [30] BN8BSCII [31] CDN8PC863 [32] CEL8ISO8859P14 [33] CL8ISO8859P5 [34] CL8ISOIR111 [35] CL8KOI8R [36] CL8KOI8U [37] CL8MACCYRILLICS [38] CL8MSWIN1251 [39] EE8ISO8859P2 [40] EE8MACCES [41] EE8MACCROATIANS [42] EE8MSWIN1250 [43] EE8PC852 [44] EL8DEC [45] EL8ISO8859P7 [46] EL8MACGREEKS [47] EL8MSWIN1253 [48] EL8PC437S [49] EL8PC851 [50] EL8PC869 [51] ET8MSWIN923 [52] HU8ABMOD [53] HU8CWI2 [54] IN8ISCII [55] IS8PC861 [56] IW8ISO8859P8 [57] IW8MACHEBREWS [58] IW8MSWIN1255 [59] IW8PC1507 [60] JA16EUC [61] JA16EUCTILDE [62] JA16SJIS [63] JA16SJISTILDE [64] JA16VMS [65] KO16KSC5601 [66] KO16KSCCS [67] KO16MSWIN949 [68] LA8ISO6937 [69] LA8PASSPORT [70] LT8MSWIN921 [71] LT8PC772 [72] LT8PC774 [73] LV8PC1117 [74] LV8PC8LR [75] LV8RST104090 [76] N8PC865 [77] NE8ISO8859P10 [78] NEE8ISO8859P4 [79] RU8BESTA [80] RU8PC855 [81] RU8PC866 [82] SE8ISO8859P3 [83] TH8MACTHAIS [84] TH8TISASCII [85] TR8DEC [86] TR8MACTURKISHS [87] TR8MSWIN1254 [88] TR8PC857 [89] US8PC437 [90] UTF8 [91] VN8MSWIN1258 [92] VN8VN3 [93] WE8DEC [94] WE8DG [95] WE8ISO8859P1 [96] WE8ISO8859P15 [97] WE8ISO8859P9 [98] WE8MACROMAN8S [99] WE8MACROMAN8S [100] WE8MSWIN1252 [101] WE8NCR4970 [102] WE8NEXTSTEP [103] WE8PC850 [104] WE8PC858 [105] WE8PC860 [106] WE8ROMAN8 [107] ZHS16CGB231280 [108] ZHS16GBK [109] ZHT16BIG5 [110] ZHT16CCDC [111] ZHT16DBT [112] ZHT16HKSCS [113] ZHT16MSWIN950 [114] ZHT32EUC [115] ZHT32SOPS [116] ZHT32TRIS [117] US7ASCII Select Character Set Number (1): 98 List of National Character Set [1] AL16UTF16 [2] UTF8 Select National Character Set Number (1): 2 Listing DB VM Group Profile.. Status : Active EditStatus : Description : DB MVM Group 1 - NORMAL - SHARED - CIS deletable : True progress : False VMgroupName : dbgp1 editable : True VMgroupID : 1 Select Database VMgroupID [1] (1): List of All Active VMs in VM Group dbgp1 Getting DB VM Group... status : Active name : dbgp1-vm1-mc3-n1 globalName : mc3-n1 id : 1 memory : 522496 cores : 4 status : Active name : dbgp1-vm2-mc3-n1 globalName : mc3-n1 id : 2 memory : 522496 cores : 3 status : Active name : dbgp1-vm1-mc3-n2 globalName : mc3-n2 id : 3 memory : 522496 cores : 0 status : Active name : dbgp1-vm2-mc3-n2 globalName : mc3-n2 id : 4 memory : 522496 cores : 0 Select Database VM ID [1/2/3/4] : 1 List of All Active DB home in zone dbgp1-vm1-mc3-n1 Listing DB Home... status : Active VM_id : 1 version : 12.1.0.2 home : /u01/app/oracle/product/12.1.0/dbhome_12c type : RAC id : 1 status : Active VM_id : 1 version : 11.2.0.4 home : /u01/app/oracle/product/11.2.0/dbhome_11g type : RAC id : 5 Select Database Home ID [1/5] : 1 Select one VM from the other compute node status : Active name : dbgp1-vm1-mc3-n2 globalName : mc3-n2 id : 3 memory : 522496 cores : 0 status : Active name : dbgp1-vm2-mc3-n2 globalName : mc3-n2 id : 4 memory : 522496 cores : 0 Select Secondary Database VM ID [3/4] : 3 Enter Container Database [True/False] (false): false Enter PGA (Program Global Area) in MB (2560): 5120 Enter SGA (System Global Area) in MB (6400): 12800 Enter Database Instance Name : dw12rac List of Inputs for DB Instance Creation: Database Instance Type: RAC Database Instance Template: DW VM: dbgp1-vm1-mc3-n1,dbgp1-vm1-mc3-n2 (ID: 1,3) Database Home: /u01/app/oracle/product/12.1.0/dbhome_12c (ID: 1) PGA (Program Global Area) in MB: 5120 SGA (System Global Area) in MB: 12800 Database Instance Name: dw12rac Character Set: WE8MACROMAN8S National Character Set: UTF8 Container Database : false Do you want to change the inputs? Enter Y/N (N): N Creating DB Instance... INFO Collecting node information for creating instance. . <some output omitted> .
以下示例列出了指定的主目录 ID 中所有 DB 实例的详细信息。
% mcmu tenant -I -l 1 Setting ssh timeout before carrying out further operations. Please wait.. [INFO ] Log file path : /var/opt/oracle.minicluster/setup/logs/tenant_cli_082416_162942.log LIST OF DB INSTANCES IN DB VM GROUP 1 ID: 3, NAME: dw12rac, VM_ID: 1, DBHOME_ID: 1, TYPE: RAC, STATUS: Active ID: 12, NAME: ol11rac1, VM_ID: 1, DBHOME_ID: 5, TYPE: RACONENODE, STATUS: Active ID: 14, NAME: ol12sinC, VM_ID: 2, DBHOME_ID: 2, TYPE: SINGLE, STATUS: Active ID: 7, NAME: dw11rac, VM_ID: 2, DBHOME_ID: 6, TYPE: RAC, STATUS: Active ID: 4, NAME: dw12rac, VM_ID: 3, DBHOME_ID: 3, TYPE: RAC, STATUS: Active ID: 11, NAME: ol11rac1, VM_ID: 3, DBHOME_ID: 7, TYPE: RACONENODE, STATUS: Active ID: 8, NAME: dw11rac, VM_ID: 4, DBHOME_ID: 8, TYPE: RAC, STATUS: Active ID: 16, NAME: dw11sin, VM_ID: 4, DBHOME_ID: 8, TYPE: SINGLE, STATUS: Active
以下示例列出了有关所有区域的详细信息。
% mcmu status -Z -a [INFO ] Log file path : mc3-n1:/var/opt/oracle.minicluster/setup/logs/mcmu_082416_170213.log [INFO ] Zone status on node1 ID NAME STATUS PATH BRAND IP 0 global running / solaris shared 2 acfskz running - solaris-kz excl 7 dbgp1-vm1-mc3-n1 running /mcpool/dbgp1-vm1-mc3-n1zroot solaris excl 8 dbgp1-vm2-mc3-n1 running /mcpool/dbgp1-vm2-mc3-n1zroot solaris excl 11 avm1-vm1-mc3-n1 running /mcpool/avm1-vm1-mc3-n1zroot solaris excl 14 avm2-vm1-mc3-n1 running /mcpool/avm2-vm1-mc3-n1zroot solaris excl 17 avm4-vm1-mc3-n1 running /mcpool/avm4-vm1-mc3-n1zroot solaris excl 20 avm5-vm1-mc3-n1 running /mcpool/avm5-vm1-mc3-n1zroot solaris excl - appzonetemplate installed /mcpool/appzonetemplate solaris excl - dbzonetemplate installed /mcpool/dbzonetemplate solaris excl [INFO ] Zone status on node2 ID NAME STATUS PATH BRAND IP 0 global running / solaris shared 2 acfskz running - solaris-kz excl 7 dbgp1-vm1-mc3-n2 running /mcpool/dbgp1-vm1-mc3-n2zroot solaris excl 8 dbgp1-vm2-mc3-n2 running /mcpool/dbgp1-vm2-mc3-n2zroot solaris excl 11 avm1-vm1-mc3-n2 running /mcpool/avm1-vm1-mc3-n2zroot solaris excl 14 avm2-vm1-mc3-n2 running /mcpool/avm2-vm1-mc3-n2zroot solaris excl 17 avm6-vm1-mc3-n2 running /mcpool/avm6-vm1-mc3-n2zroot solaris excl 20 avm7-vm1-mc3-n2 running /mcpool/avm7-vm1-mc3-n2zroot solaris excl - appzonetemplate installed /mcpool/appzonetemplate solaris excl - dbzonetemplate installed /mcpool/dbzonetemplate solaris excl