각 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