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 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@testexacell1 init.d]# cellcli CellCLI: Release 12.1.2.2.1 – Production on Tue Nov 18 12:00:03 UTC 2016 Copyright (c) 2007, 2016, Oracle. All rights reserved. Cell Efficiency Ratio: 1CellCLI> |
| LIST CELL | List the Cell Status | CellCLI> LIST CELL testexacell1 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_testexacell1 FLASH13 FLASH13 normal |
| LIST CELL DETAIL | List the cell Status with all attributes | CellCLI> LIST CELL DETAIL name: testexacell1 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_testexacell1 normal CD_DISK01_testexacell1 normal |
| LIST CELLDISK DETAIL | List all the cell Disks with Detailed information | CellCLI> LIST CELLDISK detail name: FD_13_testexacell1 comment: creationTime: 2016-11-15T10:46:57 deviceName: 0_0 devicePartition: 0_0 diskType: FlashDisk |
| LIST CELLDISK <CELLDISK> detail | TO list the Specific celldisk detail | CellCLI> LIST CELLDISK FD_00_testexacell1 detail name: FD_00_testexacell1 comment: creationTime: 2016-11-15T10:46:57 |
| LIST CELLDISK where disktype=harddisk | To list the celldisk which are created using harddisk | CellCLI> LIST CELLDISK where disktype=harddisk CD_DISK00_testexacell1 normal CD_DISK01_testexacell1 normal CD_DISK02_testexacell1 normal |
| LIST CELLDISK where disktype=flashdisk | To list the celldisk which are created using Flashdisk | CellCLI> LIST CELLDISK where disktype=flashdisk FD_00_testexacell1 normal FD_01_testexacell1 normal FD_02_testexacell1 normal |
| LIST CELLDISK where freespace > SIZE | To list the celldisks which has more than specificed size | CellCLI> LIST CELLDISK where freespace > 50M FD_00_testexacell1 normal FD_01_testexacell1 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_testexacell1 active DATA01_CD_DISK01_testexacell1 active |
| LIST GRIDDISK DETAIL | To list the griddisks in detail | CellCLI> LIST GRIDDISK DETAIL name: DATA01_CD_DISK00_testexacell1 availableTo: cachingPolicy: default cellDisk: CD_DISK00_testexacell1 |
| LIST GRIDDISK <GRIDDISK_NAME> | To list the specific Griddisk | CellCLI> LIST GRIDDISK DATA01_CD_DISK00_testexacell1 DATA01_CD_DISK00_testexacell1 active |
| LIST GRIDDISK <GRIDDISK_NAME> detail | To list the specific Griddisk in detail | CellCLI> LIST GRIDDISK DATA01_CD_DISK00_testexacell1 detail name: DATA01_CD_DISK00_testexacell1 availableTo: cachingPolicy: default cellDisk: CD_DISK00_testexacell1 |
| 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_testexacell1 active |
| LIST IBPORT | To list the inifiniband Port | |
| LIST IORMPLAN | To list the IORMPLAN | CellCLI> LIST IORMPLAN testexacell1_IORMPLAN active |
| LIST IORMPLAN DETAIL | To list the IORMPLAN in DETAIL | CellCLI> LIST IORMPLAN DETAIL name: testexacell1_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_testexacell1 0.000 MB CD_BY_FC_DIRTY CD_DISK01_testexacell1 0.000 MB CD_BY_FC_DIRTY CD_DISK02_testexacell1 0.000 MB CD_BY_FC_DIRTY CD_DISK03_testexacell1 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: 2016-11-18T11:42:26 metricObjectName: testexacell1 metricType: Instantaneous metricValue: 4.7 % objectType: CELLname: CL_RUNQ alertState: normal collectionTime: 2016-11-18T11:42:26 metricObjectName: testexacell1 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 testexacell1 interconnect1=eth1 Cell testexacell1 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 TESTDBG1 LUN=00_00 |
| CREATE CELLDISK ALL HARDISK | Creates cell disk(s) on all the harddisks | CellCLI> CREATE CELLDISK ALL HARDDISK CellDisk CD_DISK00_testexacell1 successfully created CellDisk CD_DISK01_testexacell1 successfully created CellDisk CD_DISK02_testexacell1 successfully created |
| CREATE CELLDISK ALL | Creates cell disk(s) on all the harddisks & flashdisks | CellCLI> CREATE CELLDISK ALL CellDisk CD_DISK00_testexacell1 successfully created |
| CREATE CELLDISK ALL FLASHDISK | Creates cell disk(s) on all the flashdisks | CellCLI> CREATE CELLDISK ALL FLASHDISK CellDisk FD_00_testexacell1 successfully created |
| CREATE FLASHCACHE celldisk=”Flash_celldisk1″ | Creates flash cache for IO requests on specific flashdisk | CellCLI> CREATE FLASHCACHE celldisk=”FD_00_testexacell1,FD_01_testexacell1″, 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_testexacell1,FD_01_testexacell1″, 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 TESTDBDK1 CELLDISK=CD_DISK00_testexacell1 GridDisk TESTDBDK1 successfully created CellCLI> |
| CREATE GRIDDISK <GRIDDISK_NAME> CELLDISK=<celldisk>, size=<size> | Creates grid disk on specific disk with specific size | CellCLI> CREATE GRIDDISK TESTDBDK2 CELLDISK=CD_DISK02_testexacell1, SIZE=100M GridDisk TESTDBDK2 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=TESTDBPROD, size=100M Cell disks were skipped because they had no freespace for grid disks: CD_DISK00_testexacell1. GridDisk TESTDBPROD_CD_DISK01_testexacell1 successfully created GridDisk TESTDBPROD_CD_DISK02_testexacell1 successfully created GridDisk TESTDBPROD_CD_DISK03_testexacell1 successfully created GridDisk TESTDBPROD_CD_DISK04_testexacell1 successfully created GridDisk TESTDBPROD_CD_DISK05_testexacell1 successfully created GridDisk TESTDBPROD_CD_DISK06_testexacell1 successfully created GridDisk TESTDBPROD_CD_DISK07_testexacell1 successfully created GridDisk TESTDBPROD_CD_DISK08_testexacell1 successfully created GridDisk TESTDBPROD_CD_DISK09_testexacell1 successfully created GridDisk TESTDBPROD_CD_DISK10_testexacell1 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=TESTFLSHDB, size=100M GridDisk TESTFLSHDB_FD_00_testexacell1 successfully created GridDisk TESTFLSHDB_FD_01_testexacell1 successfully created GridDisk TESTFLSHDB_FD_02_testexacell1 successfully created GridDisk TESTFLSHDB_FD_03_testexacell1 successfully created GridDisk TESTFLSHDB_FD_04_testexacell1 successfully created GridDisk TESTFLSHDB_FD_05_testexacell1 successfully created GridDisk TESTFLSHDB_FD_06_testexacell1 successfully created GridDisk TESTFLSHDB_FD_07_testexacell1 successfully created GridDisk TESTFLSHDB_FD_08_testexacell1 successfully created GridDisk TESTFLSHDB_FD_09_testexacell1 successfully created GridDisk TESTFLSHDB_FD_10_testexacell1 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 TESTDBDK1 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=TESTFLSHDB GridDisk TESTFLSHDB_FD_00_testexacell1 successfully dropped GridDisk TESTFLSHDB_FD_01_testexacell1 successfully dropped GridDisk TESTFLSHDB_FD_02_testexacell1 successfully dropped GridDisk TESTFLSHDB_FD_03_testexacell1 successfully dropped GridDisk TESTFLSHDB_FD_04_testexacell1 successfully dropped GridDisk TESTFLSHDB_FD_05_testexacell1 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 TESTDBPROD_CD_DISK10_testexacell1 ERASE=1pass GridDisk TESTDBPROD_CD_DISK10_testexacell1 successfully dropped CellCLI> |
| DROP GRIDDISK <GRIDDISK> FORCE | Drops grid disk even if it is currently active. | CellCLI> DROP GRIDDISK TESTDBPROD_CD_DISK08_testexacell1 FORCE GridDisk TESTDBPROD_CD_DISK08_testexacell1 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=nicola |
| 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=testexacell1 |
| Cell testexacell1 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 testexacell1_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 testexacell1 successfully altered | ||
| CellCLI> | ||
| CellCLI> CREATE FLASHCACHE celldisk=”FD_00_testexacell1,FD_01_testexacell1″, 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 testexacell1 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.test.com’ |
| ALTER CELL smtpFromAddr='<myaddress@mydomain.com>’ | Set the Email From Address | CellCLI> ALTER CELL smtpFromAddr=’testexacell@test.com’ |
| ALTER CELL smtpToAddr='<myemail@mydomain.com>’ | Send the alrets to this Email Address | CellCLI> ALTER CELL smtpToAddr=’test.mytest@gmail.com’ |
| ALTER CELL smtpFrom='<myhostname>’ | Alias host name for email | CellCLI> ALTER CELL smtpFrom=’testexacell1′ |
| 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_testexacell1 name=’TESTCELLD’, comment=’Re-named for my test’ |
| comment='<comments>’ | CellDisk TESTCELLD 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_testexacell1 successfully altered | ||
| CellDisk CD_DISK03_testexacell1 successfully altered | ||
| CellDisk CD_DISK04_testexacell1 successfully altered | ||
| CellDisk CD_DISK05_testexacell1 successfully altered | ||
| ALTER CELLDISK <CELLDISK> FLUSH | Dirty blocks for specific celldisk will be flushed | CellCLI> ALTER CELLDISK CD_DISK02_testexacell1 |
| ALTER CELLDISK <CELLDISK> FLUSH NOWAIT | Allows alter command to complete while flush operation continues on specific celldisk | CellCLI> ALTER CELLDISK CD_DISK02_testexacell1 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 testexacell1_FLASHCACHE altered successfully | ||
| ALTER FLASHCACHE CELLDISK='<Flashcelldisk1>,<Flashcelldisk2>’ |
The specified Flashcell disks be assigned to Flashcache & | CellCLI> ALTER FLASHCACHE CELLDISK=’FD_09_testexacell1,FD_04_testexacell1′ |
| other flashdisks will be removed | Flash cache testexacell1_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 testexacell1_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_testexacell1 FLUSH |
| Flash cache testexacell1_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_testexacell1 CANCEL FLUSH |
| Flash cache testexacell1_FLASHCACHE altered successfully |