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

- 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