3.4 Oracle SuperCluster

This section explains the features and tasks specific to Oracle EXAchk on Oracle SuperCluster.

3.4.1 Scope and Supported Platforms for Running Oracle EXAchk on Oracle SuperCluster

Oracle EXAchk is an invaluable aid in keeping your system up-to-date and recording changes, as well as providing baselines for support analysis in the event such data is required to resolve a Service Request.

Refer to My Oracle Support Note 2053185.1 for the latest scope and supported platforms specific to Oracle EXAchk on Oracle SuperCluster:

3.4.2 Installing and Deploying Oracle EXAchk on Oracle SuperCluster

Follow these procedures to install and deploy Oracle EXAchk on Oracle SuperCluster.

3.4.2.1 Installing Oracle EXAchk on Oracle SuperCluster

Installation

  • Run Oracle EXAchk from the primary ldom as root  user or root privileged user. Oracle EXAchk discovers all Oracle RAC and database instances, compute nodes, storage servers, and InfiniBand switches in the fabric.

  • Run Oracle EXAchk in a database zone or virtualized environment. Oracle EXAchk collects data from one or all database instances and Oracle RAC nodes.

Notes and considerations

If you install and run Oracle EXAchk as root, it collects connectivity data from the GZ to the storage cells and other nodes. Oracle EXAchk collects only collect database and Oracle RAC data if run as root  user or root privileged user from within the nodes or zones on which the database and Oracle RAC software is installed.

By default, there should be no need to set environment variables or run as any other user than root  or root privileged user. However, there may be exceptions when one is asked to run it in some debug or extraordinary fashion by an Oracle Support Analyst.

By default, the output destination is /opt/oracle.SupportTools/exachk . Set the environment variable RAT_OUTPUT to change this, for example,
export RAT_OUTPUT=/opt/oracle.SupportTools/exachk/output

Merge multiple collections into one file for ease of uploading to My Oracle Support for analysis.

Note:

In zones, there is an issue with discovery and you must explicitly set the RAT_ORACLE_HOME and RAT_GRID_HOME environment variables in some remote cases.

3.4.2.2 Deploying Oracle EXAchk on Oracle SuperCluster

  1. Download the latest version of Oracle EXAchk into /opt/oracle.SupportTools directory on the primary node/LDOM of the Oracle SuperCluster.
    1. Backup or remove if you have already installed Oracle EXAchk.
    2. Download the latest version of the Oracle EXAchk on Oracle SuperCluster deployment script deploy_exachk.sh.
    3. Move the downloaded file into the /opt/oracle.SupportTools directory.
  2. Use the deploy_exachk.sh script to deploy and install Oracle EXAchk into the /opt/oracle.SupportTools/exachk directory in the primary ldom and in each zone.

    Note:

    Repeat this action for each of the other LDOMs.

    Example of what a zone's /opt/oracle.SupportTools looks like when this is finished:

    total 68
    drwxr-xr-x   7 root     root          10 Oct 14 19:27 .
    drwxr-xr-x   8 root     sys            8 Oct  7 22:06 ..
    drwxr-xr-x   3 root     root          21 Oct 14 19:27 Exachk.old
    drwxr-xr-x   3 root     root          23 Oct 14 19:06 Exachk
    drwxr-xr-x   2 root     root           7 Oct  5 20:52 em
    lrwxrwxrwx   1 root     root          14 Oct 14 19:27 exachk -> Exachk
    drwxr-xr-x   2 root     root           6 Oct  7 20:43 onecommand
    -rw-r--r--   1 root     root       40830 Oct  7 20:30 resourcecontrol
    
3.4.2.2.1 Manual or Standalone Installation
  1. Manually install Oracle EXAchk on each host or LDOM or zone as follows:
    root@abc5db01:/opt/oracle.SupportTools# mv exachk Exachk.old
    root@abc5db01:/opt/oracle.SupportTools# mkdir exachk
    root@abc5db01:/opt/oracle.SupportTools# unzip exachk_121024_bundle.zip -d exachk
    root@abc5db01:/opt/oracle.SupportTools# unzip exachk/exachk.zip -d exachk
    
  2. Check the version.
    # /opt/oracle.SupportTools/exachk/exachk -v
    
    Note if root RSA keys are set up for ssh, then this is an example of an easy way to check all zones in a given LDOM:
    
    root@abc5db01:/opt/oracle.SupportTools# zoneadm list | grep -v global > zone_list
    root@abc5db01:/opt/oracle.SupportTools# hostname >> zone_list
    root@abc5db01:/opt/oracle.SupportTools# /opt/oracle.supercluster/bin/dcli -g zone_list -l root /opt/*Tools/exachk/exachk -v
    abc5db01z1: 
    abc5db01z1: EXACHK  VERSION: 12.1.0.2.6_20160208
    abc5db01z2: 
    abc5db01z2: EXACHK  VERSION: 12.1.0.2.6_20160208
    abc5db01z3: 
    abc5db01z3: EXACHK  VERSION: 12.1.0.2.6_20160208
    abc5db01z4: 
    abc5db01z4: EXACHK  VERSION: 12.1.0.2.6_20160208
    abc5db01: 
    abc5db01: EXACHK  VERSION: 12.1.0.2.6_20160208
    

3.4.3 Oracle EXAchk on Oracle SuperCluster Usage

