Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
In this article we have examined many of CellCLI commands.
CellCLI — Cell Command Line Interpreter (Exadata)
1 2 3 | # cellcli # cellcli -e list cell # cellcli -x -n -e "list metrichistory where objectType='CELL'" |
Help Command:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 | CellCLI> help HELP [topic] Available Topics: ALTER ALTER ALERTHISTORY ALTER CELL ALTER CELLDISK ALTER GRIDDISK ALTER IORMPLAN ALTER LUN ALTER PHYSICALDISK ALTER QUARANTINE ALTER THRESHOLD ASSIGN KEY CALIBRATE CREATE CREATE CELL CREATE CELLDISK CREATE FLASHCACHE CREATE GRIDDISK CREATE KEY CREATE QUARANTINE CREATE THRESHOLD DESCRIBE DROP DROP ALERTHISTORY DROP CELL DROP CELLDISK DROP FLASHCACHE DROP GRIDDISK DROP QUARANTINE DROP THRESHOLD EXPORT CELLDISK IMPORT CELLDISK LIST LIST ACTIVEREQUEST LIST ALERTDEFINITION LIST ALERTHISTORY LIST CELL LIST CELLDISK LIST FLASHCACHE LIST FLASHCACHECONTENT LIST GRIDDISK LIST IORMPLAN LIST KEY LIST LUN LIST METRICCURRENT LIST METRICDEFINITION LIST METRICHISTORY LIST PHYSICALDISK LIST QUARANTINE LIST THRESHOLD SET SPOOL START CellCLI> help list CellCLI> help alter cell |
Commands for obtaining information:
1 2 3 4 5 6 7 8 9 10 | 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 |
List commands:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 | CellCLI> list cell CellCLI> list cell detail CellCLI> list cell attributes all CellCLI> list cell attributes rsStatus CellCLI> list physicaldisk CellCLI> list physicaldisk detail CellCLI> list physicaldisk 34:5 CellCLI> list physicaldisk 34:11 detail CellCLI> list physicaldisk attributes all CellCLI> list physicaldisk attributes name, id, slotnumber CellCLI> list physicaldisk attributes name, disktype, makemodel, physicalrpm, physicalport, status CellCLI> list physicaldisk attributes name,disktype,errCmdTimeoutCount,errHardReadCount,errHardWriteCount CellCLI> list physicaldisk where diskType='Flashdisk' CellCLI> list physicaldisk attributes name, id, slotnumber where disktype="flashdisk" and status != "not present" CellCLI> list physicaldisk attributes name, physicalInterface, physicalInsertTime where disktype = 'HardDisk' CellCLI> list physicaldisk where diskType=flashdisk and status='poor performance' detail CellCLI> list lun CellCLI> list lun detail CellCLI> list lun 0_8 detail CellCLI> list lun attributes all CellCLI> list lun attributes name, cellDisk, raidLevel, status CellCLI> list lun where disktype=flashdisk CellCLI> list celldisk CellCLI> list celldisk detail CellCLI> list celldisk FD_01_cell07 CellCLI> list celldisk FD_01_cell13 detail CellCLI> list celldisk attributes all CellCLI> list celldisk attributes name, devicePartition CellCLI> list celldisk attributes name, devicePartition where size>20G CellCLI> list celldisk attributes name,interleaving where disktype=harddisk CellCLI> list griddisk CellCLI> list griddisk DBFS_DG_CD_01_cell03 detail CellCLI> list griddisk attributes all CellCLI> list griddisk attributes name,cellDisk,diskType CellCLI> list griddisk attributes name, ASMDeactivationOutcome, ASMModeStatus --- describe command does not show these two attributes CellCLI> list griddisk attributes name,cellDisk,status where size=476.546875G CellCLI > list griddisk attributes name where asmdeactivationoutcome != 'Yes' CellCLI> list flashcache CellCLI> list flashcache detail CellCLI> list flashcache attributes all CellCLI> list flashcache attributes degradedCelldisks CellCLI> list flashcachecontent CellCLI> list flashcachecontent detail CellCLI> list flashcachecontent where objectnumber=161441 detail CellCLI> list flashcachecontent where dbUniqueName like 'EX.?.?' and hitcount > 100 attributes dbUniqueName, objectNumber, cachedKeepSize, cachedSize CellCLI> list flashcachecontent where dbUniqueName like 'EX.?.?' and objectNumber like '.*007' CellCLI> list flashcachecontent where dbUniqueName like '.*X.?.?' and objectNumber like '.*456' detail CellCLI> list metriccurrent CellCLI> list metriccurrent gd_io_rq_w_sm CellCLI> list metriccurrent n_nic_rcv_sec detail CellCLI> list metriccurrent attributes name,metricObjectName,metricType, metricValue,objectType where alertState != 'normal' CellCLI> list metriccurrent attributes name,metricObjectName,metricType, metricValue,alertState where objectType = 'HOST_INTERCONNECT' CellCLI> list metriccurrent attributes all where objectType = 'CELL' CellCLI> list metriccurrent attributes all where objectType = 'GRIDDISK' - > and metricObjectName = 'DATA_CD_09_cell01' and metricValue > 0 CellCLI> list metricdefinition CellCLI> list metricdefinition cl_cput detail CellCLI> list metricdefinition attributes all where objecttype='CELL' CellCLI> list metrichistory CellCLI> list metrichistory cl_cput CellCLI> list metrichistory where objectType = 'CELL' CellCLI> list metrichistory where objectType = 'CELL' and name = 'CL_TEMP' CellCLI> list metrichistory cl_cput where collectiontime > '*2011-10-15T22:56:04-04:00*' # cellcli -x -n -e "list metrichistory where objectType='CELL' and name='CL_TEMP'" CellCLI> list alertdefinition detail CellCLI> list alertdefinition attributes all where alertSource!='Metric' CellCLI> list alerthistory CellCLI> list alerthistory where notificationState like '[023]' and severity like '[warning|critical]' and examinedBy = NULL; CellCLI> list activerequest CellCLI> list iormplan CellCLI> list key CellCLI> list quarantine CellCLI> list threshold |
Create commands:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 | CellCLI> CREATE CELL [cellname] [realmname=realmvalue,] [interconnect1=ethvalue,] [interconnect2=ethvalue,][interconnect3=ethvalue,] [interconnect4=ethvalue,] ( ([ipaddress1=ipvalue,] [ipaddress2=ipvalue,] [ipaddress3=ipvalue,] [ipaddress4=ipvalue,]) | ([ipblock=ipblkvalue, cellnumber=numvalue]) ) CellCLI> create celldisk all harddisk CellCLI> create celldisk all CellCLI> create celldisk all harddisk interleaving='normal_redundancy' interleaving -- none(default), normal_redundancy or high_redundancy CellCLI> create celldisk all flashdisk CellCLI> create griddisk RECO_CD_11_cell01 celldisk=CD_11_cell01 CellCLI> create griddisk RECO_CD_11_cell01 celldisk=CD_11_cell01 size=100M CellCLI> create griddisk all prefix RECO CellCLI> create griddisk all flashdisk prefix FLASH CellCLI> create griddisk all harddisk prefix HARD CellCLI> create griddisk all harddisk prefix='data', size='270g' CellCLI> create griddisk all prefix='data', size='300g' CellCLI> create griddisk all prefix='redo', size='150g' CellCLI> create griddisk all harddisk prefix=systemdg CellCLI> create flashcache celldisk='FD_00_cell01' 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 key CellCLI> create quarantine CellCLI> create threshold cd_io_errs_min.prodb comparison=">", critical=10 CellCLI> create threshold CD_IO_ERRS_MIN warning=1, comparison='>=', occurrences=1, observation=1 |
Alter commands:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 | CellCLI> alter cell shutdown services rs CellCLI> alter cell shutdown services MS CellCLI> alter cell shutdown services CELLSRV CellCLI> alter cell shutdown services all 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 smtpfrom='Exadata Cell 07' CellCLI> alter cell emailFormat='text' CellCLI> alter cell emailFormat='html' CellCLI> alter cell validate snmp type=ASR CellCLI> alter cell snmpsubscriber=((host='snmp01.orac.com,type=ASR')) CellCLI> alter cell restart bmc 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 iormplan active CellCLI> alter quarantine CellCLI> alter threshold DB_IO_RQ_SM_SEC.PRODB comparison=">", critical=100 CellCLI> alter alerthistory Drop Commands: CellCLI> drop cell 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 |
Export:
1 | CellCLI> export celldisk |
Import:
1 | CellCLI> import celldisk |
Assign:
1 | CellCLI> assign key |
Calibration:
1 | CellCLI> calibrate |
Set commands:
1 2 3 4 5 | CellCLI> set dateformat local CellCLI> set dateformat standard CellCLI> set echo on CellCLI> set echo off |
To save the output to the file:
1 2 3 4 5 | CellCLI> spool myCellCLI.txt CellCLI> spool myCellCLI.txt append CellCLI> spool myCellCLI.txt replace CellCLI> spool off CellCLI> spool |
Script execution:
1 2 | CellCLI> @listdisks.cli CellCLI> start listdisks.cli |
Comments :
REM This is a comment
REMARK This is another comment
– This is another comment
Continue character:
1 2 | CellCLI> list metriccurrent attributes name,metricObjectName,metricValue, - objectType where alertState != 'normal' |
Quit:
1 2 | CellCLI> exit CellCLI> quit |
