ODA Oracle Database Appliance orachk Healthcheck

Asset ID:	1-79-2126926.1
Update Date:	2017-10-05
Keywords:

Solution Type Predictive Self-Healing Sure

Solution 2126926.1 : ODA Oracle Database Appliance orachk Healthcheck

Applies to:

Oracle Database Appliance X5-2 - Version All Versions to All Versions [Release All Releases]
Oracle Database Appliance X4-2 - Version All Versions to All Versions [Release All Releases]
Oracle Database Appliance X3-2 - Version All Versions to All Versions [Release All Releases]
Oracle Database Appliance - Version All Versions to All Versions [Release All Releases]
Linux x86-64
See "Scope" for additional supported products data

Purpose

This document contains div tags within the source HTML. Care should be taken to keep in tact.
Note the "@div" lines within the content and at the bottom Comment section,
"Lifecycle Advisor Document [=DIVs=]" for more detail.
div starts here

The Oracle Database Appliance orachk holistically evaluates several key components within the ODA.

Status of Oracle Software Stack - Clusterware, ASM, RDBMS

Configuration checks for Database Servers, Storage Arrays and Databases
Grid Infrastructure, Database and ASM and operating system software checks
MAA Scorecard which conducts an automatic MAA Review

All checks have explanations, recommendations, and manual verification commands so that customers can self-correct all FAIL and WARNING conditions reported.*

Development recommends that the latest orachk be executed with the following frequency:

Monthly
Week before any planned maintenance activity
Day before any planned maintenance activity
Immediately after completion of planned maintenance activity or an outage or incident

Example (single node)

oakcli orachk

Unable to determine nodes in cluster. Do you want to enter manually.[y/n][y]n

Since you did not enter any node names, this script will execute only on the local node.

Checking ssh user equivalency settings on all nodes in cluster

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
----------------------------------------------------------------------------------------------------------------------------------------
oak1 Yes No No No No No
-----------------------------------------------------------------------------------------------------------------------------------------
. . . . . .

*** Checking Best Practice Recommendations (PASS/WARNING/FAIL) ***

Collections and audit checks log file is
/opt/oracle/oak/orachk/orachk_oak1_041416_074255/log/orachk.log

Checking for prompts in /root/.bash_profile on oak1 for root user...

Verbose listing of collected data:

. .
=============================================================
Node name - oak1
=============================================================
. . . . .

Collecting - Kernel parameters
Collecting - Maximum number of semaphore sets on system
Collecting - Maximum number of semaphores on system
Collecting - Maximum number of semaphores per semaphore set
Collecting - OS Packages
Collecting - Patches for Grid Infrastructure
Collecting - number of semaphore operations per semop system call
Collecting - Firmware and software versions

Collecting - Network and Bonding Interfaces Status
Collecting - OS Disk Storage Status
Collecting - System Component Status
Collecting - Validate Shared storage

Example Adviser section

Data collections completed. Checking best practices on oak1.
--------------------------------------------------------------------------------------

INFO        => Oracle Database Appliance Best Practice References
WARNING => ORA_CRS_HOME environment variable is set
WARNING => CSS reboot time is not set to the default value of 3
FAIL        => One or more errors or warnings for OS Disk Storage checks
FAIL    => One or more errors for network and bonding interface checks
INFO => Some custom (non-default) RPM(s) are installed

Best Practice checking completed.Checking recommended patches on oak1.
...

Continued collection of patch inventories

...
---------------------------------------------------------------------------------

Collecting patch inventory on CRS HOME /u01/app/12.1.0.2/grid
Collecting patch inventory on ASM HOME /u01/app/12.1.0.2/grid
Collecting patch inventory on ORACLE_HOME /u01/app/12.1.0.2/grid
...

Detailed report (html) - /opt/oracle/oak/orachk/orachk_oak1_041416_064013/orachk_oak1_041416_064013.html
The format is orachk_NodeName_MonthDayYear_HourMinuteSecond.html

