Help - Search - Members - Calendar
Full Version: Email Notifications
Oracle DBA Forums > Oracle > Oracle Forum
Oraclelearner
Can anyone tell me how to setup Grid Control so I can receive email messages once my database goes down.

Thanks in advance,
Oraclelearner
burleson
Hi Learner,

>> 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:

CODE
#!/bin/ksh
-- If PMON is up, exit
oracle_up=`ps -ef|grep $ORACLE_SID|grep pmon|wc -l`
if oracle_up > 0 then exit
else
   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
Oraclelearner
QUOTE (burleson @ Jul 17 2008, 10:55 AM) *
Hi Learner,

>> 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:

CODE
#!/bin/ksh
-- If PMON is up, exit
oracle_up=`ps -ef|grep $ORACLE_SID|grep pmon|wc -l`
if oracle_up > 0 then exit
else
   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


Thank you Mr. Burleson
Asad
QUOTE (burleson @ Jul 17 2008, 05:55 PM) *
Hi Learner,

>> 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:

CODE
#!/bin/ksh
-- If PMON is up, exit
oracle_up=`ps -ef|grep $ORACLE_SID|grep pmon|wc -l`
if oracle_up > 0 then exit
else
   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

agent
ASM
database instance <<
Host << your server machine
listener
OC4J
OMS & repository
HTTP server, web cache and many more....

create rule -setup metric & notification method -- get email notification!
burleson
>> there is a way to set this up in oem/gc

Interesting! Thanks!

However, it will only fire if the instance crashes and the agent somehow survives . . . . .
SteveC
If GC is running on a separate server, you can get alerts about an instance running elsewhere. The value of the information is that you only know this: GC cannot contact the instance. Is that because the agent process failed, or because the instance crashed? You may still have the agent running, but there are problems with the agent not always showing the true/current/refreshed status of the instance.
Oraclelearner
Thanks! I appreciate everyone's reply.

Regards,
Oraclelearner
Asad
QUOTE (SteveC @ Jul 17 2008, 07:35 PM) *
If GC is running on a separate server, you can get alerts about an instance running elsewhere. The value of the information is that you only know this: GC cannot contact the instance. Is that because the agent process failed, or because the instance crashed? You may still have the agent running, but there are problems with the agent not always showing the true/current/refreshed status of the instance.


>> but there are problems with the agent not always showing the true...

we dont live in ideal world and this GC is not apart...... but having independant monitor on seperate machine for target is better solution than relying on host's cron i.e. hosting the target db. who is gonna send email notification when cron/host crashes...
SteveC
Why are you directing that to me? I don't have a question about how this works and what the limitations are.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.