Perform health checks from GZ / primary LDOM, or NGZ.

Performing Health Checks from GZ / Primary LDOM

root@abc5db01:/opt/oracle.SupportTools/exachk# ./exachk
exachk did not find the inventory location on abc5db01 from environment.Does abc5db01 have Oracle software installed [y/n][n]?n

Checking ssh user equivalency settings on all nodes in cluster

Node abc5db02 is configured for ssh user equivalency for root user
 
Node abc5db03 is configured for ssh user equivalency for root user
 
Node abc5db04 is configured for ssh user equivalency for root user
<snip>

Performing Health Checks from non-GZ local zone, aka NGZ

root@abc4db01:/opt/oracle.SupportTools/exachk# zlogin abc4db01z2
[Connected to zone 'abc4db01z2' pts/10]
Oracle Corporation      SunOS 5.11      11.1    April 2014
root@abc4db01z2:~# cd /opt/*Tools
root@abc4db01z2:/opt/oracle.SupportTools# cd exachk
root@abc4db01z2:/opt/oracle.SupportTools/exachk# ./exachk


Checking ssh user equivalency settings on all nodes in cluster
<snip>

3.4.3.1 Merging Collections

Merge multiple collections into one file and upload it to an SR through curl.

Note:

Specify the -force option after the comma-delimited file list.

root@abc4db01:/opt/oracle.SupportTools/exachk# ./exachk -merge exachk_abc4db01_090715_214648.zip,
/zoneHome/abc4db01z1/root/opt/oracle.SupportTools/exachk/exachk_abc4db01z1_abc4z1_090415_183027.zip,/zoneHome/abc4db01z2/root/opt/oracle.SupportTools/exachk/exachk_abc4db01z2_abc4z2_090715_211212.zip,
/zoneHome/abc4db01z3/root/opt/oracle.SupportTools/exachk/exachk_abc4db01z3_dbm01_031015_212416.zip 
-force
Merging following collections:

  exachk_abc4db01_090715_214648.zip
  /zoneHome/abc4db01z1/root/opt/oracle.SupportTools/exachk/exachk_abc4db01z1_abc4z1_090415_183027.zip
  /zoneHome/abc4db01z2/root/opt/oracle.SupportTools/exachk/exachk_abc4db01z2_abc4z2_090715_211212.zip
  /zoneHome/abc4db01z3/root/opt/oracle.SupportTools/exachk/exachk_abc4db01z3_dbm01_031015_212416.zip


Started merging exachk_orlt4db01_090715_214648.zip
  ........................................................................................

Started merging /zoneHome/abc4db01z1/root/opt/oracle.SupportTools/exachk/exachk_abc4db01z1_abc4z1_090415_183027.zip
  ............................................................................................................................................................................................

Started merging /zoneHome/abc4db01z2/root/opt/oracle.SupportTools/exachk/exachk_abc4db01z2_abc4z2_090715_211212.zip
  ............................................................................................................................................................................................

Started merging /zoneHome/abc4db01z3/root/opt/oracle.SupportTools/exachk/exachk_abc4db01z3_dbm01_031015_212416.zip
  ............................................................................................................................................................................................
<snip>
Detailed report (html) - /opt/oracle.SupportTools/exachk/exachk_abc4db01_090715_214648_merge/exachk_abc4db01_090715_214648_merge.html

UPLOAD(if required) - /opt/oracle.SupportTools/exachk/exachk_abc4db01_090715_214648_merge.zip


root@abc4db01:/opt/oracle.SupportTools/exachk#

Related Topics

3.4.3.2 Automated Daemon Mode Operation

Follow these specific advanced setup instructions when using Oracle EXAchk on Oracle SuperCluster.

Before you schedule automated health check runs, set the following environment variables as follows:

export RAT_TIMEOUT=120
export RAT_ROOT_TIMEOUT=600
export RAT_PASSWORDCHECK_TIMEOUT=30
export RAT_OUTPUT=/opt/oracle.SupportTools/exachk/output
export RAT_COPY_EM_XML_FILES=1

Note:

Create a file with these commands because they are required to be set anytime you restart the daemon.

  1. Set the AUTORUN_SCHEDULE environment variable as follows:
    AUTORUN_SCHEDULE * * * * :- Automatic run at specific time
                     - - - -
                     ¦ ¦ ¦ ¦
                     ¦ ¦ ¦ +----- day of week (0 - 6) (0 to 6 are
                     ¦ ¦ ¦       Sunday to Saturday)
                     ¦ ¦ +---------- month (1 - 12)
                     ¦ +--------------- day of month (1 - 31)
                     +-------------------- hour (0 - 23)
    
    For example, to run on 5th of every month at 2 AM:
    ./exachk -set "AUTORUN_SCHEDULE=2 5 * *"
  2. Check the results.
    ./exachk -get all
  3. Set the daemon and inittab.
    ./exachk -initsetup

    Note:

    If the preceding action produces an error, then wait for one or two minutes before running the next command to give init time to respawn the process.

  4. Check if the daemon is running.
    ./exachk -d nextautorun

3.4.4 Troubleshooting Oracle EXAchk on SuperCluster

Troubleshoot and fix issues related to Oracle EXAchk on Oracle SuperCluster.

Refer to My Oracle Support Note 2053185.1 for the latest known issues specific to Oracle EXAchk on Oracle SuperCluster.