Hello,

I would like to monitor Oracle database services on linux server from PRTG. Can anyone tell me how do I do it ?

Article Comments

You can monitor processes in Linux via the snmpd.conf configuration. List the process name in the snmpd.conf similar to the below. When you add the process(es) you can then add a sensor in PRTG, filter by SNMP, then choose SNMP Library with Basic Linux Library file. It will scan and it will list the processes in order you put them in snmpd.conf. Look for the process count in the name column and select those sensors. Then rename them and put limits on them for alerting.

proc smbd
proc nmbd
proc vsftpd
proc mysql-monitor-agent
proc redis-server
proc java


Jul, 2013 - Permalink

To tag onto my last past, I attempted to edit it to no avail. The processes have to be listed one per line, not how it is displaying.


Jul, 2013 - Permalink

Did you try using the Oracle Sensor in PRTG towards the Linux Oracle target? Did you get any errors then?


Jul, 2013 - Permalink

Hello, Thanks for your support but It would be helpful if you could provide the exact code for adding oracle database service (e.g. Db name is db123).


Jul, 2013 - Permalink

It depends on what you are looking to monitor. Are you trying to confirm that the database PROCESS is running? Or are you testing connectivity to the Oracle database instance? Two different approaches.

What I documented covers the monitoring the database process. You can grep this out of running processes, do a top command and find it, multiple different ways.

If you are trying to test connectivity, then use the Oracle SQL Sensor, which will connect to both Unix and Linux Oracle. You need to create a user on the Oracle database and assign just enough permissions to run the SQL-expression. One expression that would test connectivity is select count(*) from sys.v_$session which returns DB Process Count.


Jul, 2013 - Permalink