Thursday, May 18, 2017

What is Orachk tool?

I come across an issue in Oracle Database environment and none of the team aware of what is Orachk and how to use it.

ORAchk tool:
ORAchk tool perform proactive health checks for Oracle software stack and this tool replaces RACcheck. Using this tool you can scan problems with oracle products

· Standalone Oracle Database
· Oracle Grid Infrastructure
· Oracle Golden Gate
· Upgrade Readiness Validations
· Oracle Real Application Clusters
· Maximum Availability Architecture (MAA) Validation

It is always  recommended to run this tool before upgrade.

ORAchk tool has below features

· Proactively scans for problems across the different layers and will not send any config data
· Provides a single dashboard view for your enterprise environment.
· Investigation and analyzing the issue makes simple and provides a report with risks
· You can configure to send email notifications when it detects problems
· Its free of Cost

How to run:

1. Download the orachk.zip and unzip

$unzip orachk.zip
Archive: orachk.zip
inflating: CollectionManager_App.sql
inflating: UserGuide.txt
inflating: orachk
creating: .cgrep/
inflating: .cgrep/init.tmpl
inflating: .cgrep/checkDiskFGMapping.sh
inflating: .cgrep/exalogic_zfs_checks_el_extensive.aksh
inflating: .cgrep/scnhealthcheck.sql
inflating: .cgrep/merge_collections.pl

2. Run the tool

$ ./orachk
This computer is for [S]ingle instance database or part of a [C]luster to run RAC database [S|C] [C]:S

List of running databases
1.ORCL1
2.TSTDB
3.MRST
…..

21. ROCL
22. All of above
23. None of above

Select databases from list for checking best practices. For multiple databases, select 32 for All or comma separated number like 1,2 etc [1-23][22].22

Searching out ORACLE_HOME for selected databases.
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Checking Status of Oracle Software Stack - Clusterware, ASM, RDBMS
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
-------------------------------------------------------------------------------------------------------
                                                 Oracle Stack Status
-------------------------------------------------------------------------------------------------------
Host Name  CRS Installed  ASM HOME       RDBMS Installed  CRS UP    ASM UP    RDBMS UP  DB Instance Name
-------------------------------------------------------------------------------------------------------
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

Copying plug-ins
. .  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
. .. . . .
*** Checking Best Practice Recommendations (PASS/WARNING/FAIL) ***
Collections and audit checks log file is
/tmp/oracheck/orachk_server1_ORCL1_052615_194626/log/orachk.log
Checking for prompts in /u01/home/oracle/.profile on server1 for oracle user...
=============================================================
                    Node name - server1
=============================================================
Collecting - Database Parameters for ORCL1database
Collecting - Database Parameters for TSTDB database
Collecting - Database Parameters for MRST database
……..
============
Best Practice checking completed.Checking recommended patches on server1.
---------------------------------------------------------------------------------
Collecting patch inventory on ORACLE_HOME /oracle/product/10.2.0/db_1
Collecting patch inventory on ORACLE_HOME /oracle/product/11.2.0.4/dbhome_1
Collecting patch inventory on ORACLE_HOME /oracle/product/11.2.0/dbhome_1
Collecting patch inventory on ORACLE_HOME /oracle/product/12.1.0.2/dbhome_1
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------
1 Recommended RDBMS patches for 102040 from /oracle/product/10.2.0/db_1 on server1
---------------------------------------------------------------------------------
Patch#   RDBMS    ASM     type                Patch-Description
---------------------------------------------------------------------------------
12879929  no             merge               DATABASE PATCH SET UPDATE 10.2.0.4.11 (PRE-REQ 10.2.0.4.4|INCLUDES CPUJAN2012)
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------
1 Recommended RDBMS patches for 112040 from /oracle/product/11.2.0.4/dbhome_1 on server1
---------------------------------------------------------------------------------
Patch#   RDBMS    ASM     type                Patch-Description
---------------------------------------------------------------------------------
19769489  no             merge               DATABASE PATCH SET UPDATE 11.2.0.4.5 (INCLUDES CPUJAN2015)
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------
1 Recommended RDBMS patches for 112010 from /oracle/product/11.2.0/dbhome_1 on server1
---------------------------------------------------------------------------------
Patch#   RDBMS    ASM     type                Patch-Description
---------------------------------------------------------------------------------
12419378  no             merge               DATABASE PSU 11.2.0.1.6 (INCLUDES CPUJUL2011)
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------
1 Recommended RDBMS patches for 121020 from /oracle/product/12.1.0.2/dbhome_1 on server1
---------------------------------------------------------------------------------
Patch#   RDBMS    ASM     type                Patch-Description
---------------------------------------------------------------------------------
19769480  no             merge               DATABASE PATCH SET UPDATE 12.1.0.2.2 (JAN2015)
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------

---------------------------------------------------------------------------------
              RDBMS homes patches summary report
---------------------------------------------------------------------------------
Total patches  Applied on RDBMS Applied on ASM ORACLE_HOME
---------------------------------------------------------------------------------
 1              0              0                /oracle/product/10.2.0/db_1
 1              0              0                /oracle/product/11.2.0.4/dbhome_1
 1              0              0                /oracle/product/11.2.0/dbhome_1
 1              0              0                /oracle/product/12.1.0.2/dbhome_1
---------------------------------------------------------------------------------
---------------------------------------------------------------------------------
Detailed report (html) - /tmp/oracheck/orachk_server1_ORCL1_052615_194626/orachk_server1_ORCL1_052615_194626.html
UPLOAD(if required) /tmp/oracheck/orachk_server1_ORCL1_052615_194626.zip
/oracle:DBA>


Regards,
Satishbabu Gunukula, Oracle ACE

8 comments: