Hi guys / girls,

Wohoo my first post hahaha, *cough* sorry.

I wonder if anyone can help me or point me in the right direction.
I run several reports manually every day and was hoping to automate this process even if just a little.

What I have are several RHEL 5 systems running Oracle with sqlplus.
On the systems I do the following checks:

*confirm /u01 on the servers are not >50% used.
*check a log file for Specific ORA-**** Errors
*check CPU usage of ORACLE on the servers
*run a Select count(*) from dba_objects where status='INVALID' and confirm they not over a certain point.
and there are 2 or 3 other sql plus commands basically the same.

What I want is to generate a Report Automatically, Crystal report would have been Seriously HUGE winner here. though I have no idea if it can or not do the linux stuff.......

So any reporting Application you can suggest for this? or anyway I can get it done???

Thanks in advance for the assist and Time

-Digi

So how are you doing this?

*confirm /u01 on the servers are not >50% used.

df | cut?

*check a log file for Specific ORA-**** Errors

grep?

*check CPU usage of ORACLE on the servers

top or ps?

*run a Select count(*) from dba_objects where status='INVALID' and confirm they not over a certain point.

sqlplus | awk?

Personally, I'd just write a script running under cron that would check each item and call sendmail with any positive results. It's tricky, but pretty straightforward to do this all with regular unix utilities.

None of this stuff seems like fodder for Crystal reports or any complex layout. If I wanted a pretty report, I might make my script generate some TeX and attach a PDF file to the email, but, again, that's probably overkill.