Cree al menos una instancia en cada máquina virtual de base de datos. Puede crear varias instancias de base de datos para cada directorio raíz de base de datos. El número total de instancias que puede crear está limitado por la cantidad de espacio en disco disponible.
% mcmu tenant -I -c
En este ejemplo, se selecciona una instancia de RAC, de modo que mcmu le solicita que seleccione una máquina virtual de cada nodo.
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> .
En este ejemplo, se muestran los detalles de todas las instancias de base datos del ID del directorio raíz especificado.
% 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
En este ejemplo, se muestran los detalles de todas las zonas.
% 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