{"id":1765,"date":"2016-10-11T00:01:58","date_gmt":"2016-10-11T05:01:58","guid":{"rendered":"https:\/\/bijoos.com\/oraclenotes\/?p=1765"},"modified":"2026-02-07T15:37:14","modified_gmt":"2026-02-07T21:37:14","slug":"otn-appreciation-day-the-orachk-and-exachk-tools-thanksotn","status":"publish","type":"post","link":"https:\/\/bijoos.com\/oraclenotes\/2016\/1765\/","title":{"rendered":"OTN Appreciation Day: The ORAchk and EXAchk Tools #ThanksOTN"},"content":{"rendered":"<p><em><a href=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/10\/otnlogo.gif?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\" wp-image-1766 alignleft\" src=\"https:\/\/i0.wp.com\/bijoos.com\/oraclenotes\/wp-content\/uploads\/2016\/10\/otnlogo.gif?resize=141%2C76&#038;ssl=1\" alt=\"otnlogo\" width=\"141\" height=\"76\" \/><\/a>Thanks Tim for coming up with this idea! Pretty neat&#8230; And THANK YOU\u00a0OTN!!<\/em><\/p>\n<p>There are quite a few features I like in the Oracle Database, but today I choose ORAchk (and EXAchk). Troubleshooting and diagnostics are\u00a0my favorite area and I was amazed by the enhancements Oracle made in integrating the various diagnostics tools and preserving history. And ORA\/EXAchk is a no-cost\u00a0tool, provided by Oracle, enhanced every quarter with more and more health checks&#8230;<\/p>\n<p>ORAchk and EXAchk tools started as just another configuration verification tool (used to be called RACcheck). ORAchk (for non-Engineered systems) and EXAchk (for engineered systems) grown into a &#8220;product&#8221; from a &#8220;tool&#8221;. This is evident in 12.2, as the documentation from\u00a0a simple <a href=\"https:\/\/support.oracle.com\/epmos\/faces\/DocContentDisplay?id=1268927.2\">MOS note<\/a> grown into a full document <a href=\"http:\/\/docs.oracle.com\/cd\/E68491_01\/index.htm\" target=\"_blank\">User Guide<\/a>.<\/p>\n<p>What&#8217;s cool is that ORAchk and EXAchk can be daemonized to run these checks periodically. The daemon can also purge old reports based on the retention policy you set.\u00a0The most favorite enhancement I like is the ability to compare two reports.\u00a0Oracle ORAchk and Oracle EXAchk automatically compare the two most recent HTML reports and generate a difference report, when run in an automated daemon mode.<\/p>\n<p>To manually compare two reports, orachk (or exachk) can be invoked with the -diff option.<\/p>\n<pre class=\"lang:default decode:true \">$ .\/orachk \u2013diff report1 report2\n\n$ .\/exachk \u2013diff report1 report2<\/pre>\n<p>The comparison report&#8217;s sections are very appropriate.<\/p>\n<ul>\n<li>Difference between report 1 and report 2 (status change of checks)<\/li>\n<li>Unique findings in report 1 (issues that were fixed)<\/li>\n<li>Unique findings in report 2 (new issues after report 1)<\/li>\n<li>Common findings in report 1 and 2 (issues that were not fixed)<\/li>\n<\/ul>\n<p><a href=\"http:\/\/docs.oracle.com\/cd\/E68491_01\/OEXUG\/apex5-managing-oracle-health-check-collection-manager.htm#OEXUG-GUID-C57CBD82-61E3-4985-A021-BA9C07CBADBE\">Oracle Health Check Collections Manager<\/a> is another cool application that comes with these tools, where the ORAchk (and EXAchk) results can be uploaded to an Oracle database APEX workspace for analysis and reporting.\u00a0ORAchk (and EXAchk) can be configured to automatically upload check results to the Oracle Health Check Collections Manager database. Specify the connection string and the password to connect to the database to\u00a0upload collection results. Oracle Health Check Collections Manager stores the connection details in an encrypted wallet.<\/p>\n<p>If you have not run ORAchk recently, it&#8217;s time to download and run the check today. And, don&#8217;t forget to schedule it! Forgot to mention, since\u00a012.1.0.2.5 version you have the ability to Create User Defined Checks too!<\/p>\n<p style=\"text-align: center;\"><a href=\"https:\/\/support.oracle.com\/epmos\/faces\/DocContentDisplay?_afrLoop=314929579778080&amp;id=1268927.2&amp;_afrWindowMode=0&amp;_adf.ctrl-state=1bdkvfckh1_146\">Download ORAchk &#8211; My Oracle Support Note\u00a01268927.2<\/a><\/p>\n<p style=\"text-align: center;\">While you are there, check out TFA (<a href=\"https:\/\/support.oracle.com\/epmos\/faces\/DocContentDisplay?_afrLoop=316039437595437&amp;id=1513912.2&amp;_afrWindowMode=0&amp;_adf.ctrl-state=1bdkvfckh1_255\">Trace File Analyzer: MOS\u00a01513912.2<\/a>) and CHM (<a href=\"https:\/\/support.oracle.com\/epmos\/faces\/DocContentDisplay?_afrLoop=316274973434487&amp;id=1328466.1&amp;_afrWindowMode=0&amp;_adf.ctrl-state=1bdkvfckh1_420\">Cluster Health Monitor: MOS 1328466.1<\/a>) as well!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Thanks Tim for coming up with this idea! Pretty neat&#8230; And THANK YOU\u00a0OTN!! There are quite a few features I like in the Oracle Database, but today I choose ORAchk (and EXAchk). Troubleshooting and diagnostics are\u00a0my favorite area and I was amazed by the enhancements Oracle made in integrating the various diagnostics tools and preserving &#8230; <a title=\"OTN Appreciation Day: The ORAchk and EXAchk Tools #ThanksOTN\" class=\"read-more\" href=\"https:\/\/bijoos.com\/oraclenotes\/2016\/1765\/\" aria-label=\"Read more about OTN Appreciation Day: The ORAchk and EXAchk Tools #ThanksOTN\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[10],"tags":[148],"class_list":["post-1765","post","type-post","status-publish","format-standard","hentry","category-ebs","tag-exadata"],"acf":[],"jetpack_featured_media_url":"","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/1765","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/comments?post=1765"}],"version-history":[{"count":1,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/1765\/revisions"}],"predecessor-version":[{"id":3045,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/1765\/revisions\/3045"}],"wp:attachment":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/media?parent=1765"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/categories?post=1765"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/tags?post=1765"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}