13
Feb

Exadata: Using cellcli and dcli

  • 4.8
  • Reviews : 842

Each Exadata Storage cell can be monitored, configured, and maintained using the cellcli command line interface. To invoke the CELLCLI, simply login to the Exadata cell as cellmonitor, celladmin, or root user and type “cellcli”. Within cellcli, a wide range of commands can be invoked to monitor the cell. Most of the commands listed below.


List of Cellcli Commands :

 

[cellmonitor@exa1cel01 ~]$ cellcli

CellCLI> help

HELP [topic]

Available Topics:

ALTER

ALTER ALERTHISTORY

ALTER CELL

ALTER CELLDISK

ALTER GRIDDISK

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 IORMPLAN

LIST KEY

LIST LUN

LIST METRICCURRENT

LIST METRICDEFINITION

LIST METRICHISTORY

LIST PHYSICALDISK

LIST QUARANTINE

LIST THRESHOLD

SET

SPOOL

START

 

The help command above showed all the commands available via cellcli. Note the following:

  • Login as root only to perform calibrate commands and do the initial configuration. You can launch cellcli as the root user on any the cell server nodes, but as a matter of practice (and security) it’s best to get used to working with “celladmin” or “cellmonitor”
  • While connected to cellcli as the Linux account celladmin, you can perform all cellcli commands except calibrate.
  • While logged into the cell server as cellmonitor, you can do any “read-only” commands; you cannot change any configuration or attributes. The cellmonitor Linux login should be used for monitoring purposes and can be secured by providing a Linux password that could be distributed to a wider-range class of user than employees that require administrative capabilities.

 

Using dcli

The cellcli commands in the previous section operate on the Cell server you’re logged in to. To obtain a cross-cell view of cell server configuration, metrics, alerts, and other information, you can use dcli (Distributed Command Line Interface). dcli is a Python script installed on each Exadata node that allows you to run Cell CLI commands on multiple cell server nodes at once.

In order or dcli to function, SSH user equivalency should be established to eliminate the need to supply the “celladmin” (or root/cellmonitor) Linux password on the cell servers. Before showing the output of a dcli monitoring command, let’s walk through how to setup SSH equivalency. I’ll start by “unkeying” SSH trust – this basically removed authorized_keys entries from the celladmin’s ~/.ssh directory on each cell server.

[oracle@exa1dbm01 ~]$ dcli -g cell_group  --unkey

exa1cel01: ssh key dropped

exa1cel02: ssh key dropped

exa1cel03: ssh key dropped

[oracle@exa1dbm01 ~]$



Now, we’ll re-establish SSH equivalency:

[oracle@exa1dbm01 ~]$ dcli -g cell_group -k

celladmin@exa1cel02's password:

celladmin@exa1cel03's password:

celladmin@exa1cel01's password:

exa1cel01: ssh key added

exa1cel02: ssh key added

exa1cel03: ssh key added

[oracle@exa1dbm01 ~]$

 

 



Next, ensure that the ~/.ssh directory has 700 permissions for the celladmin Linux user on each cell server. Here’s a sample cell listing using dcli:1 In this example, the “-g cell_group” clause tells dcli to read the “cell_group” file for a list of cell servers to operate on. The contents of cell_group are provided after the actual dcli command below, with one cell server name for each row: 

[oracle@exa1dbm01 ~]$ dcli -g cell_group cellcli -e list cell

exa1cel01: exa1cel01 online

exa1cel02: exa1cel02 online

exa1cel03: exa1cel03 online

[oracle@exa1dbm01 ~]$

[oracle@exa1dbm01 ~]$ cat cell_group

exa1cel01

exa1cel02

exa1cel03

[oracle@exa1dbm01 ~]$


Now to monitor, for example, the amount of FlashCache used in each cell:

[oracle@exa1dbm01 ~]$ dcli -g cell_group cellcli -e list metriccurrent where name=' FC_BY_USED'

exa1cel01: FC_BY_USED FLASHCACHE 13,316 MB

exa1cel02: FC_BY_USED FLASHCACHE 13,344 MB

exa1cel03: FC_BY_USED FLASHCACHE 13,301 MB

[oracle@exa1dbm01 ~]$

 

 


If you were only interested in cell servers exa1cel02 and exa1cel03, use the “-c” option as below: 

[oracle@exa1dbm01 ~]$ dcli –c exa1cel02,exa1cel03 cellcli -e list metriccurrent where name='FC_BY_USED'

exa1cel02: FC_BY_USED FLASHCACHE 13,344 MB

exa1cel03: FC_BY_USED FLASHCACHE 13,301 MB

[oracle@exa1dbm01 ~]$

 

 



You could also use the “-l” option on dcli to provide a non-default (celladmin) login to each cell server; for example, “-l root” or “-l cellmonitor”

 

 


Akal Singh
Oracle Certified Master
Akal Singh stands at the forefront of the fastest-evolving technologies in the IT industry. With over #EXP years of experience as an Oracle DBA, he has honed expertise in DBA support, high availability design and implementation, technical solutions, automation through scripting, and database design. In addition to his technical skills, Akal Singh has made a significant impact as a corporate trainer.

He holds an impressive array of certifications, including OCP, Oracle Certified Expert/Specialist (OCE), and Oracle Certified Master (OCM). His extensive technical knowledge spans operating system administration, virtualization/VMWare, and multiple Oracle Database versions—from 8i through 23ai. His skills also cover Hardware, OS Administration, DBA, Oracle Apps, RAC, Data Guard, ASM, Oracle Exadata, performance tuning, Golden Gate, Streams, and advanced security measures.

Recognized as a Senior Corporate Instructor, Akal Singh has also served with Oracle University, delivering over 300 corporate trainings on advanced database concepts. His deep industry insights and real-time project implementations continue to influence the IT and database community significantly.

Certifications include :
  • Oracle Certified Professional (OCP) 9i, 10g, 11g and 12c
  • Oracle Certified RAC Expert (OCE)
  • Oracle RAC 11g Release 2 and Grid Infrastructure Administration
  • Oracle Database 12c: RAC and Grid Infrastructure Administrator
  • Oracle 11g Exadata Certified Implementation Specialist
  • Oracle Exadata X5 Administration
  • Oracle Database 12c: RAC and Grid Infrastructure Administrator
  • Oracle 10g Certified Master (OCM)
  • Oracle Cloud Autonomous Database Specialist
  • Oracle Cloud Infrastructure Certified Associate
  • Foundation Certificate in IT Service Management (ITIL Certificate)

Related Course

Exadata X8M & X10M

( 4.9)
Reviews : 8,340

Classroom

 15,000

 24,000

38% Off

Online

 24,000

 32,000

25% Off

Related Documents

X8 Related admin

Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum is simply dummy text of the printing and typesetting industry.

Exadata: Using cellcli and dcli

Each Exadata Storage cell can be monitored, configured, and maintained using the cellcli command line interface. To invoke the CELLCLI, simply login to the Exadata cell as cellmonitor, celladmin, or root user and type “cellcli”. Within cellcli, a wide range of commands can be invoked to monitor the cell. Most of the commands listed below.

Related Documents x6 admin

Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum is simply dummy text of the printing and typesetting industry.Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum is simply dummy text of the printing and typesetting industry.Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum is simply dummy text of the printing and typesetting industry.2

1 Comments
akal
Posted at2020-06-18 12:56:13

test comment 2

Post a Comment