Monitoring Oracle Databases.

[monitoreo1]

Hi !!!!!

We are starting to monitoring Oracle Databases using the plugins that the Nagios Enterprise Version includes:

Oracle Query Monitoring Wizard
Oracle Serverspace Monitoring
Oracle Tablespace Monitoring

Do you know what level of authority need the user "nagios" (the user that will be used for generate the conecction from nagios to the BD ) to connect to the databases?

Thanks for your help !!!!

[Box293]

Have a look at the following link:
http://labs.consol.de/nagios/check_oracle_health/

Specifically the section "Preparation of the database" and also "Authentication".

Does this help?

[monitoreo1]

Hi again !!!!

We tried following the processes suggested:

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;

But, when we tried to generate the permissions over the objects:
V_$SYSSTAT
V_$INSTANCE
V_$LOG
SYS.DBA_DATA_FILES
SYS.DBA_FREE_SPACE

We have a messages that says that the objects do not exist.

Thanks for your help !!!!

[Box293]

Can you please provide the full command you are executing at the CLI and the output it produces.

[monitoreo1]

Thanks for your help !!!!

We was doing something, in incorrect mode !!!!

Now, we have the permissions and we will start to taste the plugins.

Thanks again !!!!

[jdalrymple]

Please alert us if you need further assistance, or otherwise let us know if we can lock this thread.

Thanks

[monitoreo1]

Thanks for your help !!!!

At this moment all is ok !!!!

Thanks again !!!!