Monitor Oracle DB from SAP User

[prasadt]

Dear Team,

Please clarify the monitoring of Oracle DB from SAP user.

We have Oracle DB installed and we have Oracle DB user. But we want to monitor Oracle DB from SAP User. IS it Possible to get metrics detail from SAP User.


Thanks and Regards,
Prasad

[dwhitfield]

Hi @prasadt!

What exactly do you mean by "SAP User"? Are you asking if you need to make a new user to monitor a second DB? The answer to that is no.

I think you will find https://assets.nagios.com/downloads/nag ... Rights.pdf useful for managing multiple users.

Please let us know if you have additional questions!

[tmcdonald]

In our Oracle monitoring wizards there is a field for a username and password. As long as that user has sufficient permissions to run the required queries, it should work.

[prasadt]

That User doesn't belongs to Oracle DB. Instead of Oracle, user is present in SAP and only that particular user have access to run queries into Oracle DB.

Kindly help me to achieve this.

[avandemore]

You should consult your SAP administrator and find out what account is conducting the Oracle queries. You can then include that information in the Oracle monitoring wizard.

[prasadt]

Can i simply give the SAP user details in Oracle Configuration Wizard?

There is no need to do some extra configuration like any custom plugin or something like that. Correct me If I am wrong.

[avandemore]

The Oracle wizard expects credentials to an Oracle database. If you want to monitor SAP, there are some other plugins here:

https://exchange.nagios.org/directory/P ... -Logic/SAP

Please note those are 3rd party plugins provided as-is. Here is some information about creating your own plugins:

https://nagios-plugins.org/doc/guidelines.html
https://mathias-kettner.de/checkmk_localchecks.html
http://www.yourownlinux.com/2014/06/how ... cript.html

We also offer custom development for a fee. Please contact [email protected]

[prasadt]

Let me explain 1 more time about our requirement.

Suppose we have a SAP user:
username : sapadmin
password : sapadmin

We have created this user in SAP and given access to this user to run queries in Oracle DB.

So, Can we directly give this user credentials in Oracle Configuration Wizard? Will it work?

Or else, we need to do something else?

[mcapra]

You will need a user that exists in Oracle's internal table space. The SAP user might work, but we have no way of really knowing if the credentials for the SAP user are the same as those in the internal Oracle table space.

[prasadt]

In Oracle, we don't have any user present.

We only have a user present in SAP and we want to monitor Oracle DB (Query,Tablespace, Serverspace) from that particular user only.