Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2010
    Location
    South Africa - JHB
    Posts
    2

    Question RHEL 5,Oracle, SQLPlus Reporting

    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

  2. #2
    Join Date
    Oct 2002
    Location
    Baghdad, Iraq
    Posts
    697
    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.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •