Implementing ORAchk in Oracle Enterprise Manager 13c

Job Oprel 5
0 0
Read Time:4 Minute, 21 Second

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

About Post Author

Job Oprel

Until February 2019, Job worked as a solution architect at AMIS Services with a special interest in Oracle licensing, High Availability architectures and managing complex (Oracle) environments, which includes Cloud environments.With a background as Oracle developer, DBA, team-manager and license-consultant he is able to utilize the Oracle technologies to a cost-efficient architecture for his customers.He is regularly involved in consultancy regarding: - Unlimited License Agreements (ULA). - License compliancy-checks and advice regarding optimizing the environment. - Second opinions. - Education / presentations about licensing and managing your infrastructure in the most cost-efficient manner.Twitter: @jobaclenl
Happy
Happy
0 %
Sad
Sad
0 %
Excited
Excited
0 %
Sleepy
Sleepy
0 %
Angry
Angry
0 %
Surprise
Surprise
0 %

Average Rating

5 Star
0%
4 Star
0%
3 Star
0%
2 Star
0%
1 Star
0%

5 thoughts on “Implementing ORAchk in Oracle Enterprise Manager 13c

  1. Hi

    I have added the ORAchk in Online Mode too, my Repository is non-RAC, when I start provisioning I get this error:

    ORAchk discovery – Failed.
    orachk did not find the CRS binaries on solothurn from environment.\nPlease set RAT_CRS_HOME to CRS_HOME or GI_HOME in current shell to override and re-run it.\neg export RAT_CRS_HOME=/u01/app/11.2.0/grid

    Do you have any idea? I don’t have CRS etc. up and running.

    Regards from Switzerland
    Martin

Comments are closed.

Next Post

Performance by using patterns in service implementations

Performance in service oriented environments is often an issue. This is usually caused by a combination of infrastructure, configuration and service efficiency. In this blog article I provide several suggestions to improve performance by using patterns in service implementations. The patterns are described globally since implementations can differ across specific […]
%d bloggers like this: