AWS Administration - 100% Lab - Online Training | AKSWAVE
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 :

 

[[email protected] ~]$ 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.

[[email protected] ~]$ dcli -g cell_group  --unkey

exa1cel01: ssh key dropped

exa1cel02: ssh key dropped

exa1cel03: ssh key dropped

[[email protected] ~]$



Now, we’ll re-establish SSH equivalency:

[[email protected] ~]$ dcli -g cell_group -k

[email protected]'s password:

[email protected]'s password:

[email protected]'s password:

exa1cel01: ssh key added

exa1cel02: ssh key added

exa1cel03: ssh key added

[[email protected]m01 ~]$

 

 



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: 

[[email protected] ~]$ dcli -g cell_group cellcli -e list cell

exa1cel01: exa1cel01 online

exa1cel02: exa1cel02 online

exa1cel03: exa1cel03 online

[[email protected] ~]$

[[email protected] ~]$ cat cell_group

exa1cel01

exa1cel02

exa1cel03

[[email protected] ~]$


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

[[email protected] ~]$ 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

[[email protected] ~]$

 

 


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

[[email protected] ~]$ 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

[[email protected] ~]$

 

 



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, 20+ yrs exp
Akal Singh stands at the forefront of the fastest moving technologies in IT Industry. He spent his past 20 years as Oracle DBA with skills into DBA Support, High Availability Design & Implementations, Technical Solutions, Automation using Scripting, Database Designing & as a Corporate Trainer too. With deep technical industry knowledge, Akal Singh has implemented many real time projects on advance Database areas.

His certification list includes many OCP, Oracle Certified Expert/Specialist (OCE) and Oracle Certified Master (OCM). He is an expertise in OS Administrations, Virtualizations/VMWare and Oracle Database 8i/9i/10g/11g & 12c, RAC, Data Guard, ASM, Oracle Exadata, Oracle Performance Tuning, Golden Gate, Streams, Oracle Security & many more advance technologies.

Akal Singh is also recognized as Senior Corporate Instructor and worked with Oracle University training division providing more than 300 corporate trainings into database advance concepts.

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

Related Course

Exadata 12c

( 4.8)
Reviews : 2,340

Classroom

 18,000

 22,000

18% Off

Online

 22,000

 32,000

31% Off

Related Documents

X6 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 Doumnets 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