---------------------------------------------------------------------------------
CLUSTERWIDE CHECKS
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------

UPLOAD(if required) - /opt/oracle/oak/orachk/orachk_oak1_041416_064013.zip

div ends here

Scope

ORACHK supports all hardware versions of the Oracle Database Appliance including:

V1 (4370M)
X3-2
X4-2
X5-2

Unlike the exachk* the ORACHK is not and should _not_ be downloaded as the ORACHK is provided with each ODA patchset bundle**.
The Orachk is tailored for the specific version and unique functionality matching the oak version.

* If you are using Exadata, Big Data Appliance, Exalogic, Exalytics, SuperCluster or Zero Data Loss Recovery Appliance
See: Oracle Exadata Database Machine exachk or HealthCheck (Doc ID 1070954.1)

** Last checked as of 4/20/2016

EXACHK

- Big Data Appliance
- Exadata (V2 and above, HP hardware based V1 systems are not covered)
- Exalogic
- Exalytics
- SuperCluster
- Zero Data Loss Recovery Appliance
- "exachk": Current Production Version: 12.1.0.2.6_20160317
  -- Always use the latest available exachk version.
  
  NOTE: If your Oracle Exadata Database Machine participates in the Oracle Platinum Services: Exadata Exachk Automation Project, follow the instructions provided in Oracle Platinum Services:
  Exadata Exachk Automation Project (Doc ID 2043991.1). Do NOT follow the generic instructions below.
  Download the attached "exachk_121026_bundle.zip" file to your desktop computer and unzip the file. Follow the documentation, training materials, and readme files to understand how to deploy and execute the exachk utility to an Oracle Exadata Database Machine.

*Details
Enter the reference text.

Usage : ./orachk [-abvhpfmsuSo:c:t:]

-h                             Prints this page.
-a                              All (Perform best practice check and recommended patch check)
-b                             Best Practice check only. No recommended patch check
-v                             Show version
-p                             Patch check only
-m                            exclude checks for Maximum Availability Architecture (MAA) scorecards(see user guide for more details)
-u                             Run orachk to check pre-upgrade or post-upgrade best practices for 11.2.0.3 and above
-o                             pre or -o post is mandatory with -u option like ./orachk -u -o pre
-f                              Run Offline.Checks will be performed on data already collected from the system
-o                             Argument to an option. if -o is followed by v,V,Verbose,VERBOSE or Verbose, it will print checks which passs on the screen
if -o option is not specified,it will print only failures on screen. for eg: orachk -a -o v

Details

- clusternodes              Pass comma separated node names to run orachk only on subset of nodes.
- output                      Create orachk collection zip file and ouptut directory to non-default(current) location.
- dbnames                  Pass comma separated database names to run orachk only on subset of databases
- localonly                   Run orachk only on local node.
- debug                      Run orachk in debug mode. Debug log will be generated.
     eg:- ./orachk -debug

- dbnone                    Do not prompt database selection and skip all database related checks.
- dball                        Do not prompt database selection and run database related checks on all databases discovered on system.
- c                              Used only under the guidance of Oracle support or development to override default components
- upgrade                    Used to force upgrade the version of orachk being run.
- noupgrade                 Do not prompt for an upgrade even if a later version is available under the location specified by RAT_UPGRADE_LOC.
- syslog                       Write JSON results from orachk run to syslog.
- skip_usr_def_checks    Do not run checks present in user defined xml file.
- unlockcells <all | -cells [cell names or cell IPs separated by comma]

div ends here

Community Discussions

The link below is a live discussion of this article . We encourage you to join the discussion by clicking the "Reply" link below for the entry you would like to provide feedback on. If you have questions or implementation issues with the information in the article above, please share that below.

https://community.oracle.com/thread/3642976

References

<NOTE:757552.1> - Oracle Exadata Best Practices

Attachments

This solution has no attachment