RHEL 5
Hi Guys / Girls,
Im hoping that someone can help me out by some small chance.
Im currently a (very very new and trying to learn things rapidly) DBA, we have reports that we manually do on our RHEL5 servers all the time as well as SQLPLUS and Oracle, Im also asking there so dont worry :P
What I want to do is Create some sort of report that can On demand create a report that I design, that has various things on it.
for instance from our linux servers I get things like avaliable disk space on the /u01 partition using df -hl
and I look at the one file and ensure there are no errors using less /u01/*****.log
on SQL there are a few different things I check on the ORACLE services such as invalid counts etc etc. all the commands are avaliable if needed.
But now what I want to know is this, is there possibly a open source reporting service that can return this information and arrange it as I need it too????
Thanks in advance for all your assist.
Comments
OK I know what your refering to as far as shell scripting goes. BUT:blink:
I have Zero idea how to accomplish this.
Can you assist with a example please????
just on this basically.
I would need the data displayed returned.
ssh [email protected]
bob123 ~password
df -hl ~ Print out needed
su - oracle
sqlplus /"as sysdba"
select count(*) from dba_objects where status='INVALID'; ~SQL Command that will need to return value
And this would have tp repeat for proddb1-4
Sorry for being a pain in the behind. Hope you can assist
You almost already have the script, the issue we have now is that it will need to be two seperate scripts one run from the root user and one for the oracle user, you can schedule them in the crontabs file. The reason for the seperation is that you do not want a script to hold a username or password especially on an oracle server.
for root:
for oracle
Ill look at it and get back to you if need be, atleast now have a better Idea what I can do
Thanks again.