Go to main content
Guía de administración de Oracle MiniCluster S7-2

Salir de la Vista de impresión

Actualización: Octubre de 2016
 
 

Creación de instancias de base de datos (CLI)

Cree al menos una instancia en cada máquina virtual de base de datos. Puede crear varias instancias de base de datos para cada directorio raíz de base de datos. El número total de instancias que puede crear está limitado por la cantidad de espacio en disco disponible.

  1. Escriba:
    % mcmu tenant -I -c
  2. Cuando se le solicite, introduzca la información solicitada.

    En este ejemplo, se selecciona una instancia de RAC, de modo que mcmu le solicita que seleccione una máquina virtual de cada nodo.

    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. Repita este procedimiento para crear una o más instancias de base de datos en cada máquina virtual de base de datos.
  4. Verifique la creación y el estado de las instancias.

    En este ejemplo, se muestran los detalles de todas las instancias de base datos del ID del directorio raíz especificado.

    % 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

    En este ejemplo, se muestran los detalles de todas las zonas.

    % 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