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

退出打印视图

更新时间: 2016 年 10 月
 
 

创建 DB 实例 (CLI)

在每个 DB VM 中创建至少一个实例。可为每个 DB 主目录创建多个 DB 实例。可创建的实例总数受可用磁盘空间量的限制。

  1. 键入以下命令:
    % mcmu tenant -I -c
  2. 出现提示时,输入请求的信息。

    在以下示例中,选择了一个 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>
    .
  3. 重复此过程以在每个 DB VM 上创建一个或多个 DB 实例。
  4. 验证实例的创建和状态。

    以下示例列出了指定的主目录 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