Autonomous Health Framework (AHF ) Inventory Status STOPPED

This post demonstrates how to resolve AHF Inventory Status is “STOPPED” without uninstalling and installing AHF.

# ahfctl statusahf

.-------------------------------------------------------------------------------------------------.
| Host     | Status of TFA | PID    | Port | Version    | Build ID             | Inventory Status |
+----------+---------------+--------+------+------------+----------------------+------------------+
| racnode1 | RUNNING       |  10052 | 5000 | 21.4.0.0.0 | 21400020211220074549 | STOPPED          |
| racnode2 | RUNNING       | 384602 | 5000 | 21.4.0.0.0 | 21400020211220074549 | COMPLETE         |
| racnode3 | RUNNING       |  20041 | 5000 | 21.4.0.0.0 | 21400020211220074549 | COMPLETE         |
| racnode4 | RUNNING       | 228081 | 5000 | 21.4.0.0.0 | 21400020211220074549 | COMPLETE         |
'----------+---------------+--------+------+------------+----------------------+------------------'

Subscribe to get access

Read more of this content when you subscribe today.

High CPU and Memory Usage by Autonomous Health Framework (AHF)

A client ExaCC platform experiences both CPU and memory resource issues. After detailed investigations, we found the Autonomous Health Framework (AHF) processes consume huge CPU and memory resources. The followings are the diagnoses and solutions.

INVESTIGATIONS and SOLUTIONS

Subscribe to get access

Read more of this content when you subscribe today.

The Cluster Health Advisor (CHA) detected an unexpected increase in CPU utilization by databases or applications on this node. Identify CPU intensive processes and databases by reviewing Cluster Health Monitoring (CHM) data. Relocate databases to less busy machines, or limit the number of connections to databases on this node. Add nodes if more resources are required

A client keeps receiving the following alerts from OEM:

Host=racnode1.ractest
Target type=Cluster 
Target name=RACTEST-CLUSTER
Incident creation time=15/12/2021 2:11:20 PM AEDT 
Last updated time=15/12/2021 2:11:20 PM AEDT 
Message=Host CPU Utilization on Host racnode1 Database/Cluster RACTEST-CLUSTER Instance . The Cluster Health Advisor (CHA) detected an unexpected increase in CPU utilization by databases or applications on this node. Identify CPU intensive processes and databases by reviewing Cluster Health Monitoring (CHM) data. Relocate databases to less busy machines, or limit the number of connections to databases on this node. Add nodes if more resources are required. 
Severity=Warning 
Incident ID=501920 
Event count=1 
Incident Status=New 
Escalated=No 
Priority=High 
Incident owner=SYSMAN
Incident Acknowledged By Owner=No 
Categories= 
Rule Name=RuleSet - SYSMAN,Email SYSMAN About the Incidents 
Rule Owner=SYSMAN
...
..
.

Now let’s look into further where the alerts come from, the logs, GI processes and related metrics configurations on OEM.

Subscribe to get access

Read more of this content when you subscribe today.

Windows Not Detecting the External Monitor

After HP laptop rebooted this morning, the external monitor is not detected by Windows.

The following steps have been taken :

  1. Confirmed HTML cable is a good one by connecting to other PC or laptop working fine.
  2. Updated with the latest Display Adapters driver.
  3. After the above two steps, go to Start -> Settings -> System ->  Display tab, find and press the Detect button under the heading Multiple Displays. Still not working:

SOLUTION

Subscribe to get access

Read more of this content when you subscribe today.

Schedule Jobs Not Running after Instance Restarted

Oracle database scheduler jobs have been working fine. Since the database was upgraded, every time when database was bounced, then scheduler jobs stopped running.

INVESTIGATION and SOLUTION

Subscribe to get access

Read more of this content when you subscribe today.