Exadata Storage Cell Commands Cheat Sheet

It is not an easy to remember the commands since most of the UNIX administrators are working on multiple Operating systems and different  OS flavors. Exadata and ZFS appliance are adding additional responsibility to Unix administrator and need to remember those appliance commands as well. This article will provide the reference to all Exadata storage cell commands with examples for some complex command options.

All the below mentioned commands will work only on cellcli prompt.

Listing the Exadata Storage cell Objects (LIST)

Command	Description	Examples
cellcli	To Manage the Exadata  cell Storage	[root@uaexacell1 init.d]# cellcli CellCLI: Release 11.2.3.2.1 – Production on Tue Nov 18 02:16:03 GMT+05:30 2014 Copyright (c) 2007, 2012, Oracle.  All rights reserved. Cell Efficiency Ratio: 1CellCLI>
LIST CELL	List the Cell Status	CellCLI> LIST CELL uaexacell1      online CellCLI>
LIST LUN	To list all the physical Drive & Flash drives
LIST PHYSICALDISK	To list all the physical Drive & Flash drives
LIST LUN where celldisk = <celldisk>	To list the LUN which is mapped to specific disk	CellCLI> LIST LUN where celldisk = FD_13_uaexacell1 FLASH13  FLASH13   normal
LIST CELL DETAIL	List the cell Status with all attributes	CellCLI> LIST CELL DETAIL name:                   uaexacell1 bbuTempThreshold:       60 bbuChargeThreshold:     800 bmcType:                absent
LIST CELL attributes  <attribute>	To list the specific cell attributes	CellCLI> LIST CELL attributes flashCacheMode WriteThrough
LIST CELLDISK	List all the cell Disks	CellCLI> LIST CELLDISK CD_DISK00_uaexacell1    normal CD_DISK01_uaexacell1    normal
LIST CELLDISK DETAIL	List all the cell Disks with Detailed information	CellCLI> LIST CELLDISK detail name:                   FD_13_uaexacell1 comment: creationTime:           2014-11-15T01:46:57+05:30 deviceName:             0_0 devicePartition:        0_0 diskType:               FlashDisk
LIST CELLDISK <CELLDISK> detail	TO list the Specific celldisk detail	CellCLI>  LIST CELLDISK FD_00_uaexacell1 detail name:                   FD_00_uaexacell1 comment: creationTime:           2014-11-15T01:46:56+05:30
LIST CELLDISK where disktype=harddisk	To list the celldisk which are created using harddisk	CellCLI> LIST CELLDISK where disktype=harddisk CD_DISK00_uaexacell1    normal CD_DISK01_uaexacell1    normal CD_DISK02_uaexacell1    normal
LIST CELLDISK where disktype=flashdisk	To list the celldisk which are created using Flashdisk	CellCLI> LIST CELLDISK where disktype=flashdisk FD_00_uaexacell1        normal FD_01_uaexacell1        normal FD_02_uaexacell1        normal
LIST CELLDISK where freespace > SIZE	To list the celldisks which has more than specificed size	CellCLI>  LIST CELLDISK where freespace > 50M FD_00_uaexacell1        normal FD_01_uaexacell1        normal
LIST FLASHCACHE	To list the configured FLASHCACHE
LIST FLASHCACHE DETAIL	To list the configured FLASHCACHE in detail
LIST FLASHLOG	To list the configured FLASHLOG
LIST FLASHLOG DETAIL	To list the configured FLASHLOG in detail
LIST FLASHCACHECONTENT	To list the Flashcache content
LIST GRIDDISK	To list the griddisks	CellCLI> LIST GRIDDISK DATA01_CD_DISK00_uaexacell1     active DATA01_CD_DISK01_uaexacell1     active
LIST GRIDDISK DETAIL	To list the griddisks in detail	CellCLI>  LIST GRIDDISK DETAIL name:                   DATA01_CD_DISK00_uaexacell1 availableTo: cachingPolicy:          default cellDisk:               CD_DISK00_uaexacell1
LIST GRIDDISK <GRIDDISK_NAME>	To list the specific Griddisk	CellCLI> LIST GRIDDISK DATA01_CD_DISK00_uaexacell1 DATA01_CD_DISK00_uaexacell1     active
LIST GRIDDISK <GRIDDISK_NAME> detail	To list the specific Griddisk in detail	CellCLI>  LIST GRIDDISK DATA01_CD_DISK00_uaexacell1 detail name:                   DATA01_CD_DISK00_uaexacell1 availableTo: cachingPolicy:          default cellDisk:               CD_DISK00_uaexacell1
LIST GRIDDISK where size > SIZE	To list the griddisk which size is higher than specified value	CellCLI> LIST GRIDDISK where size > 750M DATA01_CD_DISK00_uaexacell1     active
LIST IBPORT	To list the inifiniband Port
LIST IORMPLAN	To list the IORMPLAN	CellCLI> LIST IORMPLAN uaexacell1_IORMPLAN     active
LIST IORMPLAN DETAIL	To list the IORMPLAN  in DETAIL	CellCLI> LIST IORMPLAN DETAIL name:                   uaexacell1_IORMPLAN catPlan: dbPlan: objective:              basic status:                 active
LIST METRICCURRENT	To get the I/O’s second for all the objects	CellCLI>  LIST METRICCURRENT CD_BY_FC_DIRTY                  CD_DISK00_uaexacell1                            0.000 MB CD_BY_FC_DIRTY                  CD_DISK01_uaexacell1                            0.000 MB CD_BY_FC_DIRTY                  CD_DISK02_uaexacell1                            0.000 MB CD_BY_FC_DIRTY                  CD_DISK03_uaexacell1                            0.000 MB
LIST METRICCURRENT cl_cput, cl_runq detail	To list the RUNQ	CellCLI> list metriccurrent cl_cput, cl_runq detail name:                   CL_CPUT alertState:             normal collectionTime:         2014-11-18T02:42:26+05:30 metricObjectName:       uaexacell1 metricType:             Instantaneous metricValue:            4.7 % objectType:             CELLname:                   CL_RUNQ alertState:             normal collectionTime:         2014-11-18T02:42:26+05:30 metricObjectName:       uaexacell1 metricType:             Instantaneous metricValue:            12.2 objectType:             CELL
LIST QUARANTINE	To list the QUARANTINE disk
LIST QUARANTINE detail	To list the QUARANTINE disk in detail
LIST THRESHOLD	To list the thersold limits
LIST THRESHOLD DETAIL	To list the thersold limits in detail
LIST ACTIVEREQUEST	To list the active Requests
LIST ALERTHISTORY	To list the alerts

