How to monitor database on Zabbix Agent 2

How to monitor database on Zabbix Agent 2( Zabbix 7.0 LTS)

Content of Working

__________________________________________________________________________________

1. Create user that have privilege to DB monitor

2.  Install Zabbix Agent 2 on Linux (DB Server)

43  3. Install Database clientinstance on Linux (DB server)

4. Edit .bash_profile

5. Test Script to Confirm It’s OK

6. Parameter in Zabbix

7. Go To Zabbix Server WebGUI

__________________________________________________________________________________

1. Create user that have privilege to DB monitor 

• sqlplus /nolog
• connect /as sysdba
• CREATE USER <username> IDENTIFIED BY <password> container=all
• GRANT CONNECT TO <username> container=all
• GRANT sysdba TO <username> container=all

2. Install Zabbix Agent 2 on Linux (DB Server)

a.       Install Zabbix repository

# rpm -Uvh https://repo.zabbix.com/zabbix/6.0/rhel/8/x86_64/zabbix-release-6.0-5.el8.noarch.rpm
# dnf clean all

b.      Install Zabbix agent2

# dnf install zabbix-agent2 zabbix-agent2-plugin-*

c.       Start Zabbix agent2 process

# systemctl restart zabbix-agent2

# systemctl enable zabbix-agent2

d.      Configure Zabbix agent2

# vi /etc/zabbix/zabbix_agent2.conf

Change server=127.0.0.1 to ip’s zabbix server

# systemctl restart zabbix-agent2

3. Install Database clientinstance on Linux (DB server)

o   Download software oracle on portal

Instant Client for Linux x86-64 (64-bit) (oracle.com)

# rpm -i oracle-instantclient-basic-23.5.0.24.07-1.el8.x86_64.rpm

# rpm -i oracle-instantclient-sqlplus-23.5.0.24.07-1.el8.x86_64.rpm

4. Edit .bash_profile

# vi .bash_profile

ORACLE_SID=fiouat1

ORACLE_HOME=/dboracle/app/oracle/product/19.0.0/db_1

ZABBIX_HOME=/usr/lib/oracle/23/client64

export ORACLE_SID ORACLE_HOME ZABBIX_HOME PATH=$ORACLE_HOME/bin:$ZABBIX_HOME/bin:$PATH

5. Go To Zabbix Server WebGUI

è  Data Collection -> Hosts -> Creat Host

è  Go to Host that Created -> click on Macros -> Inherited and host macros

add macro like 

    -    IP DB server

    -    username

    -    password

    -    service name

        

3.