CELLSRVSTAT in Exadata Cell Storage

Cellsrvstat is very useful utility to get the cell level statastics for all the logical components of  cell like memory,io,smartio,flashcache etc...

Cellsrvstat is use to get quick cell level statistics from particular cell storage. Each CELL contains tool like cellsrvstat which gives brief information about CELL level statistics. It also helps you to get information of offloading and storage index.

It gives brief statistics for following sections.

io                  Input/Output related stats
mem              Memory related stats
exec               Execution related stats
net                 Network related stats
smartio           SmartIO related stats
flashcache       FlashCache related stats
ffi                   FFI related stats
lio                  LinuxBlockIO related stats

Simply running the utility from the command prompt, without any additional parameters or qualifiers, produces the output. You can also restrict the output of cellsrvstat by using the -stat_group parameter to specify which group, or groups, you want to monitor.

Help from cellsrvstat

[root@cell01 ~]# cellsrvstat -h

Exadata Cell Services Administration

There are multiple services runs on Exadata cell server which need to administer on multiple occasion. i.e maintenance, upgrade, monitoring. Here we have listed down the commands to manage each cell service.

• Check the status of all CELL services

#service celld status

           OR

#cellcli -e list cell attributes rsStatus, msStatus, cellsrvStatus detail

• Start all CELL services

#service celld start

          OR

#cellcli -e alter cell startup services all

• Stop all CELL services

Start and Stop Cell Server Processes

Cell services automatically starts with cell boot. If manually start and stop required than we can follow below procedure.

1. Start and stop through OS command

Stop:

Login as a root or celladmin and execute below command to stop services. 

[root@excell01 ~]# service celld stop

Stopping the RS, CELLSRV, and MS services...
The SHUTDOWN of services was successful.

Start:

[root@excell01 ~]# service celld start

Starting the RS, CELLSRV, and MS services...
Getting the state of RS services...
running
Starting CELLSRV services...
The STARTUP of CELLSRV services was successful.
Starting MS services...
The STARTUP of MS services was successful.

2. We can also manage this services with cellcli command utility as given below

Stop:

[root@excell01 ~]# cellcli -e alter cell shutdown services all

Start:

[root@excell01 ~]# cellcli -e alter cell startup services all


3. We can shutdown all services on all the cell servers with the use of dcli utility on DB node as below:

Stop:

[root@exdb01]#dcli -g cell_group -l root "cellcli -e alter cell shutdown services all"

Start:

[root@exdb01]#dcli -g cell_group -l root "cellcli -e alter cell startup services all"

Here cell_group is the list of cell server which contains IP of all the cell.

Exadata Interview Questions Part -2

Get an e-book of Exadata Interview Questions and Answers to stay miles ahead of your competition..!!!

• What is cell disk ?
• What is grid disk ?
• What is IORM ?
• What are the ways to migrate on Exadata ?
• Procedure to drop cell disk on Exadata.
• What is cellsrv and how it works ?
• Use of cellsrv service on Exadata storage cell.
• What is iDB protocol ?
• What is the purpose to use Exacheck tool ?
• What is the oswatcher and how it works ?
• What is RS services and how it works ?
• How to enable HCC on database table ?
• How many networks are available on Exadata ?
• How we can integrate OEM12c with Exadata ?
• What are the ways to install OEM12c agent on Exadata ?
• Which cell services are running on Exadata storage cell ?
• Purpose of MS(management service) on storage cell.
• How cell storage software backup happens ?
• Which OS supports by Exadata ?
• How to power off Exadata Machine ?
• How to do maintainance on Cell Storage and DB server?
• What is writet-through caching mode ?
• What is Write-back caching mode ?
• Explain the procedure to drop the Cell storage ?
• How to replace physical storage disk on cell storage ?

Get Questions and Answers HERE.....

You can follow our Exadata Certification Question Bank to achieve maximum success in your Exadata certification.

Cell Storage Processes

There are three processes will be running on the cell stoarge servers.

cellsrv - Cell Server

It is mutlithreaded process. The primary storage software components. Responsible for disk I/O with the use of iDB protocol.It communicates with Oracle Database to serve simple block requests like database buffer cache reads and Sart Scan requests like tablespaces with projections and filters. CELLSRV also implements I/ORM and collect statistics relating to its operation

MS - Management Server

This is the intermediater between command line interface and cell storage. It provide the interface of storage for configuration and administration purpose. It works with cellcli.It is also responsible to send alerts and collect statistics.

RS - Restart Server

Restart service will monitor the cellsrv and MS processes. It restarts them if necessary.

Cellcli - 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