Exadata
http://www.oracle.com/technetwork/articles/linux/part1-091089.html
http://www.oracle.com/technetwork/articles/oem/exadata-commands-intro-402431.html
http://arup.blogspot.com/p/collection-of-some-of-my-very-popular.html
CellCLI Commands :
CellCLI> list cell detail
CellCLI> list cell
CellCLI> list celldisk --- lun --- physicaldisk
--- griddisk (pasrt of D.G : DATA_DMORL ,DBFS_DG ,RECO_DMORL) :CellCLI> list griddisk
CellCLI> list alerthistory [ .... detail ] -- check where severity critical
CellCLI> list alerthistory where severity like '[warning|critical]'
/opt/oracle/cell/log/diag/asm/cell/{node name}/trace/alert.log cd $CELLTRACE
CellCLI> list cell detail
CellCLI> alter cell restart services rs
CellCLI> alter cell restart services ms
CellCLI> alter cell restart services cellsrv
CellCLI> alter cell restart services all
http://www.dbas-oracle.com/2013/05/7-Important-CellCLI-Commands-for-Exadata-DBA.html
Parameter : COMPATIBLE , COMPATIBLE.ASM , AU Size , DIRVERSION(11.2.0.2.0)
CELL.SMART_SCAN_CAPABLE=TRUE
IDP.TYPE = dynamic -- to place data close to periphery of disk
Quarter Rack. : 2 compute servers and 3 storage servers,
Eighth Rack
Exadata X8-8 : eight-socket compute servers ; 192 compute cores ; 2 compute servers and 3 storage servers
DB M/C : Two models (X2 to X8 )-2 and (X2 to X8)- 8 i.e two socket or 8 socket compute servers
Full rack : 8 DB Nodes , 14 cell/storage cells
Half rack :
Quarter rack :
Node/compute Node : It's Database Nodes
Cell : Storage cell ; each have 12 physical disks each of 600GB(high performance configuration) or 2TB(high capacity configuration)
and 384GB of flash disk
Infiniband : 3 infiniband switches for redundancy/throughput
Managing Cells
CellCLI> help create cell --usually done via the automatic installation script.
CREATE CELL <cellname> realmname=<realmvalue>
interconnect=<ethvalue>
ipaddress1=<ipvalue>
ipblock=<ipblkvalue>, cellnumber=<numvalue>
CellCLI> describe cell
CellCLI> list cell
CellCLI> list cell detail
CellCLI> list cell attributes all
Managing Cells Services :
CellCLI> alter cell shutdown services rs
CellCLI> alter cell shutdown services all --
CellCLI> alter cell restart services rs
CellCLI> alter cell restart services all
CellCLI> list cell attributes rsStatus
CellCLI> alter cell led on
CellCLI> alter cell led off
Mail setup from Cell :
CellCLI> alter cell smtpfromaddr='cell07@abcd.com' and name CellCLI> alter cell smtpfrom='Exadata Cell 07'
CellCLI> alter cell smtptoaddr='xyz@abcd.com'
CellCLI> alter cell emailFormat='text'
CellCLI> alter cell validate mail
Baseboard Management Controller ;
CellCLI> alter cell configurebmc --to check BMC can sends the alerts to the cell so that they show up as alerts
CellCLI> alter cell restart bmc --The BMC should be running all the time.
CellCLI> alter cell validate snmp type=ASR -- validate SNMP for ASR
CellCLI> alter cell snmpsubscriber=((host='snmp01.proligence.com,type=ASR')) --define a subscriber to generate ASR by SNMP
CellCLI> alter cell validate configuration -- to validate the firmware of the cell at any time
CellCLI> drop cell -- drop griddisk first or use CellCLI> drop cell force
Managing CellDisks
Only celldisk name and comment can be changed
CellCLI> describe celldisk
CellCLI> list celldisk
CellCLI> list celldisk detail
CellCLI> list celldisk attributes all -- in a tabular format
CellCLI> list celldisk attributes name, devicePartition
CellCLI> list celldisk attributes name, devicePartition where size>23G
CellCLI> alter celldisk all harddisk comment=’Hard Disk’
CellCLI> alter celldisk all flashdisk comment='Flash Disk'
CellCLI> alter celldisk FD_00_cell01 comment='Flash Disk'
Managing Grid Disks
Only name, comment, Available To, status and size are modifiable
CellCLI> describe griddisk
CellCLI> list griddisk
CellCLI> list griddisk detail
CellCLI> list griddisk DBFS_DG_CD_02_cell01 detail
CellCLI> list griddisk attributes all -- in a tabular format
CellCLI> list griddisk attributes name,cellDisk,diskType
CellCLI> list griddisk attributes name,cellDisk,status where size=476.546875G
CellCLI> list griddisk attributes name, ASMDeactivationOutcome, ASMModeStatus -- 'Yes' means this grid disk can deactivate/offline without data loss , ONLINE indicates grid disk is being used
CellCLI> alter griddisk PRORECO_CD_11_cell01 comment='Used for Reco';
CellCLI> alter griddisk all harddisk comment='Hard Disk';
CellCLI> alter griddisk PRORECO_CD_11_cell01 inactive/active [force] [nowait]
CellCLI> drop griddisk all
CellCLI> drop griddisk prefix=DBFS
CellCLI> drop griddisk DBFS_DG_CD_02_prolcel14 [force] -- If the disk is active, it won’t be droppe. use force
CellCLI> drop griddisk flashdisk | harddisk
CellCLI> create griddisk PRORECO_CD_11_cell01 celldisk=CD_11_cell01 -- to create a grid disk from a specific cell disk
CellCLI>create griddisk all prefix PRORECO
CellCLI>create griddisk all flashdisk prefix FLASH
CellCLI>create griddisk PRORECO_CD_11_cell01 celldisk=CD_11_cell01 size=100M
Managing Flash Disks
Each cell has only one flash cache . flash disks are presented to the cells as cell disks
CellCLI> describe flashcache
CellCLI> list flashcache
CellCLI> list flashcache detail
CellCLI> list flashcache attributes all -- in a tabular format
CellCLI> list flashcache attributes degradedCelldisks
CellCLI> list celldisk FD_00_cell01 detail
CellCLI> create flashcache celldisk='FD_13_cell01,FD_00_cell01,FD_10_cell01,FD_02_cell01,FD_06_cell01,FD_12_cell01,FD_05_cell01,FD_08_cell01,FD_15_cell01,FD_14_cell01,FD_07_cell01,
FD_04_cell01,FD_03_cell01,FD_11_cell01,FD_09_cell01,FD_01_cell01'
CellCLI> create flashcache all
CellCLI> create flashcache all size=365.25G
CellCLI> create flashcache celldisk='FD_00_cell01'
CellCLI> drop flashcache -- in case you want to use flash disks as storage and not as flash cache.
CellCLI> describe flashcachecontent
CellCLI> list flashcachecontent
CellCLI> list flashcachecontent where objectnumber=211409 detail
Group Commands – DCLI
http://www.oracle.com/technetwork/articles/linux/part1-091089.html
http://www.oracle.com/technetwork/articles/oem/exadata-commands-intro-402431.html
http://arup.blogspot.com/p/collection-of-some-of-my-very-popular.html
CellCLI Commands :
CellCLI> list cell detail
CellCLI> list cell
CellCLI> list celldisk --- lun --- physicaldisk
--- griddisk (pasrt of D.G : DATA_DMORL ,DBFS_DG ,RECO_DMORL) :CellCLI> list griddisk
CellCLI> list alerthistory [ .... detail ] -- check where severity critical
CellCLI> list alerthistory where severity like '[warning|critical]'
/opt/oracle/cell/log/diag/asm/cell/{node name}/trace/alert.log cd $CELLTRACE
CellCLI> list cell detail
CellCLI> alter cell restart services rs
CellCLI> alter cell restart services ms
CellCLI> alter cell restart services cellsrv
CellCLI> alter cell restart services all
http://www.dbas-oracle.com/2013/05/7-Important-CellCLI-Commands-for-Exadata-DBA.html
Parameter : COMPATIBLE , COMPATIBLE.ASM , AU Size , DIRVERSION(11.2.0.2.0)
CELL.SMART_SCAN_CAPABLE=TRUE
IDP.TYPE = dynamic -- to place data close to periphery of disk
Quarter Rack. : 2 compute servers and 3 storage servers,
Eighth Rack
Exadata X8-8 : eight-socket compute servers ; 192 compute cores ; 2 compute servers and 3 storage servers
DB M/C : Two models (X2 to X8 )-2 and (X2 to X8)- 8 i.e two socket or 8 socket compute servers
Full rack : 8 DB Nodes , 14 cell/storage cells
Half rack :
Quarter rack :
Node/compute Node : It's Database Nodes
Cell : Storage cell ; each have 12 physical disks each of 600GB(high performance configuration) or 2TB(high capacity configuration)
and 384GB of flash disk
Infiniband : 3 infiniband switches for redundancy/throughput
Managing Cells
CellCLI> help create cell --usually done via the automatic installation script.
CREATE CELL <cellname> realmname=<realmvalue>
interconnect=<ethvalue>
ipaddress1=<ipvalue>
ipblock=<ipblkvalue>, cellnumber=<numvalue>
CellCLI> describe cell
CellCLI> list cell
CellCLI> list cell detail
CellCLI> list cell attributes all
Managing Cells Services :
CellCLI> alter cell shutdown services rs
CellCLI> alter cell shutdown services all --
CellCLI> alter cell restart services rs
CellCLI> alter cell restart services all
CellCLI> list cell attributes rsStatus
CellCLI> alter cell led on
CellCLI> alter cell led off
Mail setup from Cell :
CellCLI> alter cell smtpfromaddr='cell07@abcd.com' and name CellCLI> alter cell smtpfrom='Exadata Cell 07'
CellCLI> alter cell smtptoaddr='xyz@abcd.com'
CellCLI> alter cell emailFormat='text'
CellCLI> alter cell validate mail
Baseboard Management Controller ;
CellCLI> alter cell configurebmc --to check BMC can sends the alerts to the cell so that they show up as alerts
CellCLI> alter cell restart bmc --The BMC should be running all the time.
CellCLI> alter cell validate snmp type=ASR -- validate SNMP for ASR
CellCLI> alter cell snmpsubscriber=((host='snmp01.proligence.com,type=ASR')) --define a subscriber to generate ASR by SNMP
CellCLI> alter cell validate configuration -- to validate the firmware of the cell at any time
CellCLI> drop cell -- drop griddisk first or use CellCLI> drop cell force
Managing CellDisks
Only celldisk name and comment can be changed
CellCLI> describe celldisk
CellCLI> list celldisk
CellCLI> list celldisk detail
CellCLI> list celldisk attributes all -- in a tabular format
CellCLI> list celldisk attributes name, devicePartition
CellCLI> list celldisk attributes name, devicePartition where size>23G
CellCLI> alter celldisk all harddisk comment=’Hard Disk’
CellCLI> alter celldisk all flashdisk comment='Flash Disk'
CellCLI> alter celldisk FD_00_cell01 comment='Flash Disk'
Managing Grid Disks
Only name, comment, Available To, status and size are modifiable
CellCLI> describe griddisk
CellCLI> list griddisk
CellCLI> list griddisk detail
CellCLI> list griddisk DBFS_DG_CD_02_cell01 detail
CellCLI> list griddisk attributes all -- in a tabular format
CellCLI> list griddisk attributes name,cellDisk,diskType
CellCLI> list griddisk attributes name,cellDisk,status where size=476.546875G
CellCLI> list griddisk attributes name, ASMDeactivationOutcome, ASMModeStatus -- 'Yes' means this grid disk can deactivate/offline without data loss , ONLINE indicates grid disk is being used
CellCLI> alter griddisk PRORECO_CD_11_cell01 comment='Used for Reco';
CellCLI> alter griddisk all harddisk comment='Hard Disk';
CellCLI> alter griddisk PRORECO_CD_11_cell01 inactive/active [force] [nowait]
CellCLI> drop griddisk all
CellCLI> drop griddisk prefix=DBFS
CellCLI> drop griddisk DBFS_DG_CD_02_prolcel14 [force] -- If the disk is active, it won’t be droppe. use force
CellCLI> drop griddisk flashdisk | harddisk
CellCLI> create griddisk PRORECO_CD_11_cell01 celldisk=CD_11_cell01 -- to create a grid disk from a specific cell disk
CellCLI>create griddisk all prefix PRORECO
CellCLI>create griddisk all flashdisk prefix FLASH
CellCLI>create griddisk PRORECO_CD_11_cell01 celldisk=CD_11_cell01 size=100M
Managing Flash Disks
Each cell has only one flash cache . flash disks are presented to the cells as cell disks
CellCLI> describe flashcache
CellCLI> list flashcache
CellCLI> list flashcache detail
CellCLI> list flashcache attributes all -- in a tabular format
CellCLI> list flashcache attributes degradedCelldisks
CellCLI> list celldisk FD_00_cell01 detail
CellCLI> create flashcache celldisk='FD_13_cell01,FD_00_cell01,FD_10_cell01,FD_02_cell01,FD_06_cell01,FD_12_cell01,FD_05_cell01,FD_08_cell01,FD_15_cell01,FD_14_cell01,FD_07_cell01,
FD_04_cell01,FD_03_cell01,FD_11_cell01,FD_09_cell01,FD_01_cell01'
CellCLI> create flashcache all
CellCLI> create flashcache all size=365.25G
CellCLI> create flashcache celldisk='FD_00_cell01'
CellCLI> drop flashcache -- in case you want to use flash disks as storage and not as flash cache.
CellCLI> describe flashcachecontent
CellCLI> list flashcachecontent
CellCLI> list flashcachecontent where objectnumber=211409 detail
Group Commands – DCLI