Oracle Monitoring

[bisana]

Hi
I am trying to monitor , Oracle Database
a> Table Space
b> No of Database Logs
c>Availability of tnslsnr
Can I monitor the above parameter using Zabbix , guidance requested
Thanks
Joseph john

[cameronsto]

I'm not sure of the commands you would need to do, but Zabbix supports custom user parameters. For example, I'm able to monitor MySQL using these user parameters:
UserParameter=mysql[uptime],/usr/bin/mysqladmin -uuser -ppass status|cut -f2 -d":"|cut -f1 -d"T"
UserParameter=mysql[threads],/usr/bin/mysqladmin -uuser -ppass status|cut -f3 -d":"|cut -f1 -d"Q"
UserParameter=mysql[qps],/usr/bin/mysqladmin -uuser -ppass status|cut -f9 -d":"
Then within the web interface I add the item to the host by using the keys:
mysql[uptime]
mysql[threads]
mysql[qps]
You could do the same thing with Oracle assuming there are ways to get the stats you want through the command line.

-cameron

edited for formatting

[elkor]

Yes.

your best bet is to work with your oracle DBA(s) and have them write a couple of quick sql scripts to retrieve the data you are interested in, then either have the agent execute them as above or run them out of cron and read the data from a file or something. Note: it's been my experience that the oracle user tends to have a pretty specific environment, if you are having the agent run it you might want to at least source their profile if you run into problems.

I know that oracle 10enterprise has an internal mech. for keeping track of all of this data and it stores it in a special table.. that may be all you need to look at, again.. check with your DBA