CREATING the Exadata Storage cell Objects (CREATE)

The below commands will be used most commonly on exadata storage to create the virtual objects.

CREATE CELL  <CELL_NAME> interconnect1=<ethx>	Configures the cell network	CellCLI> CREATE CELL uaexacell1  interconnect1=eth1 Cell uaexacell1 successfully created Starting CELLSRV services… The STARTUP of CELLSRV services was successful. Flash cell disks, FlashCache, and FlashLog will be created.
CREATE CELLDISK <CELLDISK_NAME>  <LUN>	Creates cell disk(s) according to attributes provided.	CREATE CELLDISK UADBG1  LUN=00_00
CREATE CELLDISK ALL HARDISK	Creates cell disk(s) on all the harddisks	CellCLI> CREATE CELLDISK ALL HARDDISK CellDisk CD_DISK00_uaexacell1 successfully created CellDisk CD_DISK01_uaexacell1 successfully created CellDisk CD_DISK02_uaexacell1 successfully created
CREATE CELLDISK ALL	Creates cell disk(s) on all the harddisks & flashdisks	CellCLI> CREATE CELLDISK ALL CellDisk CD_DISK00_uaexacell1 successfully created
CREATE CELLDISK ALL FLASHDISK	Creates cell disk(s) on all the  flashdisks	CellCLI> CREATE CELLDISK ALL FLASHDISK CellDisk FD_00_uaexacell1 successfully created
CREATE FLASHCACHE celldisk=”Flash_celldisk1″	Creates flash cache for IO requests on specific flashdisk	CellCLI> CREATE FLASHCACHE celldisk=”FD_00_uaexacell1,FD_01_uaexacell1″, size=500M
CREATE FLASHCACHE  ALL size = <size>	Creates flash cache for IO requests on all devices with specific size	CREATE FLASHCACHE  ALL size = 10G
CREATE FLASHLOG  celldisk=”Flash_celldisk1″	Creates flash log for logging requests on specified flashdisk	CellCLI> CREATE FLASHLOG celldisk=”FD_00_uaexacell1,FD_01_uaexacell1″, size=500M
CREATE FLASHLOG  ALL size = <size>	Creates flash log for logging requests on all devices with specific size	CREATE FLASHLOG  ALL size = 252M
CREATE GRIDDISK  <GRIDDISK_NAME> CELLDISK=<celldisk>	Creates grid disk on specific disk	CellCLI> CREATE GRIDDISK UADBDK1 CELLDISK=CD_DISK00_uaexacell1 GridDisk UADBDK1 successfully created CellCLI>
CREATE GRIDDISK  <GRIDDISK_NAME> CELLDISK=<celldisk>, size=<size>	Creates grid disk  on specific disk with specific size	CellCLI> CREATE GRIDDISK UADBDK2 CELLDISK=CD_DISK02_uaexacell1, SIZE=100M GridDisk UADBDK2 successfully created CellCLI>
CREATE GRIDDISK ALL  HARDDISK PREFIX=<Disk_Name>, size=<size>	Create Grid disks on all the harddisk with specific size.	CellCLI> CREATE GRIDDISK ALL  HARDDISK PREFIX=UADBPROD, size=100M Cell disks were skipped because they had no freespace for grid disks: CD_DISK00_uaexacell1. GridDisk UADBPROD_CD_DISK01_uaexacell1 successfully created GridDisk UADBPROD_CD_DISK02_uaexacell1 successfully created GridDisk UADBPROD_CD_DISK03_uaexacell1 successfully created GridDisk UADBPROD_CD_DISK04_uaexacell1 successfully created GridDisk UADBPROD_CD_DISK05_uaexacell1 successfully created GridDisk UADBPROD_CD_DISK06_uaexacell1 successfully created GridDisk UADBPROD_CD_DISK07_uaexacell1 successfully created GridDisk UADBPROD_CD_DISK08_uaexacell1 successfully created GridDisk UADBPROD_CD_DISK09_uaexacell1 successfully created GridDisk UADBPROD_CD_DISK10_uaexacell1 successfully created
CREATE GRIDDISK ALL  FLASHDISK PREFIX=<Disk_Name>, size=<size>	Create Grid disks on all the flashdisk with specific size.	CellCLI> CREATE GRIDDISK ALL FLASHDISK PREFIX=UAFLSHDB, size=100M GridDisk UAFLSHDB_FD_00_uaexacell1 successfully created GridDisk UAFLSHDB_FD_01_uaexacell1 successfully created GridDisk UAFLSHDB_FD_02_uaexacell1 successfully created GridDisk UAFLSHDB_FD_03_uaexacell1 successfully created GridDisk UAFLSHDB_FD_04_uaexacell1 successfully created GridDisk UAFLSHDB_FD_05_uaexacell1 successfully created GridDisk UAFLSHDB_FD_06_uaexacell1 successfully created GridDisk UAFLSHDB_FD_07_uaexacell1 successfully created GridDisk UAFLSHDB_FD_08_uaexacell1 successfully created GridDisk UAFLSHDB_FD_09_uaexacell1 successfully created GridDisk UAFLSHDB_FD_10_uaexacell1 successfully created
CREATE KEY	Creates and displays random key for use in assigning client keys.	CellCLI> CREATE KEY 1820ef8f9c2bafcd12e15ebfe267abad CellCLI>
CREATE QUARANTINE quarantineType=<“SQLID” or “DISK REGION” or \ “SQL PLAN” or “CELL OFFLOAD”> attributename=value	Define the attributes for a new quarantine entity	CellCLI> CREATE QUARANTINE quarantineType=”SQLID”, sqlid=”5xnjp4cutc1s8″ Quarantine successfully created. CellCLI>
CREATE THRESHOLD <Thersold1>   attributename=value	Defines conditions for generation of a metric alert.	CellCLI> CREATE THRESHOLD db_io_rq_sm_sec.db123  comparison=’>’, critical=120 Threshold db_io_rq_sm_sec.db123 successfully created CellCLI>

