send me mail daily

[vulgate_2]

using cron ,system send me info daily.
But I dont konw what's important info about system health.
Now the script is
info.sh

bdf > /scripts/log
ps -aef | grep ora_ | grep -v grep >> /scripts/log
cat /scripts/log


then in cron ,call this script like below
0 6 * * * /scripts/info.sh | mailx -s `date "+%y/%m/%d"` vulgate@test.net

and any other else?

[Steven E. Protter · Accepted solution]

This thread contains lots of possible candidates for the scriptset you wish to run.

http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=178514

Bill McNamara is the illustrious author of this and two succeeding scripts that sysadmins should not be without.

SEP

[Julio Yamawaki]

Hi,

As I could see, you are just sending you a bdf output and all oracle processes (excepting listener).
I think you can do this a little better:
1. I sent an script to monitor filesystem usage in another thread, in that script, only filesystem with more than a % occupied space are sent to you
2. You can make a script to monitor ONLY processes in oracle that are no longer running (I particularly have a script like that running every 15 minutes)
3. You can make a script to monitor tablespaces usage
4. You can make a script that cut init.ora every day and send all ORA- errors in you e-mail
5. Also you can make a script that verify if all disk are CLAIMED
6. If you have mirror, you can make a script that verify if they are synchronized
7. In oracle, you can have a lot of scripts: monitor sga, large pool, log buffer, etc.

As you can see, you can control everything in your unix box with scripts.

Regards,

[Rick Garland]

Lots of ideas.

ioscan, sar, vmstat, nfsstat, vgdisplay, netconf, lanscan, etc.

The 'print_manifest' tool is a good one as well. Part of the Ignite package.

You can use built-in monitoring tools to only send mail when something is close to a threshold. Example, the EMS facility.

[renarios]

Hi,

Consider using the Oracle Enterprise Manager to monitor your Oracle database. It is a very powerfull (free) tool, which offers you the option to automatically repear errors.

Cheerio,

Renarios

[Bejoy C Alias]

If u can load EMS then that will be better to configure for sending mails about all the monitored services..