Monitoring Oracle tablespaces without password

[dc7772000]

Hi Folks,

I've been trying to find a way to obtain tablespace information without the Oracle user password. I'm aware of the method of logging into SQLPLUS using the '/' and can execute sql scripts to obtain the tablespace information which is then ported into a text file. However, I'm having a lot of trouble sending that text file into Nagios. The text file is in this format:

Tablespace Used MB Free MB Total MB Pct. Free
------------- ----------- ----------- ----------- ----------
RPTNETTBS 312 488 800 61
UNDOTBS1 363 137 500 27
etc...

Other than getting the password, is there a method of either getting the tablespace information directly into Nagios or parsing the text file into a Nagios usable format?

Thanks.

David

[rkennedy]

I suspect a bash wrapper script could do this by grepping the information you're looking for in a text file. This would mean though that you need to output a new file from Oracle every x minutes/hours though to keep the XI information up to date. Is that what you're looking to do?

What exactly are you trying to monitor in the file?