QUOTE (burleson @ Jul 17 2008, 05:55 PM)
>> Can anyone tell me how to setup Grid Control so I can receive email messages
Sure, you just use the OEM alert area, it's easy:http://www.dba-oracle.com/oracle10g_tuning/t_oem_alerts.htm
However, I don't think that it will have a "database down" alert because if the database and OEM crashes, there will be nothing to send the e-mail!
If I want a easy database down e-mail alert, I would cron a single shell script, something like this:
-- If PMON is up, exit
oracle_up=`ps -ef|grep $ORACLE_SID|grep pmon|wc -l`
if oracle_up > 0 then exit
sendmail . . . .
Ah, here is a script that works to e-mail if Oracle is down:http://www.dba-oracle.com/t_script_verify_...ase_running.htm
>> However, I don't think that it will have a "database down" alert because if the database and OEM crashes, there will be nothing to send the e-mail!
there is a way to set this up in oem/gc
invoke oem/grid control
select preferences from top right cornor
select Rules from notification tab on right
Create a rule
select Target type that you want to monitor this can be
database instance <<
Host << your server machine
OMS & repository
HTTP server, web cache and many more....
create rule -setup metric & notification method -- get email notification!