Oracle Datafile Usage

[ganeshanrs1983]

Team,

We have to monitor oracle datafile usage under each tablespace. Could you please help us how to monitor that using "oracle_health_check" plugin or suggest any other plugin which will monitor Datafile usage.

Thanks in Advance

Regards
Ganeshan S

[hsmith]

If you look at the help page for check_oracle, will the --tablespace argument work for your scenario?

Help page:

Code: Select all

/usr/local/nagios/libexec/check_oracle -h

Code: Select all

check_oracle --tablespace <ORACLE_SID> <USER> <PASS> <TABLESPACE> <CRITICAL> <WARNING>

Code: Select all

--tablespace
   Check local database for tablespace capacity in ORACLE_SID
       --->  Requires Oracle user/password specified.
                --->  Requires select on dba_data_files and dba_free_space

[ganeshanrs1983]

For "check_oracle" plugin we have to install oracle client on nagios server and have to maintain tnsnames.ora file on /usr/local/nagios/etc directory now we are not using this method.

Could you please help me how to monitor the datafile usage through "oracle_health_check" plugin only.

[hsmith]

For "check_oracle" plugin we have to install oracle client on nagios server and have to maintain tnsnames.ora file on /usr/local/nagios/etc directory now we are not using this method.

Could you please help me how to monitor the datafile usage through "oracle_health_check" plugin only.

Is this the plugin you are referring to?