Create at least one instance in each DB VM. You can create multiple DB instances for each DB Home. The total number of instances you can create is limited by the amount of disk space available.
% mcmu tenant -I -c
In this example, a RAC instance is selected, so mcmu prompts you to select one VM from each node.
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.. . <output omitted> .
This example lists the details of all DB instances in the specified home ID.
% 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
This example lists the details about all the zones.
% 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