Showing posts with label Oracle Exadata Machine X4. Show all posts
Showing posts with label Oracle Exadata Machine X4. 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 - Describe
It Will display all attributes
CellCLI> describe
cell
CellCLI> describe
physicaldisk
CellCLI> describe
lun
CellCLI> describe
celldisk
CellCLI> describe
griddisk
CellCLI> describe
flashcache
CellCLI> describe
flashcachecontent
CellCLI> describe
metriccurrent
CellCLI> describe
metricdefinition
CellCLI> describe
metrichistory
Exadata X2-3 Sizing
Eighth Rack
2 x Database Servers
Includes:
- 2 x Eight-Core
Intel® Xeon® E5-2690 Processors (2.9 GHz)
- 256GB Memory
- Disk Controller HBA with 512MB Battery
Backed Write Cache
- 4 x 300 GB 10,000 RPM Disks
- 2 x QDR (40Gb/s) Ports
- 4 x 1/10 Gb Ethernet Ports (copper)
- 2 x 10 Gb Ethernet Ports (optical)
- 1 x ILOM Ethernet Port
- 2 x Redundant
Hot-Swappable Power Supplies
- 16 CPU cores and
512 GB memory for database processing (8 CPU cores per Database Server are
enabled with 256 GB memory per Database
Server)
3 x Exadata Storage
Servers X3-2
Includes:
- 36 CPU
cores for SQL processing (18 cores enabled)
- 12 PCI
flash cards (6 cards enabled) with 2.4 TB Exadata Smart Flash Cache
- 18 x 600
GB 15,000 RPM High Performance disks or 18 x 3 TB 7,200 RPM High Capacity disks
(6 disks per storage Server enabled)
2 x 36 port QDR (40
Gb/sec) InfiniBand Switches
Quarter Rack
2 x Database Servers
Includes:
- 2 x Eight-Core
Intel® Xeon® E5-2690 Processors (2.9 GHz)
- 256GB Memory
- Disk Controller HBA with 512MB Battery
Backed Write Cache
- 4 x 300 GB 10,000 RPM Disks
- 2 x QDR (40Gb/s) Ports
- 4 x 1/10 Gb Ethernet Ports (copper)
- 2 x 10 Gb Ethernet Ports (optical)
- 1 x ILOM Ethernet Port
- 2 x Redundant
Hot-Swappable Power Supplies
- 32 CPU cores and 512 GB memory for database processing
(16 CPU cores and 256 GB memory per Database Server)
3 x Exadata Storage Servers X3-2
Includes:
- 36 CPU cores for
SQL processing
- 12
PCI flash cards with 4.8 TB Exadata Smart Flash Cache
- 36 x 600 GB 15,000
RPM High Performance disks or 36 x 3 TB 7,200 RPM High Capacity disks
2 x 36 port QDR (40 Gb/sec) InfiniBand Switches
Half Rack
4 x Database Servers
Includes:
- 2 x Eight-Core
Intel® Xeon® E5-2690 Processors (2.9 GHz)
- 256GB Memory
- Disk Controller HBA with 512MB Battery
Backed Write Cache
- 4 x 300 GB 10,000 RPM Disks
- 2 x QDR (40Gb/s) Ports
- 4 x 1/10 Gb Ethernet Ports (copper)
- 2 x 10 Gb Ethernet Ports (optical)
- 1 x ILOM Ethernet Port
- 2 x Redundant
Hot-Swappable Power Supplies
- 64
CPU cores and 1 TB memory for database processing (16 CPU cores and 256 GB
memory per Database Server)
7 x Exadata Storage Servers X3-2
Includes:
- 84 CPU cores for
SQL processing
- 28
PCI flash cards with 11.2 TB Exadata Smart Flash Cache
- 84 x 600 GB 15,000
RPM High Performance disks or 36 x 3 TB 7,200 RPM High Capacity disks
3 x 36 port QDR (40 Gb/sec) InfiniBand Switches
Full Rack
8 x Database Servers
Includes:
- 2 x Eight-Core
Intel® Xeon® E5-2690 Processors (2.9 GHz)
- 256GB Memory
- Disk Controller HBA with 512MB Battery
Backed Write Cache
- 4 x 300 GB 10,000 RPM Disks
- 2 x QDR (40Gb/s) Ports
- 4 x 1/10 Gb Ethernet Ports (copper)
- 2 x 10 Gb Ethernet Ports (optical)
- 1 x ILOM Ethernet Port
- 2 x Redundant
Hot-Swappable Power Supplies
- 128
CPU cores and 2 TB memory for database processing (16 CPU cores and 256 GB
memory per Database Server)
14 x Exadata Storage Servers X3-2
Includes:
- 168 CPU cores for
SQL processing
- 55 PCI flash cards with 22.4 TB Exadata Smart
Flash Cache
- 168 x 600 GB 15,000
RPM High Performance disks or 36 x 3 TB 7,200 RPM High Capacity disks
3 x 36 port QDR (40 Gb/sec) InfiniBand Switches
Additional Hardware for all the rack
Includes:
- Ethernet switch
for administration of the Database Machine
- 2 x Redundant
Power Distributions Units (PDUs)
- 42U
rack packaging
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