Go to main content
Oracle MiniCluster S7-2 管理指南

退出打印视图

更新时间: 2016 年 10 月
 
 

更新 DB VM 组 (CLI)

可以使用此过程对 DB VM 组执行以下更改之一:

  • 增加组中的 VM 数。

  • 增加或减少 VM 中的核心数。

  1. 以主管理员(例如 mcinstall)身份登录到 MCMU CLI。

    请参见登录到 MCMU CLI

  2. 运行配置文件更新命令以应用 VM 更新。

    在以下示例中,节点 1 和 2 上的 VM 数从每个节点两个 VM 增加至每个节点三个 VM。新的 VM 是 VM5 和 VM6。mcmu 命令会提示您提供新的 VM 的 VM 参数。按回车键可接受默认值,默认值显示在括号中。


    注 -  此命令完成后,更新已保存,但未应用。
    % 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 % 
    
  3. 将新的公共 IP 地址和公共主机名输入到 DNS 中。
  4. 再次运行该命令以应用更改。

    当提示您选择要进行编辑还是保存或应用时,指定 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>
    .
  5. 验证更改。

    在以下示例中,ID 为 23 的 VM(每个节点各一个)是新的 DB VM,其状态显示为 running。

    % 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  
  6. 在新的 DB VM 上创建 DB 实例:

    如果未添加 DB VM,则此步骤不适用。

    1. 列出当前实例。

      请注意,新的 VM 不会显示在列表中。创建新实例之后,您可以将该列表与新列表相比较。请参见 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
    2. 创建实例。

      系统会提示您提供实例参数。

      % 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>
      .
      
  7. 列出 DB 实例以验证新的 DB VM 实例的存在情况和状态。
    % 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