Use este procedimiento para realizar alguno de estos cambios en un grupo de máquinas virtuales de base de datos:
Aumentar el número de máquinas virtuales en el grupo.
Aumentar o disminuir el número de núcleos en las máquinas virtuales.
Consulte Inicio de sesión en la CLI de MCMU.
En este ejemplo, el número de máquinas virtuales en los nodos 1 y 2 se aumenta de dos máquinas virtuales por nodo a tres máquinas virtuales por nodo. Las máquinas virtuales nuevas son VM5 y VM6. El comando mcmu le solicita los parámetros de máquina virtual para las nuevas máquinas virtuales. Si presiona Intro, se acepta el valor por defecto, que se muestra entre paréntesis.
% 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 %
Cuando se le solicite que edite, guarde o aplique un cambio, especifique A.
% 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> .
En este ejemplo, las máquinas virtuales con el ID 23 (uno en cada nodo) son nuevas máquinas virtuales de base de datos que se muestran con el estado de ejecución.
% 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 no agregó máquinas virtuales de bases de datos, este paso no se aplica.
Observe que las nuevas máquinas virtuales no se muestran en la lista. Una vez que se han creado las nuevas instancias, puede comparar esta lista con una lista nueva. Consulte 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
Se le solicitará que proporcione los parámetros de las instancias.
% 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