Page 2 of 2
Re: Monitor Oracle DB from SAP User
Posted: Sat Dec 03, 2016 10:51 am
by 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.
Re: Monitor Oracle DB from SAP User
Posted: Mon Dec 05, 2016 1:31 pm
by avandemore
The Oracle plugin requires a Oracle user.
Re: Monitor Oracle DB from SAP User
Posted: Mon Dec 05, 2016 3:39 pm
by 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.
Re: Monitor Oracle DB from SAP User
Posted: Mon Dec 05, 2016 3:41 pm
by dwhitfield
@nietonoshana, thanks for jumping in!
@prasadt, does that help you out?
Re: Monitor Oracle DB from SAP User
Posted: Tue Dec 06, 2016 1:32 am
by 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.
Re: Monitor Oracle DB from SAP User
Posted: Tue Dec 06, 2016 10:03 am
by 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.