{"id":59835,"date":"2020-09-02T14:19:27","date_gmt":"2020-09-02T13:19:27","guid":{"rendered":"http:\/\/content.n4stack.io\/?p=59835"},"modified":"2021-04-20T14:18:41","modified_gmt":"2021-04-20T13:18:41","slug":"installing-oracle-ahf-running-orachk-linux-windows","status":"publish","type":"post","link":"http:\/\/content.n4stack.io\/2020\/09\/02\/installing-oracle-ahf-running-orachk-linux-windows\/","title":{"rendered":"Installing Oracle AHF and Running ORAchk on Linux and Windows"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; fullwidth=&#8221;on&#8221; _builder_version=&#8221;4.9.1&#8243; _module_preset=&#8221;default&#8221;][et_pb_fullwidth_post_title categories=&#8221;off&#8221; comments=&#8221;off&#8221; featured_image=&#8221;off&#8221; text_color=&#8221;light&#8221; _builder_version=&#8221;4.9.1&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#3d3d3d&#8221; custom_padding=&#8221;200px||100px||false|false&#8221;][\/et_pb_fullwidth_post_title][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; _builder_version=&#8221;4.0.11&#8243;][et_pb_row _builder_version=&#8221;4.6.0&#8243;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.0.11&#8243;][et_pb_text admin_label=&#8221;Intro and table of contents&#8221; module_id=&#8221;Intro &#038; Table of Contents&#8221; _builder_version=&#8221;4.6.0&#8243; text_font=&#8221;Roboto|300|||||||&#8221; text_font_size=&#8221;17px&#8221; header_text_color=&#8221;#e05206&#8243; header_3_text_color=&#8221;#e05206&#8243; header_5_text_color=&#8221;#e05206&#8243;]<\/p>\n<p>Is your Oracle database in need of some TLC? Then you need ORAchk (Oracle Check). The utility examines an Oracle system\u2019s configuration looking for areas that need improvement and generates a risk report that you can then use to improve the health status of your database. ORAchk is provided as part of Oracle\u2019s <a href=\"https:\/\/www.oracle.com\/uk\/database\/technologies\/rac\/ahf.html\" target=\"_blank\" rel=\"noopener noreferrer\">Autonomous Health Framework (AHF)<\/a> toolkit.<\/p>\n<p>I see a lot of customers looking to take advantage of the benefits that ORAchk brings so I thought I\u2019d write a step-by-step guide on how to install Oracle AHF, and run ORAchk, on Linux and Windows environments.<\/p>\n<ol>\n<li><a href=\"#1\">Pre-requisites<\/a><\/li>\n<li>Oracle AHF and ORAchk on Linux\n<ul>\n<li><a href=\"#2\">Installation<\/a><\/li>\n<li><a href=\"#3\">Running ORAchk on non-RAC databases<\/a><\/li>\n<li><a href=\"#4\">Running ORAchk On RAC databases<\/a><\/li>\n<li><a href=\"#5\">Removal<\/a><\/li>\n<\/ul>\n<\/li>\n<li>Oracle AHF and ORAchk on Windows\n<ul>\n<li><a href=\"#6\">Installation<\/a><\/li>\n<li><a href=\"#7\">Use<\/a><\/li>\n<li><a href=\"#8\">Removal<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<p>[\/et_pb_text][et_pb_text admin_label=&#8221;Pre-requisites&#8221; module_id=&#8221;1&#8243; _builder_version=&#8221;4.6.0&#8243; text_font=&#8221;Roboto|300|||||||&#8221; text_font_size=&#8221;17px&#8221; header_text_color=&#8221;#e05206&#8243; header_3_text_color=&#8221;#e05206&#8243;]<\/p>\n<h3>Pre-requisites<\/h3>\n<p>Before you begin the installation there are some pre-requisites to installing Oracle AHF and running ORAchk. I\u2019ve outlined the key pre-requisites below:<\/p>\n<h4>\u00a0<\/h4>\n<h5>Linux<\/h5>\n<ul>\n<li>Oracle AHF should be installed as root to obtain the fullest capabilities. If you are unable to install as root then Oracle AHF should be installed as the Oracle Home User.<\/li>\n<li>Oracle AHF should be installed to a filesystem with at least 5GB of free diskspace.<\/li>\n<li>Perl version 5.10 or later is required to install Oracle AHF.<\/li>\n<\/ul>\n<h5>Windows<\/h5>\n<ul>\n<li>Oracle AHF should be installed as a user with local administrative privileges.<\/li>\n<li>Oracle AHF should be installed to a disk with at least 5GB of free diskspace.<\/li>\n<li>Perl version 5.10 or later is required to install Oracle AHF (note that a later version of Perl is usually to be found installed in the %ORACLE_HOME%\\perl directory)<\/li>\n<\/ul>\n<p>[\/et_pb_text][et_pb_text admin_label=&#8221;Installing Oracle AHF on Linux&#8221; module_id=&#8221;2&#8243; _builder_version=&#8221;4.6.0&#8243; text_font=&#8221;Roboto|300|||||||&#8221; text_font_size=&#8221;17px&#8221; header_text_color=&#8221;#e05206&#8243; header_3_text_color=&#8221;#e05206&#8243; header_5_text_color=&#8221;#e05206&#8243;]<\/p>\n<h3>Installing Oracle AHF on Linux<\/h3>\n<p>So you\u2019ve checked the pre-requisites and you\u2019re good to begin the installation. The latest version of Oracle AHF can be downloaded as a .zip file from Oracle Support via the following link:<\/p>\n<p><a href=\"https:\/\/support.oracle.com\/epmos\/faces\/DocContentDisplay?id=2550798.1\" target=\"_blank\" rel=\"noopener noreferrer\">Oracle Autonomous Health Framework (AHF) \u2013 Including TFA and ORAchk\/EXAchk (Doc ID 2550798.1)<\/a><\/p>\n<p>You will need to ensure that the GA Release of TFA &amp; ORAchk\/EXAchk for Linux is downloaded.<\/p>\n<p>Once downloaded, transfer the .zip file (using e.g., FileZilla, WinSCP or pscp) to the database host as the root user and unzip the file. Ensure that there is at least 5GB of free diskspace on the filesystem where the Oracle AHF will be installed.<\/p>\n<p>In the following example the AHF-LINUX_v20.1.1.zip file has been transferred to the \/opt\/oracle\/media\/ahf directory:<\/p>\n<p>[\/et_pb_text][et_pb_text admin_label=&#8221;Code 1&#8243; _builder_version=&#8221;4.6.0&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#f2f2f2&#8243;]<\/p>\n<pre><code>\n[root@dbhost]# pwd \n\/opt\/oracle\/media\/ahf \n \nCheck available diskspace \n[root@dbhost]# df -hP . \nFilesystem            Size  Used Avail Use% Mounted on \n\/dev\/mapper\/ol-root   100G   42G   58G  42% \/ \n \n[root@dbhost]# ls -lh \ntotal 349M \n-rw-r--r--. 1 root root 349M Mar 19 13:06 AHF-LINUX_v20.1.1.zip \n \nUnzip the AHF-LINUX zip file \n[root@dbhost]# unzip AHF-LINUX_v20.1.1.zip \nArchive:  AHF-LINUX_v20.1.1.zip \n  inflating: README.txt \n  inflating: ahf_setup \n \n[root@dbhost]# ls -lh \ntotal 703M \n-rw-r--r--. 1 root root 349M Mar 19 13:06 AHF-LINUX_v20.1.1.zip \n-rwxr-xr-x. 1 root root 355M Mar 17 20:29 ahf_setup \n-rw-r--r--. 1 root root  832 Mar 17 20:33 README.txt \n<\/code><\/pre>\n<p>[\/et_pb_text][et_pb_text admin_label=&#8221;Text&#8221; _builder_version=&#8221;4.6.0&#8243; _module_preset=&#8221;default&#8221; text_font=&#8221;Roboto|300|||||||&#8221;]<span data-contrast=\"auto\">Check that <\/span><span data-contrast=\"auto\">perl<\/span><span data-contrast=\"auto\"> v5.10 or later is installed on the server. In this example <\/span><span data-contrast=\"auto\">perl<\/span><span data-contrast=\"auto\"> v5.16 is installed:<\/span><span data-ccp-props=\"{&quot;201341983&quot;:0,&quot;335559739&quot;:160,&quot;335559740&quot;:259}\">\u00a0<\/span><br \/>\n[\/et_pb_text][et_pb_text admin_label=&#8221;Code 2&#8243; _builder_version=&#8221;4.6.0&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#f2f2f2&#8243;]<\/p>\n<pre><code>\r\n[root@dbhost]# yum list installed | grep -i perl.x86_64 \r\nperl.x86_64                             4:5.16.3-294.el7_6 \r\n<\/code><\/pre>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.6.0&#8243; _module_preset=&#8221;default&#8221; text_font=&#8221;Roboto|300|||||||&#8221;]<\/p>\n<p>If perl is not installed or is an earlier version, use &#8216;yum install perl.x86_64&#8217; to install.<\/p>\n<p>To install Oracle AHF we run the ahf_setup installer with the -extract parameter. We also specify the -notfasetup parameter to avoid enabling the Oracle Trace File Analyser component of Oracle AHF.<\/p>\n<p>By default Oracle AHF will be installed to the \/opt\/oracle.ahf directory.<\/p>\n<p>[\/et_pb_text][et_pb_text admin_label=&#8221;Code 3&#8243; _builder_version=&#8221;4.6.0&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#f2f2f2&#8243;]<\/p>\n<pre><code>\r\n[root@dbhost]# pwd \r\n\/opt\/oracle\/media\/ahf \r\n \r\n[root@dbhost]# .\/ahf_setup -extract -notfasetup \r\nAHF Installer for Platform Linux Architecture x86_64 \r\nAHF Installation Log : \/tmp\/ahf_install_2020_03_25-18_45_10.log \r\nStarting Autonomous Health Framework (AHF) Installation \r\nAHF Version: 20.1.1.0.0 Build Date: 202003170925 \r\nDefault AHF Location : \/opt\/oracle.ahf \r\nDo you want to install AHF at [\/opt\/oracle.ahf] ? [Y]|N : Y \r\nAHF Location : \/opt\/oracle.ahf \r\nAHF Data Directory : \/opt\/oracle.ahf\/data \r\nExtracting AHF to \/opt\/oracle.ahf \r\nAHF is deployed at \/opt\/oracle.ahf \r\nORAchk is available at \/opt\/oracle.ahf\/bin\/orachk \r\nAHF binaries are available in \/opt\/oracle.ahf\/bin \r\nAHF is successfully installed \r\n<\/code><\/pre>\n<p>[\/et_pb_text][et_pb_text admin_label=&#8221;Running ORAchk on Linux on non-RAC Databases&#8221; module_id=&#8221;3&#8243; _builder_version=&#8221;4.6.0&#8243; _module_preset=&#8221;default&#8221; text_font=&#8221;|300|||||||&#8221; header_3_text_color=&#8221;#e05206&#8243;]<\/p>\n<h3>Running ORAchk on Linux on non-RAC Databases<\/h3>\n<p>Now that Oracle AHF has been installed we can run ORAchk from the \u2018bin\u2019 directory below the Oracle AHF installation directory:<\/p>\n<p>[\/et_pb_text][et_pb_text admin_label=&#8221;Code 4&#8243; _builder_version=&#8221;4.6.0&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#f2f2f2&#8243;]<\/p>\n<pre><code>\r\n[root@dbhost]# cd \/opt\/oracle.ahf\/bin\r\n[root@dbhost]# .\/orachk\r\nNote the following message will be seen if Oracle ASM storage is utilised\r\nClusterware is running from \/u01\/app\/18.0.0\/grid. Is this the correct Clusterware Home?[y\/n] y\r\n\r\nList of running databases\r\nIf multiple databases are running on the host, an 'All of above' option will be given and should be selected\r\n1. ORADB1\r\n2. None of above\r\n\r\nSelect databases from list for checking best practices. For multiple databases, select 1 for All or comma separated number like 1,2 etc. 1\r\n\r\nSearching out ORACLE_HOME for selected databases...\r\nChecking Status of Oracle Software Stack - Clusterware, ASM, RDBMS...\r\n------------------------------------------------------------------------------------------------------------------\r\nOracle Stack Status\r\n------------------------------------------------------------------------------------------------------------------\r\nHost Name CRS Installed ASM HOME RDBMS Installed CRS UP ASM UP RDBMS UP DB Instance Name\r\n------------------------------------------------------------------------------------------------------------------\r\ndbhost Yes Yes Yes Yes Yes Yes ORADB1\r\n-----------------------------------------------------------------------------------------------------------------\r\n<\/code><\/pre>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.6.0&#8243; _module_preset=&#8221;default&#8221; text_font=&#8221;Roboto|300|||||||&#8221;]At this point the following warning regarding an old or invalid Cluster Verification Utility pack might be seen. It is safe to proceed without downloading the latest version of the pack: [\/et_pb_text][et_pb_text admin_label=&#8221;Code 5&#8243; _builder_version=&#8221;4.6.0&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#f2f2f2&#8243;]<\/p>\n<pre><code>\r\nCopying plug-ins...\r\n\r\nEither Cluster Verification Utility pack (cvupack) does not exist at \/opt\/oracle.ahf\/common\/cvu or it is an old or invalid cvupack\r\n\r\nChecking Cluster Verification Utility (CVU) version at CRS Home - \/u01\/app\/18.0.0\/gri\r\n\r\nThis version of Cluster Verification Utility (CVU) was released on 26-Jun-2018 and it is older than 180 days. It is highly recommended that you download the latest version of CVU from MOS patch 30166242 to ensure the highest level of accuracy of the data contained within the report\r\n\r\nDo you want to download latest version of Cluster Verification Utility (CVU) from my oracle support? [y\/n] [y] n\r\n\r\nRunning older version of Cluster Verification Utility (CVU) from CRS Home - \/u01\/app\/18.0.0\/grid\r\n<\/code><\/pre>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.6.0&#8243; _module_preset=&#8221;default&#8221; text_font=&#8221;|300|||||||&#8221;]ORAchk now performs the audit checks. The process can take up to 15 minutes (sometimes longer). [\/et_pb_text][et_pb_text admin_label=&#8221;Code 6&#8243; _builder_version=&#8221;4.6.0&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#f2f2f2&#8243;]<\/p>\n<pre><code>\nCollections and audit checks log file is \n\/opt\/oracle.ahf\/data\/dbhost\/orachk\/orachk_dbhost_oradb1_032520_190714\/log\/orachk.log \n \n============================================================ \n               Node name - dbhost \n============================================================ \n \n Collecting - Database Parameters for db11g database \n Collecting - Database Undocumented Parameters for db11g database \n Collecting - List of active logon and logoff triggers for db11g database \n\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7   Collecting - ORAchk Daemon\/Scheduler configuration   Collecting - Root user limits   Collecting - Verify no database server kernel out of memory errors    Data collections completed. Checking best practices on dbhost.  ------------------------------------------------------------   WARNING =&gt;  There are some application objects with STALE statistics for oradb1 \n INFO =&gt;     Most recent ADR incidents for \/u01\/app\/oracle\/product\/11.2.0.4\/db_1 \n INFO =&gt;     Oracle GoldenGate failure prevention best practices \n\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7     INFO =&gt;     Consider setting optimizer related parameters to their default values for oradb1 \n WARNING =&gt;  Flashback on PRIMARY is not configured for db11g \n INFO =&gt;     Database failure prevention best practices \nBest Practice checking completed. Check recommended patches on dbhost...\n<\/code><\/pre>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.6.0&#8243; _module_preset=&#8221;default&#8221; text_font=&#8221;|300|||||||&#8221;]ORAchk\u00a0then collects data on applied and recommended patches and generates the html report:[\/et_pb_text][et_pb_text admin_label=&#8221;Code 7&#8243; _builder_version=&#8221;4.6.0&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#f2f2f2&#8243;]<\/p>\n<pre><code>\n----------------------------------------------------------------------------------------------------- \n          Collecting patch inventory on ORACLE_HOME \/u01\/app\/oracle\/product\/11.2.0.4\/db_1 \n----------------------------------------------------------------------------------------------------- \n----------------------------------------------------------------------------------------------------- \n1 Recommended RDBMS patches for 112040 from \/u01\/app\/oracle\/product\/11.2.0.4\/db_1 on dbhost \n----------------------------------------------------------------------------------------------------- \nPatch#       RDBMS    ASM     type                Patch-Description \n----------------------------------------------------------------------------------------------------- \n30670774     no               merge               DATABASE PATCH SET UPDATE 11.2.0.4.200414 \n-----------------------------------------------------------------------------------------------------\n----------------------------------------------------------------------------------------------------- \n                                  RDBMS homes patches summary report \n----------------------------------------------------------------------------------------------------- \nTotal patches       Applied on RDBMS   Applied on ASM     ORACLE_HOME \n----------------------------------------------------------------------------------------------------- \n1                   1                  0                  \/u01\/app\/oracle\/product\/11.2.0.4\/db_1 \n----------------------------------------------------------------------------------------------------- \n----------------------------------------------------------------------------------------------------- \nDetailed report (html) -  \/opt\/oracle.ahf\/data\/dbhost\/orachk\/orachk_dbhost_oradb1_062220_091748\/\u21b5 \norachk_dbhost_oradb1_032520_190714.html \nUPLOAD [if required] - \/opt\/oracle.ahf\/data\/dbhost\/orachk\/orachk_dbhost_oradb1_032520_190714.zip\n<\/code><\/pre>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.6.0&#8243; _module_preset=&#8221;default&#8221; text_font=&#8221;|300|||||||&#8221;]Once complete, transfer the html report locally and open the report in a browser.[\/et_pb_text][et_pb_text admin_label=&#8221;Running ORAchk on Linux on RAC Databases&#8221; module_id=&#8221;4&#8243; _builder_version=&#8221;4.6.0&#8243; _module_preset=&#8221;default&#8221; text_font=&#8221;|300|||||||&#8221; header_3_text_color=&#8221;#e05206&#8243;]<\/p>\n<h3>Running ORAchk on Linux on RAC Databases<\/h3>\n<p>There are 3 methods of running ORAchk in a clustered database environment:<\/p>\n<p><strong>Option 1:<\/strong> If password-less SSH user equivalency for root has been setup (allowing the root user to SSH to the remote nodes without having to enter a password) then ORAchk can automatically execute the checks on the remote nodes.<\/p>\n<p><strong>Option 2:<\/strong> If password-less SSH user equivalency for root has not been setup then the root password for the remote nodes can be specified at the time of running ORAchk. Temporary password-less SSH user equivalency will be configured for the duration of ORAchk\u2019s execution.<\/p>\n<p><strong>Option 3:<\/strong> The ORAchk command-line option &#8211; localonly can be used to run ORAchk on the local node only. If this option is chosen then Oracle AHF should be installed on all cluster nodes and ORAchk should be run individually on each node<\/p>\n<p>Check to see if password-less SSH user equivalency for root has already been set up:<\/p>\n<p>[\/et_pb_text][et_pb_text admin_label=&#8221;Code 8&#8243; _builder_version=&#8221;4.6.0&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#f2f2f2&#8243;]<\/p>\n<pre><code>\nExample where password-less SSH user equivalency has not been setup \n\n[root@dbhostrac1]# ssh dbhostrac2 \n\nroot@dbhost2\u2019s password: ***********  \/* Note \u2013 if we are prompted to enter a password here then equivalency \n                                         does not exist. In this case we will need to manually enter root\u2019s \n                                         password when running ORAchk *\/ \n\nExample where password-less SSH user equivalency has been setup \n\n[root@dbhostrac1]# ssh dbhostrac2 \n\nLast login: Wed Mar 25 16:35:50 2020  \/* Note \u2013 if we are not prompted to enter a password here then  \n                                         equivalency exists and ORAchk can automatically use ssh to execute \n                                         checks on the remote nodes *\/ \n\n<\/code><\/pre>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.6.0&#8243; _module_preset=&#8221;default&#8221; text_font=&#8221;|300|||||||&#8221;]As before, ORAchk is run from the \u2018bin\u2019 directory below the Oracle AHF installation directory. In the following example password-less SSH user equivalency for root has been setup (option 1 above) [\/et_pb_text][et_pb_text admin_label=&#8221;Code 9&#8243; _builder_version=&#8221;4.6.0&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#f2f2f2&#8243;]<\/p>\n<pre><code>\n[root@dbhostrac1]# cd \/opt\/oracle.ahf\/bin \n\n[root@ dbhostrac1]# .\/orachk \n\nClusterware is running from \/u01\/app\/18.0.0\/grid. Is this the correct Clusterware Home?[y\/n] y \n\nChecking ssh user equivalency settings on all nodes in cluster for root \n\nNode dbhostrac2 is configured for ssh user equivalency for root user \n\nSearching for running database... \nList of running databases registered in OCR  \n\n1. DBRAC       \n\n2. None of above \n\nSelect databases from list for checking best practices. For multiple databases, select 1 for All or comma separated number like 1,2 etc. 1 \n\nChecking Status of Oracle Software Stack - Clusterware, ASM, RDBMS... \n------------------------------------------------------------------------------------------------------------------ \n                                            Oracle Stack Status \n------------------------------------------------------------------------------------------------------------------ \nHost Name CRS Installed ASM HOME RDBMS Installed CRS UP ASM UP RDBMS UP DB Instance Name\n------------------------------------------------------------------------------------------------------------------\ndbhostrac1 Yes Yes Yes Yes Yes Yes DBRAC1\ndbhostrac2 Yes Yes Yes Yes Yes Yes DBRAC2\n----------------------------------------------------------------------------------------------------------------\n<\/code><\/pre[\/et_pb_text][et_pb_text _builder_version=\"4.6.0\" _module_preset=\"default\" text_font=\"|300|||||||\"]At this point we may see the Cluster Verification Utility pack version warning as described earlier. It is safe to proceed without downloading the latest version of the pack.\n\nORAchk proceeds to run the audit checks and executes in the background on the remote node: [\/et_pb_text][et_pb_text admin_label=\"Code 10\" _builder_version=\"4.6.0\" _module_preset=\"default\" background_color=\"#f2f2f2\"]<pre><code>\n*** Checking Best Practice Recommendations ( Pass \/ Warning \/ Fail ) *** \n\nCollections and audit checks log file is \n\n\/opt\/oracle.ahf\/data\/dbhostrac1\/orachk\/orachk_dbhostrac1_dbrac_032520_185210\/log\/orachk.log \n\nStarting to run orachk in background on dbhostrac2 \n\n============================================================ \n              Node name \u2013 dbhostrac1 \n============================================================ \n Collecting - ASM Disk Groups \n\n Collecting - ASM Disk I\/O stats \n\n Collecting - ASM Diskgroup Attributes \n\n\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7 Collecting - Table of file system defaults Collecting - Voting disks (clusterware) Collecting - number of semaphore operations per semop system call Data collections completed. Checking best practices on dbhostrac1. ------------------------------------------------------------------ INFO =&gt;    Important Automatic Storage Management (ASM) Notes and Technical White Papers \n\n INFO =&gt;    Oracle Data Pump Best practices \n\n WARNING =&gt; Linux swap configuration does not meet recommendations \n\n\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7 INFO =&gt;     Oracle recovery manager (RMAN) best practices \n\n CRITICAL =&gt; Linux transparent huge pages are enabled \n\n WARNING =&gt;  vm.min_free_kbytes should be set as recommended. \n\nBest Practice checking completed. Checking recommended patches on dbhostrac1 \n---------------------------------------------------------------------------- \nCollecting patch inventory on CRS_HOME \/u01\/app\/18.0.0\/grid \n\nCollecting patch inventory on ASM_HOME \/u01\/app\/18.0.0\/grid \n\nCollecting patch inventory on ORACLE_HOME \/u01\/app\/oracle\/product\/18.0.0\/db_1 \n------------------------------------------------------------------------------------------------------------------ \n1 Recommended CRS patches for 180000 from \/u01\/app\/18.0.0\/grid on dbhostrac1 \n------------------------------------------------------------------------------------------------------------------ \nPatch#   CRS  ASM  RDBMS_HOME                           Patch-Description                             \n------------------------------------------------------------------------------------------------------------------ \n28655963 yes  yes  \/u01\/app\/oracle\/product\/18.0.0\/db_1  DBWLM Release Update 18.4.0.0.181016                                           \n\n30869417 no   no   \/u01\/app\/oracle\/product\/18.0.0\/db_1  ACFS Release Update 18.10.0.0.200414                                           \n\n30872794 no   no   \/u01\/app\/oracle\/product\/18.0.0\/db_1  Database Release Update 18.10.0.0.200414                                       \n\n30882568 no   no   \/u01\/app\/oracle\/product\/18.0.0\/db_1  OCW Release Update 18.10.0.0.200414                                            \n\n30888855 no   no   \/u01\/app\/oracle\/product\/18.0.0\/db_1  Tomcat Release Update 18.0.0.0.0                                               \n------------------------------------------------------------------------------------------------------------------ \n1 Recommended RDBMS patches for 180000 from \/u01\/app\/oracle\/product\/18.0.0\/db_1 on dbhostrac1 \n\n\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7 \n------------------------------------------------------------------------------------------------------------------ \n              Clusterware patches summary report \n------------------------------------------------------------------------------------------------------------------ \n\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7 \n------------------------------------------------------------------------------------------------------------------ \n              RDBMS homes patches summary report \n------------------------------------------------------------------------------------------------------------------ \n<\/code><\/pre>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.6.0&#8243; _module_preset=&#8221;default&#8221; text_font=&#8221;|300|||||||&#8221;]The results of running ORAchk on the remote RAC nodes are then copied locally and the final html report is generated: [\/et_pb_text][et_pb_text admin_label=&#8221;Code 11&#8243; _builder_version=&#8221;4.6.0&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#f2f2f2&#8243;]<\/p>\n<pre><code>\n============================================================ \n              Node name \u2013 dbhostrac2 \n============================================================ \n\n Collecting - \/proc\/cmdline \n\n Collecting - \/proc\/modules \n\n Collecting - CPU Information \n\n\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7 Collecting - root time zone check Collecting - slabinfo Collecting - umask setting for GI owner Data collections completed. Checking best practices on dbhostrac2. ------------------------------------------------------------ WARNING =&gt;  Linux swap configuration does not meet recommendation \n\n FAIL =&gt;     ASM Audit file destination file count &gt; 100,000 \n\n INFO =&gt;     $CRS_HOME\/log\/hostname\/client directory has too many older log files. \n\n\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7 WARNING =&gt;  NIC bonding is not configured for interconnect \n\n WARNING =&gt;  NIC bonding is NOT configured for public network (VIP) \n\n CRITICAL =&gt; Operating system hugepages count does not satisfy total SGA requirements \n\nBest Practice checking completed. Checking recommended patches on dbhostrac2 \n-------------------------------------------------------------------------------- \n\nCollecting patch inventory on CRS_HOME \/u01\/app\/18.0.0\/grid \n\nCollecting patch inventory on ASM_HOME \/u01\/app\/18.0.0\/grid \n\nCollecting patch inventory on ORACLE_HOME \/u01\/app\/oracle\/product\/18.0.0\/db_1 \n------------------------------------------------------------------------------------------------------------------ \n1 Recommended CRS patches for 180000 from \/u01\/app\/18.0.0\/grid on dbhostrac2 \n------------------------------------------------------------------------------------------------------------------ \nPatch#   CRS  ASM  RDBMS_HOME                           Patch-Description                             \n------------------------------------------------------------------------------------------------------------------ \n\n28655963 yes  yes  \/u01\/app\/oracle\/product\/18.0.0\/db_1  DBWLM Release Update 18.4.0.0.181016                                           \n\n30869417 no   no   \/u01\/app\/oracle\/product\/18.0.0\/db_1  ACFS Release Update 18.10.0.0.200414                                           \n\n30872794 no   no   \/u01\/app\/oracle\/product\/18.0.0\/db_1  Database Release Update 18.10.0.0.200414                                       \n\n30882568 no   no   \/u01\/app\/oracle\/product\/18.0.0\/db_1  OCW Release Update 18.10.0.0.200414                                            \n\n30888855 no   no   \/u01\/app\/oracle\/product\/18.0.0\/db_1  Tomcat Release Update 18.0.0.0.0                                               \n------------------------------------------------------------------------------------------------------------------ \n1 Recommended RDBMS patches for 180000 from \/u01\/app\/oracle\/product\/18.0.0\/db_1 on dbhostrac2 \n\n\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7 \n------------------------------------------------------------------------------------------------------------------ \n              Clusterware patches summary report\n------------------------------------------------------------------------------------------------------------------ \n\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7 \n------------------------------------------------------------------------------------------------------------------ \n              RDBMS homes patches summary report \n------------------------------------------------------------------------------------------------------------------ \n\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7 ------------------------------------------------------------------------------------------------------------------ CLUSTERWIDE CHECKS ------------------------------------------------------------ WARNING =&gt; Private interconnect interface names are NOT the  same across cluster \n------------------------------------------------------------------------------------------------------------------ \nDetailed report (html) -  \/opt\/oracle.ahf\/data\/dbhostrac1\/orachk\/orachk_dbhostrac1_DBRAC_061920_174923\/\u21b5 \norachk_dbhostrac1_DBRAC_061920_174923.html \n\nUPLOAD [if required] - \/opt\/oracle.ahf\/data\/dbhostrac1\/orachk\/orachk_dbhostrac1_DBRAC_061920_174923.zip\n<\/code><\/pre>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.6.0&#8243; _module_preset=&#8221;default&#8221; text_font=&#8221;|300|||||||&#8221;]Again, transfer the html report locally and open the report in a browser.[\/et_pb_text][et_pb_text admin_label=&#8221;Removing Oracle AHF from Linux&#8221; module_id=&#8221;5&#8243; _builder_version=&#8221;4.6.0&#8243; _module_preset=&#8221;default&#8221; text_font=&#8221;|300|||||||&#8221; header_3_text_color=&#8221;#e05206&#8243;]<\/p>\n<h3>Removing Oracle AHF from Linux<\/h3>\n<p>If Oracle AHF is no longer required it can be uninstalled by running the tfactl script as root with the &#8216;uninstall&#8217; parameter:[\/et_pb_text][et_pb_text admin_label=&#8221;Code 12&#8243; _builder_version=&#8221;4.6.0&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#f2f2f2&#8243;]<\/p>\n<pre><code>\n[root@dbhost]# cd \/opt\/oracle.ahf\/tfa\/bin \n\n[root@dbhost]# .\/tfactl uninstall \n\nStarting AHF Uninstall \n\nNOTE : Uninstalling does not return all the space used by the AHF repository \n\nUnable to determine host list from TFA. So running local AHF uninstall. \n\n \n\nAHF will be uninstalled on: dbhost \n\n \n\nDo you want to continue with AHF uninstall ? [Y]|N : \n\n \n\nStopping AHF service on local node dbhost... \n\nSleeping for 10 seconds... \n\n \n\nStopping TFA Support Tools... \n\n \n\nRemoving AHF setup on dbhost: \n\nRemoving \/opt\/oracle.ahf\/jre \n\nRemoving \/opt\/oracle.ahf\/common \n\nRemoving \/opt\/oracle.ahf\/bin \n\nRemoving \/opt\/oracle.ahf\/python \n\nRemoving \/opt\/oracle.ahf\/analyzer \n\nRemoving \/opt\/oracle.ahf\/tfa \n\nRemoving \/opt\/oracle.ahf\/orachk \n\nRemoving \/opt\/oracle.ahf\/ahf \n\nRemoving \/opt\/oracle.ahf\/data\/wirk-ora \n\nRemoving \/opt\/oracle.ahf\/install.properties \n<\/code><\/pre>\n<p>[\/et_pb_text][et_pb_text admin_label=&#8221;Installing Oracle AHF on Windows&#8221; module_id=&#8221;6&#8243; _builder_version=&#8221;4.6.0&#8243; _module_preset=&#8221;default&#8221; text_font=&#8221;|300|||||||&#8221; header_3_text_color=&#8221;#e05206&#8243;]<\/p>\n<h3>Installing Oracle AHF on Windows<\/h3>\n<p>If you\u2019re looking to install Oracle AHF on Windows you can download the latest versionfind tas a .zip file from Oracle Support via the following link:<\/p>\n<p><a href=\"https:\/\/support.oracle.com\/epmos\/faces\/DocContentDisplay?id=2550798.1\" target=\"_blank\" rel=\"noopener noreferrer\">Oracle Autonomous Health Framework (AHF) \u2013 Including TFA and ORAchk\/EXAchk (Doc ID 2550798.1)<\/a><\/p>\n<p>You will need to ensure that the GA Release of TFA &amp; ORAchk\/EXAchk for Windows (64-bit) is downloaded.<\/p>\n<p>Note that, as of the time of writing, the .zip file downloaded from Oracle Support contains a directory named &#8216;..&#8217; as highlighted in the screenshot below:<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;http:\/\/content.n4stack.io\/wp-content\/uploads\/2020\/09\/image1-for-orackle-blog.png&#8221; title_text=&#8221;image1 for orackle blog&#8221; admin_label=&#8221;Image&#8221; _builder_version=&#8221;4.6.0&#8243; _module_preset=&#8221;default&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.6.0&#8243; _module_preset=&#8221;default&#8221; text_font=&#8221;|300|||||||&#8221;]This causes some issues when the contents of the .zip file are extracted so it is recommended to open the .zip file using 7-Zip and rename the &#8216;..&#8217; directory to e.g., &#8216;extracted&#8217; before proceeding:[\/et_pb_text][et_pb_image src=&#8221;http:\/\/content.n4stack.io\/wp-content\/uploads\/2020\/09\/image2-for-orackle-blog.png&#8221; title_text=&#8221;image2 for orackle blog&#8221; _builder_version=&#8221;4.6.0&#8243; _module_preset=&#8221;default&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.6.0&#8243; _module_preset=&#8221;default&#8221; text_font=&#8221;|300|||||||&#8221;]<\/p>\n<p>Once downloaded, transfer the .zip file to the database host as an administrative user and unzip the file. Ensure that there is at least 5GB of free diskspace on the disk where the Oracle AHF will be installed.<\/p>\n<p>In the following example the AHF-Win_v20.1.1.zip file is transferred to the D:\\Oracle\\media\\AHF directory and the .zip file\u2019s contents are extracted into the directory. We will install Oracle AHF into the D:\\Oracle\\AHF directory:<\/p>\n<p>[\/et_pb_text][et_pb_text admin_label=&#8221;Code 13&#8243; _builder_version=&#8221;4.6.0&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#f2f2f2&#8243;]<\/p>\n<pre><code>\n\/* In an administrative Command Prompt *\/\nD:\\&gt; cd Oracle\n\nCreate directories for installation of Oracle AHF\nD:\\Oracle&gt; mkdir media\\AHF AHF\n\nD:\\Oracle&gt; cd media\\AHF\n\nAHF-Win_v20.1.1.zip transferred to the current directory\nD:\\Oracle\\media\\AHF&gt; dir \/b\nAHF-Win_v20.1.1.zip\n\nExtract contents of the .zip file to the current directory using 7-Zip or Windows Explorer\nD:\\Oracle\\media\\ahf&gt; dir \/b\nAHF-Win_v20.1.1.zip\nextracted\nREADME.txt\n<\/code><\/pre>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.6.0&#8243; _module_preset=&#8221;default&#8221; text_font=&#8221;|300|||||||&#8221;]Please note, before attempting to install Oracle AHF on Windows we must amend the system PATH environment variable to include the location of the Perl executable perl.exe. This is usually found in the \u2018perl\\bin\u2019 directory below the Oracle Home:[\/et_pb_text][et_pb_text admin_label=&#8221;Code 14&#8243; _builder_version=&#8221;4.6.0&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#f2f2f2&#8243;]<\/p>\n<pre><code>\n\/* In an administrative Command Prompt *\/\nD:\\Oracle\\media\\ahf&gt; cd extracted\n\nD:\\Oracle\\media\\ahf\\extracted&gt; dir \/b\ninstallahf.bat\noracle.ahf\n\nCheck if perl.exe is already on the PATH\nD:\\Oracle\\media\\ahf\\extracted&gt; perl -v\n'perl' is not recognised as an internal or external command, operable program or batch file.\n\nSearch for per.exe\nD:\\Oracle\\media\\ahf\\extracted&gt; dir D:\\perl.exe \/s \/b\nD:\\Oracle\\product\\11.2.0\\db_1\\perl\\bin\\perl.exe\n\nAppend the location of perl.exe to the system path variable\nD:\\oracle\\media\\ahf\\extracted&gt; SET PATH=%PATH%;D:\\Oracle\\product\\11.2.0\\db_1\\perl\\bin\n\nRetry earlier 'perl -v' command\nD:\\Oracle\\media\\ahf\\extracted&gt; perl -v\n\nThis is perl, v5.10.0 built for MSWin32-x64-multi-thread\n\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\n<\/code><\/pre>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.6.0&#8243; _module_preset=&#8221;default&#8221; text_font=&#8221;|300|||||||&#8221;]<\/p>\n<p>We now run installahf.bat with two parameters, -perlhome (the Perl home) and -ahf_loc, the location to which Oracle AHF is to be installed.<\/p>\n<p><strong>ORACLE TRACE FILE ANALYSER (TFA) ISSUES<\/strong><\/p>\n<p>Note that unlike installing Oracle AHF on Linux, as of the time of writing we cannot avoid installing the Oracle Trace File Analyser (TFA) component when installing Oracle AHF on Windows.<\/p>\n<p>In testing, TFA has been seen to cause an issue whereby it continuously writes exception errors to a file within the Oracle AHF installation folder structure. Left unchecked, the file can grow to several GB in size, so it is necessary to disable Oracle TFA as soon as the installation of Oracle AHF completes.<\/p>\n<p>[\/et_pb_text][et_pb_text admin_label=&#8221;Code 15&#8243; _builder_version=&#8221;4.6.0&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#f2f2f2&#8243;]<\/p>\n<pre><code>\n\/* In an administrative Command Prompt *\/\nD:\\Oracle\\media\\ahf\\extracted&gt; installahf.bat -perlhome D:\\Oracle\\product\\11.2.0\\db_1\\perl \u21b5\n-ahf_loc D:\\Oracle\\AHF\n\nAHF Installation Log  : C:\\ahf_install_3060_2020_05_06_16_55_54.log\n\nStarting Autonomous Health Framework (AHF) Installation\n\nAHF Version: 201100 Build Date: 202003170925\n\nAHF Location : D:\\Oracle\\ahf\\oracle.ahf\n\nAHF Data Directory stores diagnostic collections and metadata.\nAHF Data Directory requires at least 5GB (Recommended 10GB) of free space.\n\nChoose Data Directory from below options :\n1. D:\\Oracle\\ahf\\oracle.ahf [Free Space : 29896 MB]\n2. Enter a different Location\n\nChoose Option [1 - 2] : 1\n\nAHF Data Directory : D:\\Oracle\\ahf\\oracle.ahf\\data\n\nSymbolic link created for D:\\Oracle\\ahf\\oracle.ahf\\bin\\orachk.bat &lt;&lt;===&gt;&gt; D:\\Oracle\\ahf\\oracle.ahf\\orachk\\orachk.bat\n\nConfiguring TFA Services\n\nStarting Discovery...\n\nThe system cannot find the path specified.\n\nNo Grid Infrastructure Discovered on this system . . . . .\n\ndborawin\nSearching for running databases...\n1. DB11G\n\nSearching out ORACLE_HOME for selected databases...\n\nGetting Oracle Inventory...\n\nORACLE INVENTORY: C:\\Program Files\\Oracle\\Inventory\n\nDiscovery Complete...\n\nCleaning Temporary Folders . . .\nReading inv C:\\Program Files\\Oracle\\Inventory\\ContentsXML\\inventory.xml\nSuccessfully generated certificates.\n\nStarting TFA Services\n.------------------------------------------------------------------------------.\n| Host       | Status of TFA | PID | Port  | Version    | Build ID             |\n+------------+---------------+-----+-------+------------+----------------------+\n| dborawin   | RUNNING       | 584 | 49183 | 20.1.1.0.0 | 20110020200317092524 |\n'------------+---------------+-----+-------+------------+----------------------'\n\nRunning TFA Inventory...\n.-----------------------------------------------------------------.\n|                   Summary of AHF Configuration                  |\n+-----------------+-----------------------------------------------+\n| Parameter       | Value                                         |\n+-----------------+-----------------------------------------------+\n| AHF Location    | D:\\Oracle\\ahf\\oracle.ahf                      |\n| TFA Location    | D:\\Oracle\\ahf\\oracle.ahf\\tfa                  |\n| Orachk Location | D:\\Oracle\\ahf\\oracle.ahf\\orachk               |\n| Data Directory  | D:\\Oracle\\ahf\\oracle.ahf\\data                 |\n| Repository      | D:\\Oracle\\ahf\\oracle.ahf\\data\\repository      |\n| Diag Directory  | D:\\Oracle\\ahf\\oracle.ahf\\data\\dborawin\\diag   |\n'-----------------+-----------------------------------------------'\nAHF binaries are available in D:\\Oracle\\ahf\\oracle.ahf\\bin\nAHF is successfully installed\n<\/code><\/pre>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.6.0&#8243; _module_preset=&#8221;default&#8221; text_font=&#8221;|300|||||||&#8221;]<\/p>\n<p>You can disable Oracle TFA by performing the following steps:<\/p>\n<p>1. Locate the &#8216;Oracle Trace File Analyser&#8217; Windows service<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;http:\/\/content.n4stack.io\/wp-content\/uploads\/2020\/09\/image3-for-orackle-blog.png&#8221; title_text=&#8221;image3 for orackle blog&#8221; _builder_version=&#8221;4.6.0&#8243; _module_preset=&#8221;default&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.6.0&#8243; _module_preset=&#8221;default&#8221; text_font=&#8221;|300|||||||&#8221;]<\/p>\n<p>2. Edit the service&#8217;s properties to stop and disable the service:<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;http:\/\/content.n4stack.io\/wp-content\/uploads\/2020\/09\/image4-for-orackle-blog.png&#8221; title_text=&#8221;image4 for orackle blog&#8221; _builder_version=&#8221;4.6.0&#8243; _module_preset=&#8221;default&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.6.0&#8243; _module_preset=&#8221;default&#8221; text_font=&#8221;|300|||||||&#8221;]3. Stop TFA from the Command Line:[\/et_pb_text][et_pb_text admin_label=&#8221;Code 16&#8243; _builder_version=&#8221;4.6.0&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#f2f2f2&#8243;]<\/p>\n<pre><code>\n\/* In an administrative Command Prompt *\/<br \/>D:\\Oracle\\media\\ahf\\extracted&gt; cd \\\n\nD:\\&gt; cd Oracle\\AHF\\oracle.ahf\\tfa\\bin\n\nStop TFA\nD:\\Oracle\\AHF\\oracle.ahf\\tfa\\bin&gt; tfactl.bat stop\nStopping TFA from the Command Line\nSuccessfully stopped TFA\n\nNote that if the 'tfactl.bat stop' command fails with a 'missing api-ms-win-crt-runtime-l1-1-0.dll' \nerror, download &amp; install the Visual C++ Redistributable for Visual Studio 2015 and retry the command\n<\/code><\/pre>\n<p>[\/et_pb_text][et_pb_text admin_label=&#8221;Running ORAchk on Windows&#8221; module_id=&#8221;7&#8243; _builder_version=&#8221;4.6.0&#8243; _module_preset=&#8221;default&#8221; text_font=&#8221;|300|||||||&#8221; header_3_text_color=&#8221;#e05206&#8243;]<\/p>\n<h3>Running ORAchk on Windows<\/h3>\n<p>Unlike running ORAchk on Linux, it is not possible for ORAchk to run on remote nodes in a Windows clustered database (Oracle RAC) environment. Therefore, when running ORAchk on Windows on Oracle RAC databases it is necessary to install Oracle AHF and run ORAchk on each cluster node separately.<\/p>\n<p>Before running ORAchk on Windows you must ensure that a tnsnames.ora file exists in the network\\admin directory below the Oracle Home and that all databases hosted on the server have an entry in the tnsnames.ora file.<\/p>\n<p>[\/et_pb_text][et_pb_text admin_label=&#8221;Code 17&#8243; _builder_version=&#8221;4.6.0&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#f2f2f2&#8243;]<\/p>\n<pre><code>\n\/* In an administrative Command Prompt *\/\nD:\\&gt; cd Oracle\\AHF\\oracle.ahf\\bin\n\nD:\\Oracle\\AHF\\oracle.ahf\\bin&gt; orachk.bat\n\nList of running databases\n\n1. DB11G\n2. None of above\n\nIf multiple databases are running on the host an 'All of above' option will be given and should be selected\n\nSelect 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].1\n\nChecking Status of Oracle Software Stack - Clusterware, ASM, RDBMS...\n--------------------------------------------------------------------------------------------------------------\n                                          Oracle Stack Status\n--------------------------------------------------------------------------------------------------------------\nHost Name    CRS Installed    ASM HOME   RDBMS Installed   CRS UP    ASM UP    RDBMS UP       DB Instance Name\n--------------------------------------------------------------------------------------------------------------\ndborawin           No            No            Yes           No        No        Yes                DB11G\n--------------------------------------------------------------------------------------------------------------\n\nCopying plug-ins...\n*** Checking Best Practice Recommendations ( Pass \/ Warning \/ Fail ) ***\nCollections and audit checks log file is: D:\\Oracle\\AHF\\oracle.ahf\\data\\dborawin\\orachk\\orachk_050120_133251\\log\\orachk.log\n============================================================\n              Node name - dborawin\n============================================================\n Collecting - Database Parameters for DB11G database\n Collecting - Database Undocumented Parameters for DB11G database\n Collecting - List of active logon and logoff triggers for DB11G database\n Collecting - Patches for RDBMS Home\n Collecting - winservices\n\nData collections completed. Checking best practices on dborawin...\n------------------------------------------------------------------\n WARNING =&gt;  There are some application objects with STALE statistics for DB11G\n WARNING =&gt;  Oracle patch 18498878 is not applied on RDBMS_HOME D:\\Oracle\\product\\11.2.0\\db_1\n WARNING =&gt;  Oracle patch 20907061 is not applied on RDBMS_HOME D:\\Oracle\\product\\11.2.0\\db_1\n\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt; FAIL =&gt;     Table AUD$ [FGA_LOG$] should use Automatic Segment Space Management for DB11G\n WARNING =&gt;  fast_start_mttr_target has NOT been changed from default on DB11G instance\n WARNING =&gt;  Flashback on PRIMARY is not configured for DB11G\n\nBest Practice checking completed. Checking recommended patches on dborawin\n--------------------------------------------------------------------------------\nCollecting patch inventory on ORACLE_HOME D:\\Oracle\\product\\11.2.0\\db_1\n\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\n0 Recommended RDBMS patches for 112040 from D:\\Oracle\\product\\11.2.0\\db_1 on dborawin\n\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\n\nDetailed report (html) -  D:\\Oracle\\ahf\\oracle.ahf\\data\\vmora-win\\orachk\\orachk_050120_133251\\\u21b5\norachk_050120_133251.html\n\nUPLOAD [if required] - D:\\Oracle\\ahf\\oracle.ahf\\data\\vmora-win\\orachk\\orachk_050120_133251.zip\n<\/code><\/pre>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.6.0&#8243; _module_preset=&#8221;default&#8221; text_font=&#8221;|300|||||||&#8221;]<\/p>\n<p>Once completed, you can transfer the html report locally and open the report in a browser.<\/p>\n<p>[\/et_pb_text][et_pb_text admin_label=&#8221;Removing Oracle AHF from Windows&#8221; module_id=&#8221;8&#8243; _builder_version=&#8221;4.6.0&#8243; _module_preset=&#8221;default&#8221; text_font=&#8221;|300|||||||&#8221; header_3_text_color=&#8221;#e05206&#8243;]<\/p>\n<h3>Removing Oracle AHF from Windows<\/h3>\n<p>If Oracle AHF is no longer required it can be uninstalled in this way::<\/p>\n<p>[\/et_pb_text][et_pb_text admin_label=&#8221;Code 18&#8243; _builder_version=&#8221;4.6.0&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#f2f2f2&#8243;]<\/p>\n<pre><code>\n\/* In an administrative Command Prompt *\/\nD:\\&gt; cd Oracle\\AHF\\oracle.ahf\\tfa\\bin\n\nCheck if perl.exe is already on the PATH\nD:\\Oracle\\AHF\\oracle.ahf\\tra\\bin&gt; perl -v\n'perl' is not recognised as an internal or external command, operable program or batch file.\n\nAppend the location of perl.exe to the system path variable\nD:\\Oracle\\AHF\\oracle.ahf\\tra\\bin&gt; SET PATH=%PATH%;D:\\Oracle\\product\\11.2.0\\db_1\\perl\\bin\n\nRetry earlier 'perl -v' command\nD:\\Oracle\\AHF\\oracle.ahf\\tra\\bin&gt; perl -v\n\nThis is perl, v5.10.0 built for MSWin32-x64-multi-thread\n\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt; Proceed with the removal of Oracle AHF D:\\Oracle\\AHF\\oracle.ahf\\tra\\bin&gt; tfactl uninstall\nTFA-00002 Oracle Trace File Analyzer (TFA) is not running\n\nUnable to determine a host list from TFA. So running local uninstall.\nStarting TFA Uninstall\n\nNOTE: Uninstalling does not return all the space used by the AHF respository\n\nAHF will be Uninstalled on Node dborawin:\n\nDo you want to continue with AHF Uninstall? [Y|N] [Y]: Y\n\nRemoving TFA from dborawin...\n\nStopping TFA Support Tools...\n\nStopping TFA in dborawin...\n\nDeleting TFA support files on dborawin:\n\nRemoving TFAService...\n\nRemoving D:\\Orace\\AHF\\oracle.ahf\\ahf on dborawin...\nRemoving D:\\Orace\\AHF\\oracle.ahf\\analyzer on dborawin...\nRemoving D:\\Orace\\AHF\\oracle.ahf\\bin on dborawin...\nRemoving D:\\Orace\\AHF\\oracle.ahf\\common on dborawin...\nRemoving D:\\Orace\\AHF\\oracle.ahf\\jre on dborawin...\nRemoving D:\\Orace\\AHF\\oracle.ahf\\orachk on dborawin...\nRemoving D:\\Orace\\AHF\\oracle.ahf\\tfa on dborawin...\nRemoving D:\\Orace\\AHF\\oracle.ahf\\python on dborawin...\nRemoving D:\\Orace\\AHF\\oracle.ahf\\data\\ dborawin on dborawin...\nRemoving D:\\Orace\\AHF\\oracle.ahf\\data\\work on dborawin...\nRemoving D:\\Orace\\AHF\\oracle.ahf\\install.properties on dborawin...\n\nSuccessfully Uninstalled AHF on dborawin...\n\n\/* In an administrative Command Prompt *\/\nD:\\&gt; cd Oracle\\AHF\\oracle.ahf\\tfa\\bin\n\nCheck if perl.exe is already on the PATH\nD:\\Oracle\\AHF\\oracle.ahf\\tra\\bin&gt; perl -v\n'perl' is not recognised as an internal or external command, operable program or batch file.\n\nAppend the location of perl.exe to the system path variable\nD:\\Oracle\\AHF\\oracle.ahf\\tra\\bin&gt; SET PATH=%PATH%;D:\\Oracle\\product\\11.2.0\\db_1\\perl\\bin\n\nRetry earlier 'perl -v' command\nD:\\Oracle\\AHF\\oracle.ahf\\tra\\bin&gt; perl -v\n\nThis is perl, v5.10.0 built for MSWin32-x64-multi-thread\n\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt;\u00b7\u00b7\u00b7%&lt; Proceed with the removal of Oracle AHF D:\\Oracle\\AHF\\oracle.ahf\\tra\\bin&gt; tfactl uninstall\nTFA-00002 Oracle Trace File Analyzer (TFA) is not running\n\nUnable to determine a host list from TFA. So running local uninstall.\nStarting TFA Uninstall\n\nNOTE: Uninstalling does not return all the space used by the AHF respository\n\nAHF will be Uninstalled on Node dborawin:\n\nDo you want to continue with AHF Uninstall? [Y|N] [Y]: Y\n\nRemoving TFA from dborawin...\n\nStopping TFA Support Tools...\n\nStopping TFA in dborawin...\n\nDeleting TFA support files on dborawin:\n\nRemoving TFAService...\n\nRemoving D:\\Orace\\AHF\\oracle.ahf\\ahf on dborawin...\nRemoving D:\\Orace\\AHF\\oracle.ahf\\analyzer on dborawin...\nRemoving D:\\Orace\\AHF\\oracle.ahf\\bin on dborawin...\nRemoving D:\\Orace\\AHF\\oracle.ahf\\common on dborawin...\nRemoving D:\\Orace\\AHF\\oracle.ahf\\jre on dborawin...\nRemoving D:\\Orace\\AHF\\oracle.ahf\\orachk on dborawin...\nRemoving D:\\Orace\\AHF\\oracle.ahf\\tfa on dborawin...\nRemoving D:\\Orace\\AHF\\oracle.ahf\\python on dborawin...\nRemoving D:\\Orace\\AHF\\oracle.ahf\\data\\ dborawin on dborawin...\nRemoving D:\\Orace\\AHF\\oracle.ahf\\data\\work on dborawin...\nRemoving D:\\Orace\\AHF\\oracle.ahf\\install.properties on dborawin...\n\nSuccessfully Uninstalled AHF on dborawin...\n<\/code><\/pre>\n<p>[\/et_pb_text][et_pb_text admin_label=&#8221;CTA&#8221; _builder_version=&#8221;4.6.0&#8243; _module_preset=&#8221;default&#8221;]<\/p>\n<p><strong>I hope this step-by-step guide to installing, using, and removing Oracle AHF and ORAchk on Linux and Windows has helped. If you have any further questions, or would like to discuss more about <a href=\"http:\/\/content.n4stack.io\/big-data-technologies\/oracle-managed-service\/\" target=\"_blank\" rel=\"noopener noreferrer\">how our expert DBAs can help you<\/a> please get in touch.<\/strong><\/p>\n<p>[\/et_pb_text][et_pb_divider color=&#8221;#e05206&#8243; _builder_version=&#8221;4.6.0&#8243; background_color=&#8221;#e05206&#8243; height=&#8221;4px&#8221; locked=&#8221;off&#8221;][\/et_pb_divider][et_pb_text _builder_version=&#8221;4.9.1&#8243; _module_preset=&#8221;default&#8221; header_3_text_color=&#8221;#e05206&#8243;]<\/p>\n<h3 style=\"text-align: center;\">Further Insights<\/h3>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;1_3,1_3,1_3&#8243; _builder_version=&#8221;4.6.5&#8243; _module_preset=&#8221;default&#8221;][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.6.5&#8243; _module_preset=&#8221;default&#8221;][et_pb_blurb title=&#8221;Case Study: Global Healthcare ISV Partnership&#8221; url=&#8221;https:\/\/info.n4stack.io\/hubfs\/N4Stack\/Case%20Studies\/N4Stack_%20ISV%20Partnership_Case%20Study.pdf&#8221; url_new_window=&#8221;on&#8221; image=&#8221;http:\/\/content.n4stack.io\/wp-content\/uploads\/2020\/10\/Download-Document_Grey-150&#215;150.png&#8221; font_icon_last_edited=&#8221;off|desktop&#8221; _builder_version=&#8221;4.9.1&#8243; _module_preset=&#8221;default&#8221; body_text_align=&#8221;center&#8221; text_orientation=&#8221;center&#8221; custom_padding=&#8221;10px|10px|10px|10px|false|false&#8221; link_option_url=&#8221;https:\/\/info.n4stack.io\/hubfs\/N4Stack\/Case%20Studies\/N4Stack_%20ISV%20Partnership_Case%20Study.pdf&#8221; link_option_url_new_window=&#8221;on&#8221; border_radii=&#8221;on|10px|10px|10px|10px&#8221; border_width_all=&#8221;2px&#8221; border_color_all=&#8221;#e05206&#8243; box_shadow_style=&#8221;preset2&#8243; font_icon__hover_enabled=&#8221;off|desktop&#8221;]<\/p>\n<p>Find out how our team of experts helped a global healthcare ISV implement their Oracle database environments.<\/p>\n<p><a href=\"https:\/\/info.n4stack.io\/hubfs\/N4Stack\/Case%20Studies\/N4Stack_%20ISV%20Partnership_Case%20Study.pdf\" target=\"_blank\" rel=\"noopener noreferrer\">Read the case study.<\/a><\/p>\n<p>[\/et_pb_blurb][\/et_pb_column][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.6.5&#8243; _module_preset=&#8221;default&#8221;][et_pb_blurb title=&#8221;Are you ready for Oracle 12c End of Support?&#8221; url=&#8221;https:\/\/n4stack.io\/2020\/07\/06\/oracle-12c-end-of-support\/&#8221; url_new_window=&#8221;on&#8221; image=&#8221;http:\/\/content.n4stack.io\/wp-content\/uploads\/2020\/10\/Blog_Grey-150&#215;150.png&#8221; font_icon_last_edited=&#8221;off|desktop&#8221; _builder_version=&#8221;4.9.1&#8243; _module_preset=&#8221;default&#8221; body_text_align=&#8221;center&#8221; text_orientation=&#8221;center&#8221; custom_padding=&#8221;10px|10px|10px|10px|false|false&#8221; link_option_url=&#8221;https:\/\/n4stack.io\/2020\/07\/06\/oracle-12c-end-of-support\/&#8221; link_option_url_new_window=&#8221;on&#8221; border_radii=&#8221;on|10px|10px|10px|10px&#8221; border_width_all=&#8221;2px&#8221; border_color_all=&#8221;#e05206&#8243; box_shadow_style=&#8221;preset2&#8243; font_icon__hover_enabled=&#8221;off|desktop&#8221;]<\/p>\n<p>Oracle 12c support ends in November 2020. Have a read of our blog to find out what your support options are going forward.<\/p>\n<p><a href=\"https:\/\/n4stack.io\/2020\/07\/06\/oracle-12c-end-of-support\/\" target=\"_blank\" rel=\"noopener noreferrer\">Read our blog.<\/a><\/p>\n<p>[\/et_pb_blurb][\/et_pb_column][et_pb_column type=&#8221;1_3&#8243; _builder_version=&#8221;4.6.5&#8243; _module_preset=&#8221;default&#8221;][et_pb_blurb title=&#8221;Looking to outsource your DBA support overhead?&#8221; url=&#8221;https:\/\/n4stack.io\/8-reasons-to-outsource-your-dba-support-overhead\/&#8221; url_new_window=&#8221;on&#8221; image=&#8221;http:\/\/content.n4stack.io\/wp-content\/uploads\/2020\/10\/Download-Document_Grey-150&#215;150.png&#8221; font_icon_last_edited=&#8221;off|desktop&#8221; _builder_version=&#8221;4.9.1&#8243; _module_preset=&#8221;default&#8221; body_text_align=&#8221;center&#8221; text_orientation=&#8221;center&#8221; custom_padding=&#8221;10px|10px|10px|10px|false|false&#8221; link_option_url=&#8221;https:\/\/n4stack.io\/8-reasons-to-outsource-your-dba-support-overhead\/&#8221; link_option_url_new_window=&#8221;on&#8221; border_radii=&#8221;on|10px|10px|10px|10px&#8221; border_width_all=&#8221;2px&#8221; border_color_all=&#8221;#e05206&#8243; box_shadow_style=&#8221;preset2&#8243; font_icon__hover_enabled=&#8221;off|desktop&#8221;]<\/p>\n<p>Download our handy guide to discover the eight business benefits to outsourcing your DBA support overhead.<\/p>\n<p><a href=\"https:\/\/n4stack.io\/8-reasons-to-outsource-your-dba-support-overhead\/\" target=\"_blank\" rel=\"noopener noreferrer\">Download our guide.<\/a><\/p>\n<p>[\/et_pb_blurb][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; _builder_version=&#8221;4.9.4&#8243; _module_preset=&#8221;default&#8221; title_text=&#8221;Bevelled-1920&#8243; background_image=&#8221;http:\/\/content.n4stack.io\/wp-content\/uploads\/2020\/10\/Bevelled-1920.jpg&#8221; hover_enabled=&#8221;0&#8243; sticky_enabled=&#8221;0&#8243;][et_pb_row _builder_version=&#8221;4.9.4&#8243; _module_preset=&#8221;default&#8221; title_text=&#8221;Bevelled-1920&#8243; hover_enabled=&#8221;0&#8243; sticky_enabled=&#8221;0&#8243; background_enable_image=&#8221;off&#8221;][et_pb_column _builder_version=&#8221;4.9.4&#8243; _module_preset=&#8221;default&#8221; type=&#8221;4_4&#8243;][et_pb_team_member name=&#8221;Neil Garside&#8221; position=&#8221;Senior DBA&#8221; image_url=&#8221;http:\/\/content.n4stack.io\/wp-content\/uploads\/2021\/04\/Neil-Garside-300&#215;300.png&#8221; linkedin_url=&#8221;https:\/\/www.linkedin.com\/in\/neil-garside&#8221; _builder_version=&#8221;4.9.4&#8243; _module_preset=&#8221;default&#8221; hover_enabled=&#8221;0&#8243; global_module=&#8221;60005&#8243; saved_tabs=&#8221;all&#8221; title_text=&#8221;Bevelled-1920&#8243; sticky_enabled=&#8221;0&#8243; background_enable_image=&#8221;off&#8221; admin_label=&#8221;Neil Garside&#8221;]<\/p>\n<p>Neil started his Oracle career as a developer, becoming a DBA after emigrating to Australia in 1997.<\/p>\n<p>After returning to the UK in early 2003 he joined Ikano Bank as part of a team of Oracle DBAs looking after databases across Scandinavia, Germany, Poland and the UK. After being outsourced to Capgemini in 2017 Neil managed the transition of Ikano&#8217;s Oracle databases to Capgemini&#8217;s datacentres in Finland.<\/p>\n<p>Neil joined N4Stack in 2019. When not asking himself why he ever returned from Australia, Neil is a keen photographer and chicken keeper.<\/p>\n<p>He still thinks materialised views are a pretty neat idea.<\/p>\n<p>[\/et_pb_team_member][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Installing Oracle AHF and Running ORAchk on Linux and Windows Is your Oracle database in need of some TLC? Then you need ORAchk (Oracle Check). The utility examines an Oracle system\u2019s configuration looking for areas that need improvement and generates a risk report that you can then use to improve the health status of your [&hellip;]<\/p>\n","protected":false},"author":22,"featured_media":59966,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":""},"categories":[484,8112,343],"tags":[322,354,8111,313,2815],"yst_prominent_words":[],"_links":{"self":[{"href":"http:\/\/content.n4stack.io\/wp-json\/wp\/v2\/posts\/59835"}],"collection":[{"href":"http:\/\/content.n4stack.io\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/content.n4stack.io\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/content.n4stack.io\/wp-json\/wp\/v2\/users\/22"}],"replies":[{"embeddable":true,"href":"http:\/\/content.n4stack.io\/wp-json\/wp\/v2\/comments?post=59835"}],"version-history":[{"count":52,"href":"http:\/\/content.n4stack.io\/wp-json\/wp\/v2\/posts\/59835\/revisions"}],"predecessor-version":[{"id":61367,"href":"http:\/\/content.n4stack.io\/wp-json\/wp\/v2\/posts\/59835\/revisions\/61367"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/content.n4stack.io\/wp-json\/wp\/v2\/media\/59966"}],"wp:attachment":[{"href":"http:\/\/content.n4stack.io\/wp-json\/wp\/v2\/media?parent=59835"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/content.n4stack.io\/wp-json\/wp\/v2\/categories?post=59835"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/content.n4stack.io\/wp-json\/wp\/v2\/tags?post=59835"},{"taxonomy":"yst_prominent_words","embeddable":true,"href":"http:\/\/content.n4stack.io\/wp-json\/wp\/v2\/yst_prominent_words?post=59835"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}