Oracle monitoring error

[Mike]

Hello ,


I want to monitor services running in the oracle DB server , I have configured through wizard of oracle tablespace and oracle serverspace but we are getting some errors on the Status information column .

a) DB-Lib error message 20009,severity9:

b) (return code of 127 is out of bounds-plugins may be missing) oracle nagios

c) Critical cannot connect to .ORA-12504:TNS:listner was not given the SERVICE_NAME is CONNECT_DATA(DBD ERROR:OCI server Attached)


1) We have gone through the check_oracle_health plugin but not able to configure it can you send us the proper Document of how to configure the check_oracle_health plugin.

2) What all information we require of oracle DB to monitor, only username and password is enough..

3) I want to monitor service of Oracle DB through SNMP , can you send me the proper document for the same

4) Do we require to install check_oracle_health plugin on nagios server and also on Oracle DB server for monitoring the servies

[abrist]

First of all, have you walked through our oracle plugin document?
http://assets.nagios.com/downloads/nagi ... lation.pdf

a) DB-Lib error message 20009,severity9:
b) (return code of 127 is out of bounds-plugins may be missing) oracle nagios
c) Critical cannot connect to .ORA-12504:TNS:listner was not given the SERVICE_NAME is CONNECT_DATA(DBD ERROR:OCI server Attached)

The errors above may very well be solved by following the document. It does not look like the plugin is installed correctly and your library paths may be incorrect/non-existent.

1) We have gone through the check_oracle_health plugin but not able to configure it can you send us the proper Document of how to configure the check_oracle_health plugin.

Above.

2) What all information we require of oracle DB to monitor, only username and password is enough..

At minimum you will need username, password, SID/servicename. Additionally, you will have to configure a couple of listener files on the oracle server to allow the nagios XI server to access it.

3) I want to monitor service of Oracle DB through SNMP , can you send me the proper document for the same

Do you know the oids/mibs you wish to check? Is the oracle server configured for snmp monitoring?

4) Do we require to install check_oracle_health plugin on nagios server and also on Oracle DB server for monitoring the servies

No, the plugin must only be installed on the XI server, but you will have to follow our document to get the environment setup.

[Mike]

Hello,

Thank you for the below help , it was a great info.


I have gone through the oracle query wizard.
Is It the same way in which we query the oracle database and we get the output.

for eg : if i enter the same oracle query in nagios query wizard for open cursor

select a.value, s.username, s.sid, s.serial# from v$sesstat a, v$statname b, v$session s where a.statistic# = b.statistic# and s.sid=a.sid and b.name = 'opened cursors current';


will this work same in nagios query wizard as in oracle DB.

Regards,

[sreinhardt]

If this is a valid oracle query that returns a single result then yes it should work.