The use of "Oracle" exadata daily patrol tool Exachk ____oracle

In Exadata, it is best to run Exachk for health checks when there are any database-independent issues. Exachk collection of information is very complete, eliminating the tedious steps of manual collection. And after the collection is completed, you can make an assessment of the system's health status as a whole, including software, hardware, firmware version, configuration and other aspects of information, found some suspicious points, and then narrow the scope for the next step of the diagnosis.

This article mainly records the basic use method of Exachk, Exachk can be downloaded from MOS document: 1070954.1.

First to declare two environment variables rat_oracle_home and rat_exadata_version, otherwise the use of the process will be an error:

[Oracle@dm02db01 dbhome_1]$ Echo $ORACLE _home

/u01/app/oracle/product/11.2.0.4/dbhome_1

[Oracle@dm02db01 dbhome_1]$ Export Rat_oracle_home=/u01/app/oracle/product/11.2.0.4/dbhome_1

[Oracle@dm02db01 exachk]$ Rpm-qa |grep exadata

Exadata-oswatcher-11.2.3.3.0.131014.1-1

Exadata-asr-11.2.3.3.0.131014.1-1

Exadata-sun-computenode-11.2.3.3.0.131014.1-1

Exadata-base-11.2.3.3.0.131014.1-1

Exadata-applyconfig-11.2.3.3.0.131014.1-1

Exadata-ibdiagtools-11.2.3.3.0.131014.1-1

Exadata-exachk-11.2.3.3.0.131014.1-1

Exadata-validations-compute-11.2.3.3.0.131014.1-1

Exadata-ipconf-11.2.3.3.0.131014.1-1

Exadata-commonnode-11.2.3.3.0.131014.1-1

Exadata-firmware-compute-11.2.3.3.0.131014.1-1

Exadata-sun-computenode-minimum-11.2.3.3.0.131014.1-1

[Oracle@dm02db01 exachk]$ Export rat_exadata_version=11.2.3.3.0

Then run EXACHK:

[Oracle@dm02db01 dbhome_1]$ cd/opt/oracle. supporttools/

[Oracle@dm02db01 Oracle. supporttools]$ CD Exachk

[Oracle@dm02db01 exachk]$./exachk

The CRS stack is running and crs_home are not set. Do your want to set Crs_home To/u01/app/11.2.0.4/grid? [y/n] [Y]--Confirm the Crs_home path

Checking SSH user equivalency settings on all nodes in cluster

Node DM02DB02 is configured to SSH user equivalency for Oracle user

Searching for running databases .....

. . . . . . . . . . . . . .

List of running databases registered in OCR

1. Bdataedw

2. Bdataetl

3. Cata

4. Edw

5. ETL

6. Omsstd

7. Portalstd

8. Rdsdbstd

9. All

None

Select respective number to choose the database for checking best practices.  For multiple databases, select 9 for all or comma separated number like 1,2 etc [1-10][9]. --Select the library to check, 1-8 is scanned to 8 libraries, 9 is all check, 10 is skipped.

Searching out Oracle_home for selected databases.

. . . . . . . . . . . . . . . . . . .

LS:/u01/app/oracle/product/11.2.0.4/dbhome_1oracle_home_old/bin/oracle:no such file or directory

Checking Status of Oracle Software stack-clusterware, ASM, RDBMS

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

-------------------------------------------------------------------------------------------------------

Oracle Stack Status

-------------------------------------------------------------------------------------------------------

Host Name CRS installed ASM home RDBMS installed CRS up ASM up RDBMS up DB Instance Name

-------------------------------------------------------------------------------------------------------

DM02DB01 Yes Yes Yes BDATAEDW1 BDATAETL1 cata1 edw1 ET L1 OMS3 Portal1 RDSDB1

DM02DB02 Yes Yes Yes bdataedw2 bdataetl2 cata2 edw2 ET L2 OMS4 Portal2 RDSDB2

-------------------------------------------------------------------------------------------------------

Root user equivalence is not setup between DM02DB01 and STORAGE SERVER dm02cel01.

1. Enter 1 If you enter the root password for each STORAGE SERVER when prompted.

2. Enter 2 to exit and configure root user equivalence manually and re-run Exachk.

