oracledba.help

ORAchk: Health Checks for the Oracle Stack

<- SpecialTopics

Overview

Oracle ORAchk is a free, lightweight and non-intrusive health check framework for the Oracle stack of software and hardware components. It allows you to better identify and act on those factors that effect Oracle compliance, stability and performance.

Features

  1. Automates risk identification and proactive notification before business is impacted
  2. Runs health checks based on critical and reoccurring problems.
  3. Runs in your environment with no need to send anything to Oracle.
  4. Enables you to schedule email health check reports.
  5. Integrates the findings into other tools of your choice.
  • ORAchk is pre-installed with the database. These instructions cover how to use the latest version.
  • EXAchk is not covered here (it is for Oracle Engineered Systems).

To download go to: Doc ID 1268927.2

Installation

Create App Directory

 su -
 mkdir /u01/app/orachk
 chown grid:oinstall /u01/app/orachk
 chmod 765 /u01/app/orachk

For a stand-alone database system use the oracle user instead of grid user.

Unzip File

 su - grid
 cp /tmp/orachk.zip /u01/app/orachk/
 cd /u01/app/orachk
 unzip orachk.zip

For a stand-alone database system use the oracle user instead of grid user.

Create Report

Example usage session below.

 su -
 export GRID_HOME=/u01/app/12.2.0.1/grid
 export PATH=$GRID_HOME/bin:$PATH

 cd /u01/app/orachk
 ./orachk
  • For a stand-alone database system use the oracle user instead of the root user to create report.
  • You can also run orachk in local mode with the switch -localonly.
 CRS stack is running and CRS_HOME is not set. 
 Do you want to set CRS_HOME to /u01/app/12.2.0.1/grid?[y/n][y]
 ...
 Please indicate your selection from one of the above options for root access[1-4][1]
 ...
 Select databases from list for checking best practices. 
 For multiple databases, select 1 for All or comma separated number like 1,2 etc [1-2][1]

Output

After running you will see the path displayed for the report.
Output Format: <path>/orachk_<hostname>_<run-date>/orachk_<hostname>_<run-date>.html

Example:
/u01/app/orachk/orachk_lnx01_010318_121350/orachk_lnx01_010318_121350.html