DELETING the Exadata Storage cell Objects (DROP)

The below mentioned cellcli commands will help you to remove the various objects on the exadata storage cell. Be carefully with “force” option since it can remove the object even though it is in use.

DROP ALERTHISTORY <ALER1>, <ALERT2>	Removes the specific alert from the cell’s alert history.	CellCLI> DROP ALERTHISTORY 2 Alert 2 successfully dropped CellCLI>
DROP ALERTHISTORY ALL	Removes all alert from the cell’s alert history.	CellCLI> DROP ALERTHISTORY ALL Alert 1_1 successfully dropped Alert 1_2 successfully dropped Alert 1_3 successfully dropped Alert 1_4 successfully dropped Alert 1_5 successfully dropped Alert 1_6 successfully dropped
DROP THRESHOLD <THERSOLD>	Removes specific threshold from the cell	CellCLI> DROP THRESHOLD db_io_rq_sm_sec.db123 Threshold db_io_rq_sm_sec.db123 successfully dropped CellCLI>
DROP THRESHOLD ALL	Removes all  threshold from the cell	CellCLI> DROP THRESHOLD ALL
DROP QUARANTINE <quarantine1>	Removes quarantine from the cell	CellCLI> DROP QUARANTINE QADB1
DROP QUARANTINE ALL	Removes all the quarantine from the cell	CellCLI> DROP QUARANTINE ALL
DROP GRIDDISK <Griddisk_Name>	Removes the specific grid disk from the cell	CellCLI> DROP GRIDDISK UADBDK1 GridDisk UADBDK1 successfully dropped CellCLI>
DROP GRIDDISK ALL PREFIX=<GRIDDISK_STARTNAME>	Removes the set of grid disks from the cell by using the prefix	CellCLI> DROP GRIDDISK ALL PREFIX=UAFLSHDB GridDisk UAFLSHDB_FD_00_uaexacell1 successfully dropped GridDisk UAFLSHDB_FD_01_uaexacell1 successfully dropped GridDisk UAFLSHDB_FD_02_uaexacell1 successfully dropped GridDisk UAFLSHDB_FD_03_uaexacell1 successfully dropped GridDisk UAFLSHDB_FD_04_uaexacell1 successfully dropped GridDisk UAFLSHDB_FD_05_uaexacell1 successfully dropped
DROP GRIDDISK  <GRIDDISK> ERASE=1pass	Removes the specific  grid disks from the cell and Performs secure data deletion on the grid disk	CellCLI> DROP GRIDDISK  UADBPROD_CD_DISK10_uaexacell1 ERASE=1pass GridDisk UADBPROD_CD_DISK10_uaexacell1 successfully dropped CellCLI>
DROP GRIDDISK  <GRIDDISK> FORCE	Drops grid disk even if it is currently active.	CellCLI> DROP GRIDDISK  UADBPROD_CD_DISK08_uaexacell1 FORCE GridDisk UADBPROD_CD_DISK08_uaexacell1 successfully dropped
DROP GRIDDISK ALL HARDDISK	Drops griddisks which are created on top of hardisk	DROP GRIDDISK ALL HARDDISK

