Implementing ORAchk in Oracle Enterprise Manager 13c

Heard about it at Oracle OpenWorld 2015: A new feature in Oracle Enterprise Manager 13c is the possibility to incorporate ORAchk, the healthcheck tool for databases, RAC and Engineered Systems.

This post is about downloading (and importing), deploying and provisioning the ORAchk-plugin. Spoiler-alert: there’s downtime involved of the OMS.

There are two ways for downloading and deploying : offline-patching and on-line, which means whether OEM is connected to My Oracle Support or not. In this post I will describe both methods ( every method by the way with varying success). And of course you can choose between using the command-line EMCLI and the graphical user interface. It’s Enterprise Manager, so mainly using the gui, but sometimes  forced to use the command-line.

Starting point: the documentation.

Prerequisites

According to the documentation the following prerequisites must be met before you can deploy the plug-in:

  • Verify that your Engineered Systems hardware and software are at the supported level as described inSupported Hardware and Software Versions.
  • All Engineered System plug-ins should be deployed.
  • InfiniBand switches and storage cells should be an Enterprise Manager-managed target for the respective engineered system.
  • Expect package should be installed on the hosts.

I’m using ORAchk for regular databases so I’m ignoring this for the moment.

According to the documentation about downloading of the plugin there are two ways to download the plugin: in offline mode and online mode.

First I chose the method of ‘Downloading Plugins in Offline Mode’ as I don’t want internet connection with my OEM. But: I will describe this very briefly, because I didn’t get it to work via off-line mode! Still describing the steps because I think it’s a nasty bug (it’s never me of course Smile ) which will soon be solved.

Downloading and importing in offline mode.

Downloaded the plugin. This is a zip file with constantly the same name, so you can’t see which version you are using…. A bit peculiar.

Copied this file to the OEM-(virtual) host.  Set Enterprise Manager Cloud Control to Offline Mode: Setup –> Provisioning and Patching –> select Offline Patching.

When selecting ‘check for updates you get the following message:

clip_image004

Import the archive through EMCLI:

# cd  /u01/app/oracle/product/mw/bin

# ./emcli login –username=sysman

# ./emcli sync (don’t know for sure if it’s necessary)

# ./emcli import_update_catalog –file=home/oracle/p9348486_112000_Generic.zip –omslocalclip_image009

In the self-update page you can see the status when clicking on ‘Plugin’): Downloaded.

In emcli you can see this via :

# emcli get_plugin_deployment_status –plugin_id=oracle.sysman.orhc

clip_image011

Trying to deploy the plugin:

clip_image012

In the next screens adding the plugin and clicking ‘Next’ to deploy: error.

clip_image018

EM-4084: The current state of ORAchk Healthchecks does not qualify for further operation.  So… no issues with prerequisites or what so ever, the file is successfully imported, but not usable for some reason.

Nothing in log-files. Trying to deploy the file through EMCLI:

clip_image025

Same result. Deleted the plugin, downloaded and imported again. Also deployed the prerequisites plugins of engineered system and installed the linux package ‘Expect’. No success. No bugs or documentation found in My Oracle Support.

Allright, switching to deploying the ORAchk in Online mode (yes, this works!).

Deploying the plugin, online through GUI and EMCLI.

Choose Setup –> Extensibility –> Self Update –> Online mode.

You may have to fill in the credentials for My Oracle Support in between.

When clicking the ‘Check updates’, OEM will check on updates and ‘Oracle ORAchk healthcheck will be visible in the plugin-page:

clip_image045

Select the plugin, and download:

clip_image046

When downloaded, going to deploy the plug-in.

Plugin page:

image

Deploying the plugin the same way as in off-line mode: now we’re getting somewhere.

clip_image048

Next:

clip_image049

After the review and confirmation: deploying which will automatically restart the OMS !

clip_image051

Provisioning ORAchk

Choose Enterprise –>Provisioning and Patching—>Procedure Library

clip_image052

Launch through clicking ‘Go’.

clip_image054

Specifying root passwords.

clip_image056

clip_image057

Clicking show status:

image

Managing the ORAchk plugin

Choose Enterprise—>  Provisioning and Patching—> Procedure Library

Choose ‘Manage ORAchk/Exachk and click ‘go’.

image

Mainly you have the opportunity to stop the daemon which is running at that moment.

Output

Got it working. Where’s the output?

Here’s the documentation about using this plugin.

Choose Enterprise –> Compliancy –> Results

image

The OEM-repository had a score of 97%:

image

Unfortunately, when clicking on db_block_checksum, there are no ‘recommended actions’ on this page. It’s incompliant, that’s it. Clicking further you will get the standards.

image

All together it’s quite simple to implement ORAchk when you’re Enterprise Manager Environment is in online mode. And that’s compliant to the policy of Oracle…

And probably / hopefully there will be patches of the ORAchk plugin in short notice.

Resources

General documentation: http://docs.oracle.com/cd/E63000_01/PICHK/ch1_overview.htm#PICHK117

Documentation about downloading plugin: http://docs.oracle.com/cd/E24628_01/doc.121/e24473/plugin_mngr.htm#CJGBEAHJ

Download page plugin: https://updates.oracle.com/Orion/Download/download_patch/p9348486_112000_Generic.zip

Using the plugin: http://docs.oracle.com/cd/E63000_01/PICHK/ch3_accessing.htm#PICHK161

By | 2016-02-03T08:47:34+00:00 February 3rd, 2016|Categories: Database, Meta-DBA|Tags: , |2 Comments

About the Author:

2 Comments

  1. merlin128 June 29, 2016 at 11:19 pm

    when I get to Provisioning ORAchk
    I choose Enterprise -> Provisioning and Patching -> Procedure Library
    check Provision ORAchk and click GO next to LAUNCH

    I choose HOST and Host Target
    set Credentials (that test successful)
    set install location
    and when I click NEXT it errors:

    FAILED to create command process /bin/mkdir /tmp/######### execution failed. The system cannot find the file specified.
    (note the ###### is different every time I click next in the provision screen)

    I have Cygwin installed on windows and ssh connections to it work, and /bin/mkdir /tmp/#### work if I manually test them via ssh

    c:\cygwin is included in my path statement
    %OMS_HOME%\oui\prov\resources\ssPaths_msplats.properties has the correct paths to c:\cygwin

    the agent deployment worked.

    when I choose Install Location it is in windows format D:\App so I am guessing it is attempting to use mkdir from windows with the /bin/mkdir path which fails.. instead of connecting via ssh to cygwin

  2. Job July 8, 2016 at 12:01 pm

    I am not able to reproduce this as I worked with Linux, but it looks like a ‘feature’ of Windows/cygwin and e.g. Doc ID 1556504.1. Just a wild guess, adding cygwin%\bin to the path, 32-bits cygwin on 64-bits Windows? Regards.

Leave A Comment