cellcli commands in Oracle Exadata

cellcli commands in Oracle Exadata

CellCLI  — Cell Command Line Interface/Interpreter (in Oracle Exadata)

CellCLI manages Exadata Storage Servers (Cells). The scope of the CellCLI command is the cell where it is run, not in other cells. To invoke the CellCLI, login to the Exadata cell as cellmonitor, celladmin, or root, and type “cellcli”.

# cellcli

# cellcli -e list cell
# cellcli -x -n -e “list metrichistory where objectType=’CELL'”
# cellcli <mycellci.commands >mycellci.output

Help

CellCLI> help HELP [topic]

    Available Topics:
        ALTER
        ALTER ALERTHISTORY
        ALTER CELL
        ALTER CELLDISK
        ALTER GRIDDISK         ALTER IBPORT
        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 IBPORT         LIST IORMPLAN
        LIST KEY
        LIST LUN
        LIST METRICCURRENT
        LIST METRICDEFINITION
        LIST METRICHISTORY
        LIST PHYSICALDISK         LIST QUARANTINE
        LIST THRESHOLD
        SET
        SPOOL
        START
CellCLI> help list ibport
CellCLI> help alter cell
Describe       — Will display all attributes
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
CellCLI> help list

Enter HELP LIST <object_type> for specific help syntax.
    <object_type>:  {ACTIVEREQUEST | ALERTDEFINITION | ALERTHISTORY | CELL | CELLDISK | FLASHCACHE | FLASHCACHECONTENT | GRIDDISK | IBPORT | IORMPLAN | KEY | LUN | METRICCURRENT | METRICDEFINITION | METRICHISTORY | PHYSICALDISK | QUARANTINE | THRESHOLD }

CellCLI> list cell   – Will display Oracle Exadata Storage Servers/Cells information

CellCLI> list cell detail
CellCLI> list cell attributes all
CellCLI> list cell attributes rsStatus
CellCLI> list physicaldisk           - Will display physical disks information
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             - Will display LUNs information
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        - Will display cell disks information
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      – Will display grid disks information
CellCLI> list griddisk detail CellCLI> list griddisk DG_01_cell03 detail
CellCLI> list griddisk attributes all
CellCLI> list griddisk attributes name, size 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     – Will display flash cache information
CellCLI> list flashcache detail
CellCLI> list flashcache attributes all
CellCLI> list flashcache attributes degradedCelldisks
CellCLI> help list FLASHCACHECONTENT
  Usage: LIST FLASHCACHECONTENT [<filters>] [<attribute_list>] [DETAIL]
  Purpose: Displays specified attributes for flash cache entries.
  Arguments:
   <filters>: An expression which determines the entries to be displayed.
   <attribute_list>: The attributes that are to be displayed. ATTRIBUTES {ALL | attr1 [, attr2]… }
   [DETAIL]: Formats the display as an attribute on each line, with an attribute descriptor preceding each value.

CellCLI> list flashcachecontent        – Will display flash cache content information 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    - Will display metrics information
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        – Will display metric’s definitions
CellCLI> list metricdefinition cl_cput detail
CellCLI> list metricdefinition attributes all where objecttype=’CELL’
CellCLI> list metrichistory           – Will display metric’s history 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'” — -x to suppress the banner, and the -n to suppress the command line
CellCLI> list alertdefinition detail    - Will display alert's definitions
CellCLI> list alertdefinition attributes all where alertSource!='Metric' CellCLI> list alerthistory        - Will display alert's history CellCLI> list alerthistory detail CellCLI> list alerthistory where notificationState like '[023]' and severity like '[warning|critical]' and examinedBy = NULL; CellCLI> list activerequest
CellCLI> list ibport       - Will display InfiniBand configuration details CellCLI> list ibport detail
CellCLI> list iormplan       - Will display IORM plan details
CellCLI> list key CellCLI> list quarantine
CellCLI> list threshold      - Will display threshold details
Create
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]) )  — To configure the Oracle Exadata cell network and starts services.
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
CellCLI> alter cell shutdown services rs - To shutdown the Restart Server service
CellCLI> alter cell shutdown services MS – To shutdown the Management Server service
CellCLI> alter cell shutdown services CELLSRV – To shutdown the Cell Services
CellCLI> alter cell shutdown services all -To shutdown the RS, CELLSRV and MS services
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 smtpfromaddr=’cell07@orac.com’
CellCLI> alter cell smtpfrom=’Exadata Cell 07′
CellCLI> alter cell smtptoaddr=’satya@orac.com’
CellCLI> alter cell emailFormat=’text’
CellCLI> alter cell emailFormat='html'
CellCLI> alter cell validate snmp type=ASR - Automatic Service Requests (ASRs)
CellCLI> alter cell snmpsubscriber=((host=’snmp01.orac.com,type=ASR’))
CellCLI> alter cell restart bmc  – BMC, Baseboard Management Controller, controls the compoments of the cell.
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 ibport ibp2 reset counters CellCLI> alter iormplan active
CellCLI> alter quarantine

CellCLI> alter threshold DB_IO_RQ_SM_SEC.PRODB comparison=">", critical=100
CellCLI> alter alerthistory
Drop
CellCLI> drop cell — To reset the cell to its factory settings, removes the cell related properties of the server; it does not actually remove the physical server.
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
CellCLI> export celldisk
Import
CellCLI> import celldisk
Assign
CellCLI> assign key
Calibrate
CellCLI> calibrate CellCLI> calibrate force
Set
CellCLI> help set
  Usage: SET <variable> <value>
  Purpose: Sets a variable to alter the CELLCLI environment settings for your current session.
  Arguments: variable and value represent one of the following clauses:
    DATEFORMAT { STANDARD | LOCAL }
    ECHO { ON | OFF }

CellCLI> set dateformat local CellCLI> set dateformat standard

CellCLI> set echo on
CellCLI> set echo off
Spool
CellCLI> spool myCellCLI.txt
CellCLI> spool myCellCLI.txt append
CellCLI> spool myCellCLI.txt replace
CellCLI> spool off
CellCLI> spool     --- Will give spool file name
Scripts execution
CellCLI> @listdisks.cli
CellCLI> start listdisks.cli
Comments
REM This is a comment
REMARK This is another comment
— This is yet another comment
Continuation Character
CellCLI> list metriccurrent attributes name,metricObjectName,metricValue, -
objectType where alertState != ‘normal’   — continuation character for queries spanned in multiple lines
Exit/Quit
CellCLI> exit
CellCLI> quit

Sobre Alexandre Pires

ORACLE OCS Goldengate Specialist, OCE RAC 10g R2, OCP 12C, 11g, 10g , 9i e 8i - Mais de 25 anos de experiência na área de TI. Participei de projetos na G&P alocado na TOK STOK, EDINFOR alocado na TV CIDADE "NET", 3CON Alocado no PÃO DE AÇUCAR, DISCOVER alocado na VIVO, BANCO IBI e TIVIT, SPC BRASIL, UOLDIVEO alocado no CARREFOUR e atualmente na ORACLE ACS atendendo os seguintes projetos: VIVO, CLARO, TIM, CIELO, CAIXA SEGUROS, MAPFRE, PORTO SEGURO, SULAMERICA, BRADESCO SEGUROS, BANCO BRADESCO, BASA, SANTANDER, CNJ, TSE, ELETROPAULO, EDP, SKY, NATURA, ODEBRESHT, NISSEI, SICREDI, CELEPAR, TAM, TIVIT, IBM, SMILES, CELEPAR, SERPRO,OKI,BANCO PAN, etc
Esse post foi publicado em EXADATA e marcado , . Guardar link permanente.

Deixe uma resposta

Preencha os seus dados abaixo ou clique em um ícone para log in:

Logotipo do WordPress.com

Você está comentando utilizando sua conta WordPress.com. Sair / Alterar )

Imagem do Twitter

Você está comentando utilizando sua conta Twitter. Sair / Alterar )

Foto do Facebook

Você está comentando utilizando sua conta Facebook. Sair / Alterar )

Foto do Google+

Você está comentando utilizando sua conta Google+. Sair / Alterar )

Conectando a %s