Showing posts with label Oracle Exadata X4 certification. Show all posts
Showing posts with label Oracle Exadata X4 certification. Show all posts

Cellcli - Alter

CellCLI> alter cell shutdown services rs --> To shutdown the Restart Server service 
CellCLI> alter cell shutdown services MS --> To shutdown the Management Server service 
CellCLI> alter cell shutdown services CELLSRV --> To shutdown the Cell Services 
CellCLI> alter cell shutdown services all -->To shutdown the RS, CELLSRV and MS services 
CellCLI> alter cell restart services rs 
CellCLI> alter cell restart services all 
CellCLI> alter cell led on
CellCLI> alter cell led off 
CellCLI> alter cell validate mail
CellCLI> alter cell validate configuration 
CellCLI> alter cell smtpfromaddr='cell07@orac.com' 
CellCLI> alter cell smtpfrom='Exadata Cell 07' 
CellCLI> alter cell smtptoaddr='satya@orac.com' 
CellCLI> alter cell emailFormat='text' 
CellCLI> alter cell emailFormat='html' 
CellCLI> alter cell validate snmp type=ASR - Automatic Service Requests (ASRs) 
CellCLI> alter cell snmpsubscriber=((host='snmp01.orac.com,type=ASR')) 
CellCLI> alter cell restart bmc - BMC, Baseboard Management Controller, controls the compoments of the cell. 
CellCLI> alter cell configure bmc 
CellCLI> alter physicaldisk 34:2,34:3 serviceled on
CellCLI> alter physicaldisk 34:6,34:9 serviceled off 
CellCLI> alter physicaldisk harddisk serviceled on 
CellCLI> alter physicaldisk all serviceled on 
CellCLI> alter lun 0_10 reenable 
CellCLI> alter lun 0_04 reenable force 
CellCLI> alter celldisk FD_01_cell07 comment='Flash Disk' 
CellCLI> alter celldisk all harddisk comment='Hard Disk' 
CellCLI> alter celldisk all flashdisk comment='Flash Disk' 
CellCLI> alter griddisk RECO_CD_10_cell06 comment='Used for Reco'
CellCLI> alter griddisk all inactive 
CellCLI> alter griddisk RECO_CD_11_cell12 inactive 
CellCLI> alter griddisk RECO_CD_08_cell01 inactive force 
CellCLI> alter griddisk RECO_CD_11_cell01 inactive nowait 
CellCLI> alter griddisk DATA_CD_00_CELL01,DATA_CD_02_CELL01,...DATA_CD_11_CELL01 inactive 
CellCLI> alter griddisk all active 
CellCLI> alter griddisk RECO_CD_11_cell01 active 
CellCLI> alter griddisk all harddisk comment='Hard Disk' 
CellCLI> alter ibport ibp2 reset counters
CellCLI> alter iormplan active 
CellCLI> alter quarantine 
CellCLI> alter threshold DB_IO_RQ_SM_SEC.PRODB comparison=">", critical=100 
CellCLI> alter alerthistory

Cellcli - Drop

CellCLI> drop cell --->> To reset the cell to its factory settings, removes the cell related properties of the server; it does not actually remove the physical server. 

CellCLI> drop cell force 
CellCLI> drop celldisk CD_01_cell05 
CellCLI> drop celldisk CD_00_cell09 force 
CellCLI> drop celldisk harddisk 
CellCLI> drop celldisk flashdisk 
CellCLI> drop celldisk all
CellCLI> drop celldisk all flashdisk force 
CellCLI> drop griddisk DBFS_DG_CD_02_cel14 
CellCLI> drop griddisk RECO_CD_11_cell01 force 
CellCLI> drop griddisk prefix=DBFS 
CellCLI> drop griddisk flashdisk 
CellCLI> drop griddisk harddisk 
CellCLI> drop griddisk all 
CellCLI> drop griddisk all prefix=temp_dg 
CellCLI> drop flashcache 
CellCLI> drop quarantine 
CellCLI> drop threshold DB_IO_RQ_SM_SEC.PRODB 
CellCLI> drop alerthistory

Exadata X-2 Sizing


Quarter Rack

1. 2 x Database Servers, each with: 

Includes:

- 2 x Six-Core Intel® Xeon® X5675 (3.06 GHz)
- 96 GB Memory (expandable to144GB)
- Disk Controller HBA with 512MB Battery Backed Write Cache
- 4 x 300 GB 10,000 RPM SAS Disks
- 2 x QDR (40Gb/s) Ports
- 2 x 10 Gb Ethernet Ports based on the Intel 82599 10GbE Controller
- 4 x 1 Gb Ethernet Ports
- 1 x ILOM Ethernet Port
- 2 x Redundant Hot-Swappable Power Supplies 


2. 3 x Exadata Storage Servers X2-2 with 12 x 600 GB 15,000 RPM High Performance SAS disks or 12 x 3 TB 7,200 RPM High Capacity SAS disks

Includes:

- 36 CPU cores for SQL processing
- 1.1 TB Exadata Smart Flash Cache
- 2 x 36 port QDR (40 Gb/sec) InfiniBand Switches 




3. 2 x 36 port QDR (40 Gb/sec) InfiniBand Switches


Half Rack

1. 4 x Database Servers

Includes:

- 2 x Six-Core Intel® Xeon® X5675 Processors (3.06 GHz)
- 96 GB Memory (expandable to 144GB)
- Disk Controller HBA with 512MB Battery Backed Write Cache
- 4 x 300 GB 10,000 RPM SAS Disks
- 2 x QDR (40Gb/s) Ports
- 2 x 10 Gb Ethernet Ports based on the Intel 82599 10GbE Controller
- 4 x 1 Gb Ethernet Ports
- 1 x ILOM Ethernet Port
- 2 x Redundant Hot-Swappable Power Supplies

2. 3 x 36 port QDR (40 Gb/sec) InfiniBand Switches

3. 7 x Exadata Storage Servers X2-2 with12 x 600 GB 15,000 RPM High Performance SAS disks or 12 x 3 TB 7,200 RPM High Capacity SAS disks

Includes:

- 84 CPU cores for SQL processing
- 2.6 TB Exadata Smart Flash Cache


Full Rack 

1. 8 x Database Servers

Includes:

- 2 x Six-Core Intel® Xeon® X5675 Processors (3.06 GHz)
- 96 GB Memory (expandable to 144GB)
- Disk Controller HBA with 512MB Battery Backed Write Cache
- 4 x 300 GB 10,000 RPM SAS Disks
- 2 x QDR (40Gb/s) Ports
- 2 x 10 Gb Ethernet Ports based on the Intel 82599 10GbE Controller
- 4 x 1 Gb Ethernet Ports
- 1 x ILOM Ethernet Port
- 2 x Redundant Hot-Swappable Power Supplies

2. 3 x 36 port QDR (40 Gb/sec) InfiniBand Switches

3. 14 x Exadata Storage Servers X2-2 with 12 x 600 GB 15,000 RPM High Performance SAS disks or 12 x 3 TB 7,200 RPM High Capacity SAS disks

Includes:

- 168 CPU cores for SQL processing
- 5.3 TB Exadata Smart Flash Cache 


Additional Hardware :

All the rack will includes:

- Ethernet switch for administration of the Database Machine
- Keyboard, Video or Visual Display Unit, Mouse (KVM) hardware for local administration
- 2 x Redundant Power Distributions Units (PDUs)
- 42U rack packaging