MRP (Managed Recovery Process) Stuck after Creating Standby Database
Recently I created a physical standby database using ZDM for one of the big Oracle Database Migration. After creating the standby database, ... Read More






Recently we upgraded the Autonomous Health Framework (AHF) to the latest version and I found the new AHFCTL command line very helpful and easy to upgrade AHF.
AHFCTL command-line utility starts from version 21.1 version.
Here are the steps:
1. Download the latest patch to the patch location.
[root@oda-base0 stage]# pwd
/u01/stage
[root@oda-base0 stage]# ls -lrt
total 402584
-rw-r--r-- 1 root root 411834022 Dec 15 19:44 AHF-LINUX_v21.3.4.zip
[root@oda-base0 stage]#
2. Check the current version of AHF using the below command: ahfctl statusahf
[root@oda-base0 stage]# ahfctl statusahf
.------------------------------------------------------------------------------------------------.
| Host | Status of TFA | PID | Port | Version | Build ID | Inventory Status |
+----------+---------------+-------+------+------------+----------------------+------------------+
|oda-base0 | RUNNING | 18822 | 5000 | 21.3.3.0.0 | 21330020211213022521 | COMPLETE |
'----------+---------------+-------+------+------------+----------------------+------------------'
------------------------------------------------------------
Master node = oda-base0
orachk daemon version = 21.3.0
Install location = /opt/oracle/dcs/oracle.ahf/orachk
Started at = Fri Nov 19 10:40:14 EST 2021
Scheduler type = TFA Scheduler
Scheduler PID: 18822
------------------------------------------------------------
ID: orachk.autostart_client_oratier1
------------------------------------------------------------
AUTORUN_FLAGS = -usediscovery -profile oratier1 -dball -showpass -tag autostart_client_oratier1 -readenvconfig
COLLECTION_RETENTION = 7
AUTORUN_SCHEDULE = 3 2 * * 1,2,3,4,5,6
------------------------------------------------------------
------------------------------------------------------------
ID: orachk.autostart_client
------------------------------------------------------------
AUTORUN_FLAGS = -usediscovery -tag autostart_client -readenvconfig
COLLECTION_RETENTION = 14
AUTORUN_SCHEDULE = 3 3 * * 0
------------------------------------------------------------
Next auto run starts on Dec 16, 2021 02:03:00
ID:orachk.AUTOSTART_CLIENT_ORATIER1
3. Set Software stage location: ahfctl set upgrade -swstage
[root@oda-base0 stage]# ahfctl setupgrade -swstage /u01/stage/
AHF autoupgrade parameters successfully updated Successfully synced AHF configuration refreshConfig() completed successfully. NOTE: you don't need to unzip the file
4. Upgrade AHF using ahfctl upgrade command:
[root@oda-base0 stage]# ahfctl upgrade
/u01/stage/AHF-LINUX_v21.3.4.zip successfully extracted at /u01/stage/
AHF software signature has been validated successfully
AHF Installer for Platform Linux Architecture x86_64
AHF Installation Log : /tmp/ahf_install_213400_77222_2021_12_16-15_05_05.log
Starting Autonomous Health Framework (AHF) Installation
AHF Version: 21.3.4 Build Date: 202112151432
AHF is already installed at /opt/oracle.ahf
Installed AHF Version: 21.3.3 Build Date: 202112130225
Upgrading /opt/oracle.ahf
Shutting down AHF Services
Stopped OSWatcher
Nothing to do !
Shutting down TFA
oracle-tfa stop/waiting
Killing TFA running with pid 52188 gracefully
. . . . .
Killing TFA running with pid 52188
. . .
Successfully shutdown TFA..
Starting AHF Services
Starting TFA..
oracle-tfa start/running, process 83660
Waiting up to 100 seconds for TFA to be started..
. . . . .
Successfully started TFA Process..
. . . . .
TFA Started and listening for commands
No new directories were added to TFA
Directory /u01/app/grid/crsdata/oda-base0/trace/chad was already added to TFA Directories.
INFO: Starting orachk scheduler in background. Details for the process can be found at /opt/oracle.ahf/data/oda-base0/diag/orachk/compliance_start_161221_150721.log
AHF is successfully upgraded to latest version
.-----------------------------------------------------------------.
| Host | TFA Version | TFA Build ID | Upgrade Status |
+-----------+-------------+----------------------+----------------+
| oda-base0 | 21.3.4.0.0 | 21340020211215143236 | UPGRADED |
|-----------+-------------+----------------------+----------------'
Moving /tmp/ahf_install_213400_77222_2021_12_16-15_05_05.log to /opt/oracle.ahf/data/oda-base0/diag/ahf/
[root@oda-base0 stage]# tfactl status
.-------------------------------------------------------------------------------------------------.
| Host | Status of TFA | PID | Port | Version | Build ID | Inventory Status |
+-----------+---------------+-------+------+------------+----------------------+------------------+
| oda-base0 | RUNNING | 83922 | 5000 | 21.3.4.0.0 | 21340020211215143236 | COMPLETE |
|-----------+---------------+-------+------+------------+----------------------+------------------'
Recently I created a physical standby database using ZDM for one of the big Oracle Database Migration. After creating the standby database, ... Read More
Container Instance: OCI Container Instances enables you to easily run applications on serverless compute optimized for containers. Using ... Read More
