Utilisez cette procédure pour apporter une des modifications suivantes à un groupe de machines virtuelles de base de données :
Augmenter le nombre de machines virtuelles dans le groupe.
Augmenter ou diminuer le nombre de coeurs dans les machines virtuelles.
Voir Connexion à la CLI MCMU.
Dans cet exemple, le nombre de machines virtuelles sur les noeuds 1 et 2 est augmenté pour passer de deux machines virtuelles à trois par noeud. Les nouvelles machines virtuelles sont VM5 et VM6. La commande mcmu invite à la saisie des paramètres pour les nouvelles machines virtuelles. En appuyant sur Retour, vous acceptez la valeur par défaut, qui est affichée entre parenthèses.
% mcmu tenant -P -u
Listing DB VM Group Profile..
Status : Active
EditStatus :
Description : DBVM Group 1 - NORMAL - SHARED - CIS
deletable : True
progress : False
VMgroupName : dbgp1
editable : True
VMgroupID : 1
Enter ID of the VM Group Profile that you want to edit[1] (1): 1
Do you want to "[E]dit & Save the changes"?
Enter Y/N (Y): Y
Getting DB VM Group Profile...
Edit Database Virtual Machine Group Profile Description
Virtual Machine Group Profile Name : dbgp1
Enter Number of VM(s) on Node 1, between(2,4) (2): 3
Enter Number of VM(s) on Node 2, between(2,4) (2): 3
Enter Description (DB MVM Group 1 - NORMAL - SHARED - CIS): <Return>
Virtual Machine Group Profile Name : dbgp1
ASM Disk Group Redundancy : NORMAL
PCI DSS Security Setting Enabled: No
Number of Disks : None
Number of VM(s) on Node 1 : 3
Number of VM(s) on Node 2 : 3
Description : DBVM Group 1 - NORMAL - SHARED - CIS
Virtual Machines Information
Node 1 : mc3-n1
Virtual Machine 1
CURRENT VM STATUS: active
Public Hostname mc3-n1vm1-z1
Public IP: 10.129.115.196
Private Hostname mc3-n1vm1-z1-priv
Private IP: 192.168.10.66
Virtual Hostname mc3-n1vm1-z1-vip
Virtual IP: 10.129.115.197
Enter Cores [0 to max 7] (4): <Return>
Virtual Machine 2
CURRENT VM STATUS: active
Public Hostname mc3-n1vm1-z2
Public IP: 10.129.115.198
Private Hostname mc3-n1vm1-z2-priv
Private IP: 192.168.10.67
Virtual Hostname mc3-n1vm1-z2-vip
Virtual IP: 10.129.115.199
Enter Cores [0 to max 3] (3): <Return>
Virtual Machine 3
Enter Public Hostname (dbgp1-vm3-mc3-n1): mc3-n1vm1-z3
Enter Public IP (To be generated): <Return>
Enter Private Hostname (mc3-n1vm1-z3-priv): <Return>
Enter Private IP (To be generated): <Return>
Enter Virtual Hostname (mc3-n1vm1-z3-vip): <Return>
Enter Virtual IP (To be generated): <Return>
Enter Cores [0 to max 0] (0): <Return>
Node 2: mc3-n2
Virtual Machine 1
CURRENT VM STATUS: active
Public Hostname mc3-n2vm1-z1
Public IP: 10.129.115.200
Private Hostname mc3-n2vm1-z1-priv
Private IP: 192.168.10.68
Virtual Hostname mc3-n2vm1-z1-vip
Virtual IP: 10.129.115.201
Enter Cores [0 to max 12] (0): <Return>
Virtual Machine 2
CURRENT VM STATUS: active
Public Hostname mc3-n2vm1-z2
Public IP: 10.129.115.202
Private Hostname mc3-n2vm1-z2-priv
Private IP: 192.168.10.69
Virtual Hostname mc3-n2vm1-z2-vip
Virtual IP: 10.129.115.203
Enter Cores [0 to max 12] (0):
Virtual Machine 3
Enter Public Hostname (dbgp1-vm3-mc3-n2): mc3-n2vm1-z3
Enter Public IP (To be generated): <Return>
Enter Private Hostname (mc3-n2vm1-z3-priv): <Return>
Enter Private IP (To be generated): <Return>
Enter Virtual Hostname (mc3-n2vm1-z3-vip): <Return>
Enter Virtual IP (To be generated): <Return>
Enter Cores [0 to max 12] (0): <Return>
Cluster Information
SCAN name : dbgp1-scan
SCAN IPs :10.129.115.204,10.129.115.205,10.129.115.206
.
<some output omitted>
.
status: 0
message: Updating DB VM Group Profile succeeded
Getting DB VM Group Profile...
PROFILE INFORMATION
VMGroupName : dbgp1
SCAN_name : dbgp1-scan
SCAN_ip : 10.129.115.204,10.129.115.205,10.129.115.206
VM DEFINITIONS
VM 1
name : dbgp1-vm1-mc3-n1
globalName : mc3-n1
public_ip : 10.129.115.196
public_hostname : mc3-n1vm1-z1
virtual_ip : 10.129.115.197
virtual_hostname : mc3-n1vm1-z1-vip
VM 2
name : dbgp1-vm2-mc3-n1
globalName : mc3-n1
public_ip : 10.129.115.198
public_hostname : mc3-n1vm1-z2
virtual_ip : 10.129.115.199
virtual_hostname : mc3-n1vm1-z2-vip
VM 3
name : dbgp1-vm1-mc3-n2
globalName : mc3-n2
public_ip : 10.129.115.200
public_hostname : mc3-n2vm1-z1
virtual_ip : 10.129.115.201
virtual_hostname : mc3-n2vm1-z1-vip
VM 4
name : dbgp1-vm2-mc3-n2
globalName : mc3-n2
public_ip : 10.129.115.202
public_hostname : mc3-n2vm1-z2
virtual_ip : 10.129.115.203
virtual_hostname : mc3-n2vm1-z2-vip
VM 5
name : dbgp1-vm3-mc3-n1
globalName : mc3-n1
public_ip : 10.129.115.215
public_hostname : mc3-n1vm1-z3
virtual_ip : 10.129.115.216
virtual_hostname : mc3-n1vm1-z3-vip
VM 6
name : dbgp1-vm3-mc3-n2
globalName : mc3-n2
public_ip : 10.129.115.217
public_hostname : mc3-n2vm1-z3
virtual_ip : 10.129.115.218
virtual_hostname : mc3-n2vm1-z3-vip
Please insert the IP-mappings in the DNS Server if not already done.
Aug 24 17:17:29 mccn su: 'su root' succeeded for mcinstall on /dev/pts/2
Setting ssh timeout before exiting. Please wait..
mcinstall@mc3-n1:/var/home/mcinstall %
mcinstall@mc3-n1:/var/home/mcinstall %
mcinstall@mc3-n1:/var/home/mcinstall %
A l'invite, indiquez A pour Appliquer.
% mcmu tenant -P -u Setting ssh timeout before carrying out further operations. Please wait.. [INFO ] Log file path : /var/opt/oracle.minicluster/setup/logs/tenant_cli_082416_171912.log Listing DB VM Group Profile.. Status : Active EditStatus : edited Description : DB MVM Group 1 - NORMAL - SHARED - CIS deletable : True progress : False VMgroupName : dbgp1 editable : True VMgroupID : 1 Enter ID of the VM Group Profile that you want to edit[1] (1): <Return> Do you want to "[E]dit & Save" or "[A]pply previously saved changes"? Enter E/A (E): A . <some output omitted> . INFO:MCMU.controllers.dbzonegroupmanager:Zonegroup is updated with profile changes. status: 0 message: Updating DB VM Group succeeded. Getting DB VM Group Profile... . <some output omitted> .
Dans cet exemple, les machines virtuelles portant l'ID 23 (une sur chaque noeud) sont de nouvelles machines virtuelles de base de données avec un statut d'exécution en cours.
% mcmu status -Z -a [INFO ] Log file path : mc3-n1:/var/opt/oracle.minicluster/setup/logs/mcmu_082416_180834.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 23 dbgp1-vm3-mc3-n1 running /mcpool/dbgp1-vm3-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 23 dbgp1-vm3-mc3-n2 running /mcpool/dbgp1-vm3-mc3-n2zroot solaris excl - appzonetemplate installed /mcpool/appzonetemplate solaris excl - dbzonetemplate installed /mcpool/dbzonetemplate solaris excl
Si vous n'avez pas ajouté de machines virtuelles de base de données, cette étape ne s'applique pas.
Notez que les nouvelles machines virtuelles ne s'affichent pas dans la liste. Une fois les instances créées, vous pouvez comparer cette liste avec une nouvelle liste. Voir Step 7.
% mcmu tenant -I -l 1
Aug 24 18:10:01 mccn su: 'su root' succeeded for mcinstall on /dev/pts/2
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
Vous êtes invité à fournir les paramètres d'instance.
% mcmu tenant -I -c
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] : oltp
List of Character Set
[1] AL32UTF8 [2] AR8ADOS710 [3] AR8ADOS710T
.
<some output omitted>
.
[112] ZHT16HKSCS [113] ZHT16MSWIN950 [114] ZHT32EUC
[115] ZHT32SOPS [116] ZHT32TRIS [117] US7ASCII
Select Character Set Number (1): 115
List of National Character Set
[1] AL16UTF16 [2] UTF8
Select National Character Set Number (1): <Return>
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
status : Active
name : dbgp1-vm3-mc3-n1 <<=== NEW VM
globalName : mc3-n1
id : 13
memory : 522496
cores : 0
status : Active
name : dbgp1-vm3-mc3-n2 <<=== NEW VM
globalName : mc3-n2
id : 14
memory : 522496
cores : 0
Select Database VM ID [1/2/3/4/13/14] : 13 <<=== ID of New VM
List of All Active DB home in zone dbgp1-vm3-mc3-n1
Listing DB Home...
status : Active
VM_id : 13
version : 12.1.0.2
home : /u01/app/oracle/product/12.1.0/dbhome_12c
type : RAC
id : 9
status : Active
VM_id : 13
version : 11.2.0.4
home : /u01/app/oracle/product/11.2.0/dbhome_11g
type : RAC
id : 11
Select Database Home ID [9/11] : 9
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
status : Active
name : dbgp1-vm3-mc3-n2
globalName : mc3-n2
id : 14
memory : 522496
cores : 0
Select Secondary Database VM ID [3/4/14] : 14 <<=== ID of new VM on second node
Enter Container Database [True/False] (false):
Enter PGA (Program Global Area) in MB (2560): 5120
Enter SGA (System Global Area) in MB (6400): 12800
Enter Database Instance Name : ol12rac
List of Inputs for DB Instance Creation:
Database Instance Type: RAC
Database Instance Template: OLTP
VM: dbgp1-vm3-mc3-n1,dbgp1-vm3-mc3-n2 (ID: 13,14)
Database Home: /u01/app/oracle/product/12.1.0/dbhome_12c (ID: 9)
PGA (Program Global Area) in MB: 5120
SGA (System Global Area) in MB: 12800
Database Instance Name: ol12rac
Character Set: US7ASCII
National Character Set: AL16UTF16
Container Database : false
Do you want to change the inputs?
Enter Y/N (N): N
Creating DB Instance...
.
<some output omitted>
.
% mcmu tenant -I -l 1
Aug 24 18:43:12 mccn su: 'su root' succeeded for mcinstall on /dev/pts/2
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
ID: 19, NAME: ol12rac, VM_ID: 13, DBHOME_ID: 9, TYPE: RAC, STATUS: Active
ID: 20, NAME: ol12rac, VM_ID: 14, DBHOME_ID: 10, TYPE: RAC, STATUS: Active