Modifying  the Exadata Storage cell Objects (ALTER)

The below mentioned commands will help you to modify the cell attributes and various objects setting. ALTER command will be used to perform the start/stop/restart the MS/RS/CELLSRV services as well.

ALTER ALERTHISTORY 123 examinedby=<user_name>	Sets the examinedby attribute of alerts	ALTER ALERTHISTORY 123 examinedby=lingesh
ALTER CELL RESTART SERVICES ALL	All(RS+CELLSRV+MS) services are restarted	CellCLI>ALTER CELL RESTART SERVICES ALL
ALTER CELL RESTART SERVICES < RS | MS | CELLSRV >	To restart specific services	CellCLI>ALTER CELL RESTART SERVICES RS
		CellCLI>ALTER CELL RESTART SERVICES MS
		CellCLI>ALTER CELL RESTART SERVICES CELLSRV
ALTER CELL SHUTDOWN SERVICES ALL	All(RS+CELLSRV+MS) services will be halted	CellCLI>ALTER CELL SHUTDOWN SERVICES
ALTER CELL SHUTDOWN SERVICES < RS | MS | CELLSRV >	To shutdown specfic service	CellCLI>ALTER CELL SHUTDOWN SERVICES RS
		CellCLI>ALTER CELL SHUTDOWN SERVICES MS
		CellCLI>ALTER CELL SHUTDOWN SERVICES CELLSRV
