Page 1 of 1
Oracle Datafile Usage
Posted: Tue Aug 11, 2015 5:33 am
by 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
Re: Oracle Datafile Usage
Posted: Tue Aug 11, 2015 9:42 am
by 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
Re: Oracle Datafile Usage
Posted: Wed Aug 12, 2015 9:37 am
by 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.
Re: Oracle Datafile Usage
Posted: Wed Aug 12, 2015 4:35 pm
by hsmith
ganeshanrs1983 wrote: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?