Go to main content

Oracle® MiniCluster S7-2 Administration Guide

Exit Print View

Updated: October 2021
 
 

Create DB Instances (CLI)

Create at least one instance in each DB VM. You can create multiple DB instances for each DB Home. The total number of instances you can create is limited by the amount of disk space available.

  1. Create a DB instance.
    % mcmu tenant -I -c
  2. When prompted, enter the requested information.

    In this example, a RAC instance is selected, so mcmu prompts you to select one VM from each node.

    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..
    .
    <output omitted>
    .
  3. Repeat this procedure to create one or more DB instances on each DB VM.
  4. Verify the creation and status of instances.

    This example lists the details of all DB instances in the specified home ID.

    % 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

    This example lists the details about all the zones.

    % 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