3. Enter 3 to skip checking best practices on STORAGE SERVER.

Please indicate your selection from one of the above options[1-3][1]:-

are root password same on all STORAGE server[y/n][y]

Enter root password for STORAGE SERVER:---Password for all cell nodes

Root password for 192.168.0.19 is incorrect. 2 retries remaining.

Enter root password for 192.168.0.19:-

Root password for 192.168.0.19 is incorrect. 1 retries remaining.

Enter root password for 192.168.0.19:-

Root password for 192.168.0.19 is incorrect. Root privileged checks won't is executed on 192.168.0.19

-If there is a node's root password and the difference between the other nodes will prompt you to input separately, if you do not know exachk in the collection phase will skip the node, does not affect the normal operation of other nodes.

Expect:spawn ID EXP6 not open

While executing

"Expect" *?assword:* ""

Expect:spawn ID EXP6 not open

While executing

"Expect" *?assword:* ""

Expect:spawn ID EXP6 not open

While executing

"Expect" *?assword:* ""

Expect:spawn ID EXP6 not open

While executing

"Expect" *?assword:* ""

The included audit checks require root privileged data collection on DATABASE SERVER. If sudo is not configured or the root password isn't available, audit checks which require root privileged data collecti On can is skipped.

1. Enter 1 if you'll enter root password for all on the DATABASE SERVER host when prompted

2. Enter 2 If you have sudo configured for Oracle user to execute root_exachk.sh script on DATABASE SERVER

3. Enter 3 to skip the root privileged collections on DATABASE SERVER

4. Enter 4 to exit and work with the SA to configure sudo on DATABASE SERVER or to arrange for root access and run the too L later.

Please indicate your selection from one of the above options[1-4][1]:-

are root password same on all compute nodes? [y/n] [Y]

Enter root password on DATABASE server:---root password for all DB nodes

9 of the included audit checks require root privileged data collection on InfiniBand SWITCH.

1. Enter 1 if you'll enter root password for each InfiniBand SWITCH when prompted

2. Enter 2 to exit with arrange for root access and run the Exachk later.

3. Enter 3 to skip checking best practices on InfiniBand SWITCH

Please indicate your selection from one of the above options[1-3][1]:-

are root password same on all InfiniBand SWITCH? [y/n] [Y]--infiniband's root password

Enter root password for InfiniBand SWITCH:-

Root passwords for following nodes are incorrect.

You can still continue but root privileged checks to not is executed on following.

1.192.168.0.19

Do your want to continue[y/n][y]:-

Checking Best Practice Recommendations (pass/warning/fail) * * * *

Log file for collections and audit checks are at

/opt/oracle. Supporttools/exachk/exachk_112114_162425/exachk.log

=============================================================

Node NAME-DM02DB01

=============================================================

Collecting-asm DIsk I/o stats

Collecting-asm Disk Groups

Collecting-asm DiskGroup Attributes

Collecting-asm Disk Partnership Imbalance

Collecting-asm Initialization Parameters

Collecting-active Sessions load balance for BDATAEDW database

Collecting-active Sessions load balance for BDATAETL database

Collecting-active Sessions load balance for CATA database

Collecting-active Sessions load balance for EDW database

..............

Collecting patch inventory on CRS Home/u01/app/11.2.0.4/grid

Collecting patch inventory on Oracle_home/u01/app/oracle/product/11.2.0.4/dbhome_1

Collecting patch inventory on Oracle_home/u01/app2/oracle/product/11.2.0.2/dbhome_1

---------------------------------------------------------------------------------

Detailed (HTML)-/opt/oracle. Supporttools/exachk/exachk_rdsdbstd_112114_162425/exachk_rdsdbstd_112114_162425.html

UPLOAD (if required)-/opt/oracle. Supporttools/exachk/exachk_rdsdbstd_112114_162425.zip

Now that Exachk is finished, you can download/opt/oracle. Supporttools/exachk/exachk_rdsdbstd_112114_162425.zip file, open/opt/oracle. Supporttools/exachk/exachk_rdsdbstd_112114_162425/exachk_rdsdbstd_112114_162425.html for viewing.

Can be more intuitive to see some of the existing problems, the interface is as follows: