Monday, August 3, 2015

Oracle Troubleshooting: Gathering orachk

Download ORAchk Oracle Metalink.

ORAchk - Health Checks for the Oracle Stack (Doc ID 1268927.2)


Ideally, download the tool and set it asides as it will extract bunch of files and you do not want to mix up with other existing and unrelated files. The rest really straightforward. 

[oracle@Cloud3 oracle]$ mkdir orachk
[oracle@Cloud3 oracle]$ mv orachk.zip orachk  


[oracle@Cloud3 orachk]$ unzip orachk.zip
Archive:  orachk.zip
  inflating: readme.txt
  inflating: UserGuide.txt
  inflating: rules.dat
  inflating: user_defined_checks.xsd


[oracle@Cloud3 orachk]$  ./orachk
List of running databases
1. orcl
2. None of above

Select databases from list for checking best practices. For multiple databases, select 1 for All or comma separated number like 1,2 etc [1-2][1].orcl
That's it!

No comments:

Post a Comment