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> 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
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:
- 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