Databases are important for a lot of IT processes. Their efficiency and reliability depends upon many components and it is smart to make use of a devoted software that lets you keep up to the mark. Monitoring your database with an exterior software helps you establish efficiency points proactively, however there are various components to contemplate. With the flawed method, you run the chance of lacking priceless data and likewise can waste plenty of time configuring your database monitoring.
On this tutorial, I’ll give a fast information on tips on how to monitor Oracle Database with Checkmk, a common monitoring software for every kind of IT property. Oracle Database is likely one of the most typical database administration techniques (DBMS) for relational databases and Checkmk comes with an awesome preconfigured Oracle monitoring, so it would solely take you a couple of minutes to get began. This won’t solely guarantee one of the best efficiency of your databases, but in addition provide the choice to seek out optimization alternatives.
Preconditions
You want a Checkmk web site up and operating. For this text, I’m utilizing the Checkmk Free Version model 2.1.0p19, which I put in on Ubuntu server (model 20.04). Checkmk runs on Linux, together with RHEL, CentOS, Debian, and others, in addition to in a container, or as a digital equipment. You’ll be able to obtain the most recent Checkmk model for all platforms from the official Checkmk web site and comply with this video tutorial to take your first steps.
On this tutorial, I’ll use a easy Oracle server for example. In my case, my Oracle database model 19.0 runs on a {hardware} server, and I take advantage of Rocky Linux model 9.0 as my working system. I’ll present you tips on how to configure and set up the Checkmk agent. Nevertheless, Checkmk may also monitor distant databases with out the necessity to set up an agent.
You do not want any earlier expertise with Oracle monitoring, as Checkmk takes over the gathering of a very powerful monitoring companies and likewise units threshold values for warnings and important states. Nevertheless, you want entry rights to create person accounts for the database you wish to monitor, you’ll do that in step one.
Step 1: Creating an Oracle person account for the monitoring
First, that you must create a person account that Checkmk will use to question the monitoring information out of your database. In my case, I’m utilizing SQL Plus and create the person by the terminal. The process differs relying on which Oracle setting and power you’re utilizing. You’ll be able to learn extra particulars about this within the Oracle documentation.
- In my instance, I change to the Oracle person for this and log in as sysdba.
su - oracle sqlplus / as sysdba
- Now, I create a person account for the monitoring. In my case, I’ve referred to as it ‘checkmk’.
create person checkmk recognized by MySecurePassword
- After creating the person account, assign entry rights and the rights to begin a session to this person account.
grant select_catalog_role to checkmk grant create session to checkmk
- Now you can take a look at the reference to
join:
join checkmk/MySecurePassword
‘MySecurePassword’ is simply a placeholder, in fact. Please use a powerful password with ample size and a combination of higher and decrease case letters, numbers and particular characters. Upon getting created a person, you possibly can change to your Checkmk web site for the subsequent step.
Step 2: Utilizing the Oracle monitoring rule in Checkmk
You’ll now use the Oracle database agent rule to create a Checkmk agent that you simply later will set up in your Oracle server. To take action, you’ll use the Checkmk Agent Bakery, which isn’t a part of the Checkmk Uncooked Version. In case you are utilizing the Checkmk Uncooked Version, you’ll as a substitute must configure the plug-in through the command line. To do that, comply with the directions within the article on monitoring Oracle databases within the Checkmk documentation.
- Open Checkmk.
- Go to Setup and seek for ‘oracle database’. Click on on ‘ORACLE databases (Linux, Solaris, AIX, Home windows)’.
Underneath ‘ORACLE databases (Linux, Solaris, AIX, Home windows)’, you see plenty of choices to configure your Oracle monitoring. Nevertheless, Checkmk offers you with good default values. For many makes use of instances, you simply must activate a couple of containers:
- Tick the primary field in entrance of Activation and depart the default setting as ‘Deploy ORACLE database plugin’.
- As a result of my Oracle database server runs on a Linux distribution utilizing a systemd as tremendous server daemon, I must activate Host makes use of xinetd or systemd (Linux/AIX/Solaris solely), and choose the choice ‘systemd’. I depart Interval at one minute.
- At Login Defaults, that you must add your person account credentials. Activate the field after which select Authentication methodology to log in together with your person account.
- In my case, I preserve the choice ‘Login with the next credentials’ and my person account ‘checkmk’ and my password from earlier than.
- Click on on Save.
Step 3: Baking and putting in of the Checkmk agent
After the configuration, that you must use the Agent Bakery to bake an agent package deal.
Click on on Setup and go to Home windows, Linux, Solaris, AIX.
Now, click on on Bake brokers.
You have to wait till the Agent Bakery is completed, then you need to see a brand new out there agent configuration.
Click on on the format that fits your Oracle database server. In my case the RPM package deal will do the trick.
After the obtain, set up the package deal. I’m utilizing dnf on the terminal
sudo dnf set up check-mk-agent-2.1.0p19-0a8bd97002c9f415.noarch.rpm
Step 4: Including an Oracle server to the monitoring in Checkmk
Now you possibly can add your Oracle server to the monitoring in Checkmk, so that you must return to your Checkmk web site.
Go to Setup and click on on Host.
Click on on Add host.
Underneath Hostname, you add the identify of your Oracle server. In my case ‘oracle-rocky-01.demo.tribe29.com’.
Click on on Save & go to service configuration.
The identify of my Oracle server is resolvable by DNS. If that isn’t the case for you, you need to activate the IPv4 tackle choice and enter the server’s IP tackle.
It’s important to await the automated service detection. After that, click on on Settle for all so as to add all of the detected companies.
Verify the modifications you made by clicking on the yellow icon with the exclamation mark within the prime proper nook. You need to see the variety of ‘modifications’ there.
Click on Activate on chosen websites.
And that was it, your database server is now monitored. Go to Monitor and you discover your database server host underneath All Hosts. With a click on on the host, you get to the host view:
Abstract
This primary tutorial offers you with an introduction on tips on how to monitor Oracle Database. You construct your self an excellent basis, however there’s extra to do. You need to monitor your server {hardware}, as effectively, and also you most likely additionally wish to know extra about all of the configuration choices inside Checkmk. Additionally, I discussed monitoring distant databases. Thus, I like to recommend studying this weblog about Oracle monitoring, as a result of it offers solutions to those factors and likewise reveals you tips on how to monitor Oracle Cloud Infrastructure. For extra normal data on monitoring databases, you need to take a look at this text on SQL Server Monitoring.
