I have a main Nagios server that i monitor 12 other servers that run Oracle. To monitor the table spaces i use NRPE to run the check_oracle plugin and report back to the nagios server. I do this because when i set $ORACLE_SID on the nagios server im under the impression only one can be set, but i use different ORACLE_SIDS for each server.
Can more than one ORACLE_SID be defined on the nagios monitoring server so i can stop using NRPE to monitor the tables spaces on all of them? BTW i only have instant client installed on the Nagios server. Full oracle is on the db servers them selves.