Multiple Nagios session in the database

[RIDS_I2MP]

MOD EDIT: Split from https://support.nagios.com/forum/viewtopic.php?t=36504

Hi Team,

We have faced the similar issue again.

150+ active nagios sessions were created on the database server.

We are monitoring about 8-10 parameters of database on these database servers, and all parmeters uses the same script i.e. check_xi_oracleserverspace. Since morning we received "connection could not be established within 60 seconds" error message and later in the evening the issue started becoming critical and resulted in “maximum processes reached” error on database, which forced us to restart the DB server twice that day.

We have checked the load during this issue it was normal both CPU and memory.

Now after the issue is resolved when we execute "ps -ef | grep oracle" command on Nagios server side we found only one row.

Kindly can you let us know what could be the reason for creation of active sessions and what else we can check to find the root cause.

[tgriep]

Can you post your nagios.log file from the XI server so we can see if there were any errors when the check ran?
The file is located here.

Code: Select all

/usr/local/nagios/var/nagios.log

If the issue happened before today, you will have to send in the archive log file for that day and they can be found here.

Code: Select all

/usr/local/nagios/var/archives

Run this and post the output so we can see the version of the plugin you are running.

Code: Select all

/usr/local/nagios/libexec/check_oracle_health  -V