ALTER CELL STARTUP SERVICES ALL	All(RS+CELLSRV+MS) services will be started	CellCLI>ALTER CELL STARTUP SERVICES
ALTER CELL STARTUP SERVICES < RS | MS | CELLSRV >	To start specific Service	CellCLI>ALTER CELL STARTUP SERVICES RS
		CellCLI>ALTER CELL STARTUP SERVICES MS
		CellCLI>ALTER CELL STARTUP SERVICES CELLSRV
ALTER CELL NAME=<Name>	To Set the Name/Re-name to the Exadata Storage Cell	CellCLI> ALTER CELL NAME=UAEXACELL1
		Cell UAEXACELL1 successfully altered
		CellCLI>
ALTER CELL flashCacheMode=WriteBack	To Modify the flashcache mode to writeback from writethrough. To perform this,You need to drop the flashcache & Stop the cellsrv .Then you need to create the new Flashcache	CellCLI> DROP flashcache
		Flash cache UAEXACELL1_FLASHCACHE successfully dropped
		CellCLI>
		CellCLI> ALTER CELL SHUTDOWN SERVICES CELLSRV
		Stopping CELLSRV services…
		The SHUTDOWN of CELLSRV services was successful.
		CellCLI>
		CellCLI>  ALTER CELL flashCacheMode=WriteBack
		Cell UAEXACELL1 successfully altered
		CellCLI>
		CellCLI> CREATE FLASHCACHE celldisk=”FD_00_uaexacell1,FD_01_uaexacell1″, size=500M
ALTER CELL interconnect1=<Network_Interface>	To set the network interface for cell stroage.	CellCLI> ALTER CELL INTERCONNECT1=eth1
		A restart of all services is required to put new network configuration into effect. MS-CELLSRV communication may be hampered until restart.Cell UAEXACELL1 successfully altered
ALTER CELL LED OFF	The chassis LED is turned   off.	CellCLI> ALTER CELL LED OFF
ALTER CELL LED ON	The chassis LED is turned   on.	CellCLI> ALTER CELL LED ON
ALTER CELL smtpServer='<SMTP_SERVER>’	Set the SMTP server	CellCLI> ALTER CELL smtpServer=’myrelay.unixarena.com’
ALTER CELL smtpFromAddr='<myaddress@mydomain.com>’	Set the Email From Address	CellCLI> ALTER CELL smtpFromAddr=’uacell@unixarena.com’
ALTER CELL smtpToAddr='<myemail@mydomain.com>’	Send the alrets to this Email  Address	CellCLI> ALTER CELL smtpToAddr=’lingeshwaran.rangasamy@gmail.com’
ALTER CELL smtpFrom='<myhostname>’	Alias host name for email	CellCLI> ALTER CELL smtpFrom=’uaexacell1′
ALTER CELL smtpPort=’25’	Set the SMTP port	CellCLI> ALTER CELL smtpPort=’25’
ALTER CELL smtpUseSSL=’TRUE’	Make the smtp to use SLL	CellCLI> ALTER CELL smtpUseSSL=’TRUE’
ALTER CELL notificationPolicy=’critical,warning,clear’	Send the alrets for critical,warning and clear	CellCLI> ALTER CELL notificationPolicy=’critical,warning,clear’
ALTER CELL notificationMethod=’mail’	Set the notification method as email	CellCLI> ALTER CELL notificationMethod=’mail’
ALTER CELLDISK <existing_celldisk_name> name='<new_cell_name>’,	Modify’s the celldisk name	CellCLI> ALTER CELLDISK CD_DISK00_uaexacell1 name=’UACELLD’, comment=’Re-named for UnixArena’
comment='<comments>’		CellDisk UACELLD successfully altered
ALTER CELLDISK ALL HARDDISK FLUSH	Dirty blocks for all harddisk will be flushed	CellCLI> ALTER CELLDISK ALL HARDDISK FLUSH
ALTER CELLDISK ALL HARDDISK FLUSH NOWAIT	Allows alter command to complete while flush operation continues on all harddisks	CellCLI> ALTER CELLDISK ALL HARDDISK FLUSH NOWAIT
		Flash cache flush is in progress
		CellCLI>
