Monitoring Oracle databases with Checkmk

Checkmk is a software developed in Python and C++ for IT Infrastructure monitoring. It is used for the monitoring of servers, applications, networks, cloud infrastructures (public, private, hybrid), containers, storage, databases and environment sensors.

1 Configuring access accounts for Oracle monitoring

Login to Oracle Database as sysdba user and create user

Note: – In case of multitenant Oracle Database then user will be common user if not the then local user with same set of privileges.

2 Configuring Oracle Database monitoring rules in Checkmk

Click on the Setup search “Oracle Database ” and then click on the “ORACLE databases (Linux, Solaris, AIX, Windows)” to create rules

Click on the Add rule

3 Baking agent packages for Oracle Database servers

Click on Setup and Agent (Windows, Linux, Solaris, AIX)

Click on Bake Agents and let the Baking agent baking successful

Once it is successful depending upon the operating system click on the rpm to be downloaded and installed in the server.

Post downloading of the rpm package. Click on the top right and activate the changes

Copy the rpm package to the server and install the agent on the Oracle database server

4 Monitoring Oracle Database servers with Checkmk

Click on the Setup and then click on Host

Click on the Add Folder and create folder Oracle-Database and click on the same folder again

Click on the Add Host

Enter the details of Oracle Database server and click on Save & go to service configuration

Click on the Accept All

Click on Monitoring and All hosts

Select the Oracle Database which you want to monitor

Testing Connection to the host ::-

Option 1

Navigate to the Setup > Hosts > <Folder Name>. Click on “Save & run connection tests”

Option 2

cd /usr/lib/check_mk_agent/plugins
export MK_CONFDIR=/etc/check_mk
export MK_VARDIR=/var/lib/check_mk_agent
./mk_oracle -t

Happy Learning !!!!

Leave a comment