Monitor Oracle DB from SAP User

[ruffsense]

The SAP user has permissions to the DB. So it's credentials and username must be on the DB or in a group.

Read or write permissions. Ask the DB owner.

[avandemore]

The Oracle plugin requires a Oracle user.

[nietonoshana]

Hello the file README say:

How to prepare the database for monitoring
--------------------------------------
create user nagios identified by 'whatever';
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;

on 8.x the user must be granted the SELECT_CATALOG_ROLE
grant select_catalog_role to nagios;
instead of "grant select any dictionary..."

If you monitor the oracle 7.x database at the local computer museum:
grant select on V_$SYSSTAT to nagios;
grant select on sys.dba_tablespaces to nagios;
grant select on sys.dba_free_space to nagios;
grant select on sys.dba_data_files to nagios;

change nagios for SAP user and the permission needs its a grant. You do not need to create a user if you already have it.

[dwhitfield]

@nietonoshana, thanks for jumping in!

@prasadt, does that help you out?

[prasadt]

@ avandemore,
If we don't install Oracle plugin in nagiosxi server and don't want to use Orcale configuration wizard, In that case Is it possible to install any SAP plugin where we can provide SAP user credentials who is having permission to DB.

Our final goal is to monitor Oracle DB from SAP user. The SAP user has permission to DB.
To achieve this, If you suggest to install oracle plugin or any SAP plugin, we are ready for that.

@ nietonoshana,
I didn't understand, "change nagios for SAP user and the permission needs its a grant. You do not need to create a user if you already have it." Kindly give some clarity on this.

@ dwhitfield,
Still its not resolved.

[dwhitfield]

Can you draw us a diagram and upload the image? What you are saying still doesn't make sense, if I understand you correctly.

It sounds like you want to monitor Oracle without an Oracle plugin of any sort. Unless you want to rewrite a different plugin to suit your needs, that isn't going to work.