ALTER CELLDISK ALL HARDDISK CANCEL FLUSH	Previous flush operation on all harddisk will be terminated	CellCLI> ALTER CELLDISK ALL HARDDISK CANCEL FLUSH
		CellDisk CD_DISK02_uaexacell1 successfully altered
		CellDisk CD_DISK03_uaexacell1 successfully altered
		CellDisk CD_DISK04_uaexacell1 successfully altered
		CellDisk CD_DISK05_uaexacell1 successfully altered
ALTER CELLDISK <CELLDISK> FLUSH	Dirty blocks for specific  celldisk will be flushed	CellCLI> ALTER CELLDISK  CD_DISK02_uaexacell1
ALTER CELLDISK  <CELLDISK> FLUSH  NOWAIT	Allows alter command to complete while flush operation continues on specific celldisk	CellCLI> ALTER CELLDISK  CD_DISK02_uaexacell1 FLUSH NOWAIT
		Flash cache flush is in progress
ALTER FLASHCACHE ALL size=<size>	Resize the all Flash celldisks to specified size	ALTER FLASHCACHE ALL size=100G
ALTER FLASHCACHE ALL	All the flashsdisks will be assigned to Flashcache	CellCLI> ALTER FLASHCACHE ALL
		Flash cache uaexacell1_FLASHCACHE altered successfully
ALTER FLASHCACHE CELLDISK='<Flashcelldisk1>,<Flashcelldisk2>’	The specified Flashcell disks be assigned to Flashcache &	CellCLI>  ALTER FLASHCACHE CELLDISK=’FD_09_uaexacell1,FD_04_uaexacell1′
	other flashdisks will be removed	Flash cache uaexacell1_FLASHCACHE altered successfully
ALTER FLASHCACHE ALL FLUSH	Dirty blocks for all Flashdisks will be flushed	CellCLI> ALTER FLASHCACHE ALL
ALTER FLASHCACHE ALL  CANCEL FLUSH	Previous flush operation on all Flashdisk will be terminated	CellCLI> ALTER FLASHCACHE ALL CANCEL FLUSH
		Flash cache uaexacell1_FLASHCACHE altered successfully
ALTER FLASHCACHE ALL FLUSH NOWAIT	Allows alter command to complete while flush operation	CellCLI> ALTER FLASHCACHE ALL FLUSH NOWAIT
	continues on all the flash celldisk	Flash cache flush is in progress
ALTER FLASHCACHE CELLDISK=<FLASH-CELLDISK> FLUSH	Dirty blocks for specific  flash celldisk will be flushed	CellCLI> ALTER FLASHCACHE CELLDISK=FD_04_uaexacell1 FLUSH
		Flash cache uaexacell1_FLASHCACHE altered successfully
ALTER FLASHCACHE CELLDISK=<FLASH-CELLDISK> CANCEL FLUSH	Previous flush operation on specific flash celldisk will be terminated	CellCLI> ALTER FLASHCACHE CELLDISK=FD_04_uaexacell1 CANCEL FLUSH
		Flash cache uaexacell1_FLASHCACHE altered successfully

[box type=”warning” ]Do not modify the Exadata Storage cell configuration without notifying oracle support.[/box]Hope this Quick Reference will help you to administrate the Exadata storage cell.