Monday, June 16, 2014

ORAchk to check databases (single and RAC)

Oracle ORAchk utility will replace RACchk utility and allow you to check also single instance databases. You can also send notification emails throught it. And schedule automatic check via cron jobs.

Here is quick guide to install and use ORAchk utility:

1. Download from My Oracle Support (you'll need MOS account for this):
Doc ID 1268927.2

NOTE! here you can also find user guide pdf!

2.  Install as oracle user in host you want to check:

      - unzip orachk.zip

3. Set notifications Email and automatic cron checks:
      - ./orachk -set "AUTORUN_SCHEDULE=3 1 * *; NOTIFICATION_EMAIL=<your_email_address>"

NOTE! Outlook (+ virus scanner) may not work proberly with these notification emails. So you might need some testing to get this work with it.
cron parameters in this set are (left to right):  hour (0 - 23), day of month (1 - 31), month (1 - 12), day of week (0 - 6) (0 to 6 are Sunday to Saturday)

4. Check settings:
./orachk -get all

5. Start daemon:
./orachk -d start

NOTE! with RAC this ask's root pwd for audit checks

6.  Stop daemon:
./orachk -d stop


7. To see all parameters:
./orachk -help

NOTE! you can also set auto restart. So script will be started automatically on node restarts.