Introduction:
AHFFI is a function that collects data collected by AHF from multiple servers and displays it on a single screen.
Why we need to do
Observe key issues across your fleet-Dashboards allow for in-depth analysis of the root cause of each issue-If necessary, drill down into specific insight reports to identify detailed.
Support Platform:
(OEL) x86_64, (RHEL) x86_64, db 19c or later and ahf 24.9 or later
system requirements for ahffi :
4 cores CPU, 16GB RAM, 4GB disk space
yum install cronie
sudo yum install iproute
sudo yum install hostname
INSTALLATION STEPS:
- Download ahffi from link 3043060.1 mos
- Prerequisite setup
- Install jdk-24
- Install instant client sqlplus 23.4.0
- Install instant client basic 23.4.0
- Create a user for ahffi on 23ai database
create user ahffi identified by ahffi;
grant create session to ahffi;
grant connect, resource to ahffi;
grant create table to ahffi;
grant insert any table to ahffi;
alter user ahffi quota unlimited on users;
- Download the ahffi file and upload it to the server
5. Fleet installation
su – oracle
$ mkdir -p /home/oracle/ahffi
$ mv AHFFI-LINUX_v25.1.0.zip /home/oracle/ahffi/
$ cd /home/oracle/ahffi/
$ unzip AHFFI-LINUX_v25.1.0.zip
$ unzip ahf_fleet_setup_onprem.zip
- Install fleet
$./ahf_fleet_setup -loc /home/oracle/ahffi
Provide below details and password
DB host: “xxx.xxx.xxx.xx”
DB port: “1521”
DB service: “freepdb1”
DB user: “ahffi”
- Check ahffi status
- Disable the firewall on db server – systemctl stop firewalld
- Add target server (client) to ahffi as root user
6. Check the Web interface
Conclusion:
AHF Fleet Insights (AHFFI) is a powerful tool for efficiently managing database fleets and quickly
diagnosing problems.
