ORACLE rdbms monitoring

[LEM]

Hi,

is there anyone who already set up some ORACLE monitoring using ZABBIX?

In fact, I plan to use ZABBIX to assume some "basic" monitoring of my Oracles servers. By basic, I mean more than just the listener availabiliy : some "base" checks related to tablespace left space, left extends, contiguous space ...

I imagine there is (at least) to way to do it the KISS way (Keep It Stupid and Simple) :
. via SNMP : but will need to install a SNMP agent if not exist.
. via sqlplus : as shipped 'by default' with any Oracle server install.

I guess I'm gonna use the sqlplus method, as it seems it's a KISS method... But I lack badly any skill on Oracle/sqlplus...

As anyone already done some jobs/config that way ? If yes, can you please describe your settings/methods please?


TIA,
--
lem

[mabinogi]

for simple listener availability, tnsping might be easier to work with than sqlplus.
also "lsnrctl status" might be of use.

If you actually want to run queries to test, then a perl script (using DBI) might be the way to go, rather than attempting to parse the output from sqlplus.

[LEM]

for simple listener availability, tnsping might be easier to work with than sqlplus.
also "lsnrctl status" might be of use.

right. simplier to test listener availability.


If you actually want to run queries to test, then a perl script (using DBI) might be the way to go, rather than attempting to parse the output from sqlplus.
I would like to test some "basic" values as, per tablespace, usage and free space, next extend and contiguous space for extend left.

I'm gonna search for more and report which method I use.

Anyway, thanks for any ideas/scripts/example of uses already done with zabbix :-)

Cheers,

[sjbalaji]

HI Lem,
Did you resolved your issue ?

[thiagomz]

Lem,

Any news about oracle monitoring ?