Nagios Support Forum

Posted: **Wed Sep 18, 2019 2:53 am**

In Nagios XI (v5.6.6) Configuration Wizards => Oracle Tablespace Wizard (v1.5.9)
The wizard take the info: Address, Port, SID, ...., Database.
The bug is that the wizard is not taking the "Database" info into account! and ignore it.
Because the result of this wizard is 6 services each of these is monitoring all the Tablespaces in the Oracle Database no matter what we provided in the "Database" field.
The solution is that each service should monitor just the Tablespace provided in the wizard (ie. In Database field).
And this can be done if you look at "check_oracle_health" plugin Docs and use "--name" parameter in the wizard generations of services commands.
And secondly, the "Database" field should be renamed to "Tablespace" because the database in Oracle refers to the whole Oracle server.

Posted: **Wed Sep 18, 2019 4:40 pm**

We'll fix this in a wizard update, but in the meantime you can change this(starting on line 492):

Code: Select all

// common plugin opts
            if (have_value($sid) == false) {
                $commonopts = "--connect '{$address}:{$port}' --username '{$username}' --password '{$password}' ";
            } else {
                $commonopts = "--connect '{$address}:{$port}/{$sid}' --username '{$username}' --password '{$password}' ";
            }

to:

Code: Select all

// common plugin opts
            if (have_value($sid) == false) {
                $commonopts = "--connect '{$address}:{$port}' --username '{$username}' --password '{$password}' --name '{$database}' ";
            } else {
                $commonopts = "--connect '{$address}:{$port}/{$sid}' --username '{$username}' --password '{$password}' --name '{$database}' ";
            }

Nagios Support Forum

Nagios XI - Bug In Oracle Tablespace Wizard v1.5.9

Nagios XI - Bug In Oracle Tablespace Wizard v1.5.9

Re: Nagios XI - Bug In Oracle Tablespace Wizard v1.5.9