Créez au moins une instance dans chaque machine virtuelle de base de données. Vous pouvez créer plusieurs instances de base de données pour chaque répertoire de base de la base de données. Le nombre total d'instances que vous pouvez créer est limité par la quantité d'espace disque disponible.
% mcmu tenant -I -c
Dans cet exemple, une instance RAC est sélectionnée, de sorte que mcmu vous invite à sélectionner une machine virtuelle pour chaque noeud.
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>
.
Dans cet exemple, les détails de toutes les instances de base de données dans l'ID de répertoire de base indiqué sont répertoriés.
% 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
Cet exemple répertorie les détails sur toutes les 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