ORAchk Upgrade Readiness Assessment (Doc ID 1457357.1)

In this Document

APPLIES TO:

Oracle Database - Enterprise Edition - Version 10.2.0.4 to 12.2.0.1 [Release 10.2 to 12.2]
Linux x86-64
Oracle Solaris on x86-64 (64-bit)
Oracle Solaris on SPARC (64-bit)
IBM AIX on POWER Systems (64-bit)

PURPOSE

ORAchk is a RAC Configuration Audit tool designed to audit various important configuration settings within a Real Application Clusters (RAC), Oracle Clusterware (CRS), Automatic Storage Management (ASM) and Grid Infrastructure environment. The full functionality of ORAchk is described in Document 1268927.2.

SCOPE

The scope of this document is limited to the ORAchk Upgrade Readiness feature which was introduced in ORAchk Version 2.1.5. The full functionality of ORAchk is described in Document 1268927.2.

Supported Platforms

Linux x86/x86-64* (Enterprise Linux, RedHat and SuSE 9, SuSE 10 & SuSE 11)
Oracle Solaris SPARC
Oracle Solaris x86-64
AIX **
HPUX**

* No planned support for Linux Itanium
** Requires BASH Shell 3.2 or higher to be installed on the system

Supported Oracle Releases

ORAchk Upgrade Readiness supports upgrades to 11.2.0.4 and above (including 11.2.0.4 and 12c) from the following releases:

10gR2
11gR1
11gR2
12cR1
12cR2

DETAILS

The ORAchk (RAC Configuration Audit Tool) Upgrade Readiness Assessment can be used to obtain an automated upgrade specific health check for upgrades to 11.2.0.3, 11.2.0.4 and 12.1.0.1 and 12.2.0.1. The goal of the ORAchk Upgrade Readiness Assessment is to make the process of upgrade planning for Oracle RAC and Oracle Clusterware as smooth as possible by automating many of the manual pre and post checks detailed in various upgrade related documents. The content checked and included encompasses:

Oracle Database Upgrade Guide 11g Release 2 (11.2)
Platform Specific Grid Infrastructure Installation Guides (11.2)
Document 785351.1 Oracle 11gR2 Upgrade Companion
Document 837570.1 Complete Checklist for Manual Upgrades to 11gR2
Document 1363369.1 Things to Consider Before Upgrading to 11.2.0.3 Grid Infrastructure/ASM
Document 810394.1 RAC and Oracle Clusterware Best Practices and Starter Kit (Platform Independent)

Execution Instructions

Note: It is highly recommend that you review Document 1268927.2 as well as the ORAchk Users Guide for a full understanding of ORAchk prior to executing the steps below.

Download ORAchk from Document 1268927.2.
Log in to the system as the Oracle RDBMS software installation owner.
Stage the orachk.zip kit (downloaded in step 1) in its own directory the node on which the tool will be executed.
Unzip orachk.zip kit, leaving the script and driver files together in the same directory.
Validate the permissions for orachk are 755 (-rwxr-xr-x). If the permissions are not currently set to 755, set the permissions on orachk as follows:
$ chmod 755 orachk
During the upgrade planning phase of your pending RAC upgrade, execute ORAchk in pre-upgrade mode and follow the on-screen prompts:
Note: It is HIGHLY recommended that the pre-upgrade checks are executed in the planning phase of the upgrade. This will allow planning and implementation of findings highlighted by ORAchk.
$ ./orachk -u -o pre
Review the HTML report generated by the ORAchk pre-upgrade execution and implement the recommended changes as necessary.
Once you have successfully upgraded (GI and/or RDBMS), execute ORAchk in post-upgrade mode and follow the on-screen prompts:
$ ./orachk -u -o post
Review the HTML report generated by the ORAchk post-upgrade execution and implement the recommended changes as necessary.

What to expect

The target clusterware and database versions are 11.2.0.3, 11.2.0.4, 12.1.0.1 and 12.2.0.1
In pre-upgrade mode the tool will detect all databases registered in the clusterware automatically and present a list of databases on which to perform pre-upgrade checks. If any databases that were already upgraded are selected, the pre-upgrade checks will be skipped for them.
In post-upgrade mode the tool will detect all databases registered in the clusterware automatically and present a list of databases on which to perform post-upgrade checks. If any databases that were not upgraded are selected, the post-upgrade checks will be skipped for them.
In both modes the tool will check the clusterware and OS appropriately.
When the tool completes the user will be referred to an HTML formated report which will contain the findings and links to additional details and information.

Troubleshooting

Refer Document 1268927.2 ORAchk - Health Checks for the Oracle Stack FAQ section.

For Support

If problems are encountered either at runtime or if there are questions about the content of the findings of the tool, please post your issues/questions/concerns to the ORAchk thread within the ORAchk Thread of the Scalability RAC My Oracle Support Community.

REFERENCES

NOTE:837570.1 - Complete Checklist for Manual Upgrade to Oracle Database 11gR2 (11.2)
NOTE:1363369.1 - Things to Consider Before Upgrading to 11.2.0.3/11.2.0.4 Grid Infrastructure/ASM
NOTE:785351.1 - Oracle 11gR2 Upgrade Companion
NOTE:1268927.2 - ORAchk - Health Checks for the Oracle Stack
NOTE:605251.1 - Where To Locate The Oracle RDBMS Installation Guides, Upgrade Guides and Release Notes

All about Databases - Oracle, PostgeSQL, Mysql, Big Data .....

Thursday, May 31, 2018