Exadata Storage list of commands

      No Comments on Exadata Storage list of commands

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 [[email protected] 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='<[email protected]>’ Set the Email From Address CellCLI> ALTER CELL smtpFromAddr=’[email protected]
ALTER CELL smtpToAddr='<[email protected]>’ Send the alrets to this Email Address CellCLI> ALTER CELL smtpToAddr=’[email protected]
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

Leave a Reply

Your email address will not be published. Required fields are marked *