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 !!!!