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 수가 노드당 2개의 VM에서 노드당 3개의 VM으로 증가됩니다. 새 VM은 VM5 및 VM6입니다. mcmu 명령은 새 VM에 대한 VM 매개변수를 묻습니다. Return 키를 누르면 괄호 안에 표시되는 기본값이 그대로 적용됩니다.


    주 -  이 명령이 완료되면 업데이트가 저장되지만 적용되지 않습니다.
    % 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. DNS에 새 공용 IP 주소 및 공용 호스트 이름을 입력합니다.
  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