Exadata Monitoring Command

Additional monitoring commands which are required with usual DBA skill set on DB and CELL server.

Database Server

    Linux: top, mpstat, vmstat, iostat, fdisk, ustat, sar, sysinfo

    Exadata: dcli

    ASM: asmcmd, asmca

    Clusterware: crsctl, srvctl

Cell Server

    Linux: top, mpstat, vmstat, iostat, fdisk, ustat, sar, sysinfo

    Cell management: cellcli, cellsrvstat


                                    Exadata Monitoring Tools

How to enable Exadata writeback Flashcache on cell storage ? (WriteThrough to WriteBack)

Steps to enabling the Flashcache mode:

This can be done in rolling as well as non-rolloing manner.

First check flashcache mode with below command on all cell servers with the use of dcli utility on DB node. It can be check on cell each server also with cellcli utility.

dbnode1#dcli -l root -g cellgroup "cellcli -e list cell detail" | grep "flashCacheMode"

10.156.110.10: flashCacheMode:          WriteThrough
10.156.110.11: flashCacheMode:          WriteThrough
10.156.110.12: flashCacheMode:          WriteThrough
10.156.110.13: flashCacheMode:          WriteThrough
10.156.110.14: flashCacheMode:          WriteThrough
10.156.110.15: flashCacheMode:          WriteThrough
10.156.110.16: flashCacheMode:          WriteThrough

Step-1
Also we can find flashcache mode in each cell by executing below command:

cellcli>list cell detail

flashCacheMode: WriteThrough     --->Currently flashCacheMode configured as WriteThrough

Step-2
Now drop flashcache on each cell server: (If you are following rolling manner then do one by one on each cell server)

cellcli> drop flashcache

Step-3
Be sure asmdeactivationoutcome is YES before disabling grid disk

CellCLI> list griddisk attributes name,asmmodestatus,asmdeactivationoutcome

Step-4

User Equivalence between DB Node and Storage Cell

In configuration of user equivalence is quite simple as it has been managed by executable script which doesn't required manual actions which generally we do in normal server setup.

Explained user equivalence setup procedure for Exadata servers and storage.

Checking the hostname on storage server from DB node with dcli utility where SSH equivalence has not been configured.

[oracle@ex01dbm01 ~]$ dcli -c ex01cel01 -l oracle hostname

celladmin@ex01cel01's password:

ex01cel01: ex01cel01@example.com

Now pushing SSH key to storage cell with below command

[oracle@ex01dbm01 ~]$ dcli -g ./cell_group -k

celladmin@ex01cel02's password:

celladmin@ex01cel01's password:

celladmin@ex01cel03's password:

ex01cel01: ssh key added

ex01cel02: ssh key added

ex01cel03: ssh key added

Here cell_group is the list of cell storage server name .

Now executing dcli on storage cell to check whether user equivalence has been configured properly or not.

[oracle@ex01dbm01 ~]$ dcli -c ex01cel01 -l oracle hostname

ex01cel01: ex01cel01@example.com

Above command has not asked any password to login into the cel01 that means equivalence is working fine.

                            Oracle User Equivalence between two DB servers

Cheeers..!!!

Exadata Interview Questions - Part 1

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

• What is Exadata?
• Key components of Exadata
• Features of Exadata
• Exadata Sizing
• Difference between ordinary database setup and Exadata
• What is storage index and how it works
• Use of Flash Cache
• Background services of Cell Server
• What is cellcli?
• How to replace faulty HDD in Exadata?
• How to remove and add cell storage to running system?
• How to migrate database from normal setup to Exadata ?
• Exdata Shutdown procedure
• Which OS is supported by Exadata?
• What is ASR?
• How to integrate Exadata with OEM 12c?
• How to upgrade firmware of Exadata components?
• How to upgrade Exadata?
• Where we can define which cell storage can be used by particular database server?
• How to check Exadata health check?
• What is EHCC?
• Options to configure backup and recovery for Exadata
• What is offloading and how it works?
• What is cellcli and dcli?

Get Questions with answers HERE....

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