Unable to monitor database parameters

[RIDS_I2MP]

Hi Team,

We are unable to monitor few parameters of database on some of the database servers, whereas we are able to monitor TNSping, process usage etc. on same database using same script:

1. sga-data-buffer-hit-ratio
2. sga-library-cache-hit-ratio
3. tablespace-fragmentation
4. tablespace-usage
5. corrupted blocks

Please find the attached snapshot for error message.

Kindly suggest.

using same script we are able to monitor same parameters on other database but facing issue on some other database.

[SteveBeauchemin]

Usually, if it works for one, but not another, it is the "Preparation of the Database" as shown from the source web site.
https://labs.consol.de/nagios/check_ora ... index.html
Have the DBA verify.

Steve B

[mcapra]

Thanks @SteveBeauchemin!

@RIDS_I2MP can you verify with your DBA that all the preparation steps were taken? Improperly preparing the database is what causes the vast majority of these problems.

[RIDS_I2MP]

Hi Team,

Can you help us to know which parameters or settings we should check regarding DB to troubleshoot this issue.

[mcapra]

Here's all the grants mentioned on the plugin's page:

Code: Select all

create user nagios identified by oradbmon;
grant create session to nagios;
grant select any dictionary to nagios;
grant select on V_$SYSSTAT to nagios;
grant select on V_$INSTANCE to nagios;
grant select on V_$LOG to nagios;
grant select on SYS.DBA_DATA_FILES to nagios;
grant select on SYS.DBA_FREE_SPACE to nagios;
--
-- if somebody still uses Oracle 8.1.7...
grant select on sys.dba_tablespaces to nagios;
grant select on dba_temp_files to nagios;
grant select on sys.v_$Temp_extent_pool to nagios;
grant select on sys.v_$TEMP_SPACE_HEADER  to nagios;
grant select on sys.v_$session to nagios;

[RIDS_I2MP]

Thanks team for the help.

It worked by giving the 'nagios' user above permissions.