Skip to main content
Question

Oracle plugin does not find all tablespaces

  • March 25, 2026
  • 0 replies
  • 3 views

Hello
I’m using the database::oracle plugin to replace the old one I was using before.
Almost everything works fine, except that it does not find 2 tablespaces, SYSTEM and UNDOTBS1, which were perfectly found by the old plugin : 
 

$ /usr/lib64/nagios/plugins/Poller/check_oracle_health.sh -connect ALIAS  --name SYSTEM  --username XXXX --password YYY --warning  90 --critical 95 --mode list-tablespaces
SYSTEM
OK - have fun
$ /usr/lib64/nagios/plugins/Poller/check_oracle_health.sh -connect ALIAS --name SYSTEM --username XXXX --password YYYY --warning 90 --critical 95 --mode tablespace-usage
OK - tbs SYSTEM usage is 11.05% | 'tbs_system_usage_pct'=11.05%;90;95 'tbs_system_usage'=565MB;4608;4864;0;5120 'tbs_system_alloc'=632MB;;;0;5120

Unfortunately, with the official oracle plugin, it’s not found : 
 

$ /usr/lib/centreon/plugins//centreon_oracle.pl --plugin=database::oracle::plugin --hostname 1.2.3.4 --port 1524 --servicename SID--username XXXX--password YYY --mode tablespace-usage --filter-tablespace SYSTEM --warning-tablespace  90 --critical-tablespace  95
UNKNOWN: No tablespaces found.
$ /usr/lib/centreon/plugins//centreon_oracle.pl --plugin=database::oracle::plugin --hostname 1.2.3.5 --port 1524 --servicename SID--username XXXX--password YYY --mode list-tablespaces --filter-tablespace SYSTEM
List tablespaces:
$

(same with tablespace UNDOTBS1).

All other TS are discovered perfectly (150+).
Any idea what could cause this ?
 

$ cat /etc/redhat-release
Red Hat Enterprise Linux release 8.10 (Ootpa)
$ /usr/lib/centreon/plugins//centreon_oracle.pl --plugin=database::oracle::plugin --version
Plugin Version: 0.1
$ /usr/lib/centreon/plugins//centreon_oracle.pl --version
Global Version: 20260200 (936642c)