Home » RDBMS Server » Enterprise Manager » E-mail alerts in 12c (Oracle Database 12c Enterprise Edition Linux)
E-mail alerts in 12c [message #644050] Tue, 27 October 2015 06:13 Go to next message
Messages: 4
Registered: October 2015
Junior Member
I am looking for a way to set up e-mail alerts for some critical conditions that could affect database availability. In version 11g, I could use EM console (https://myserver:1158/em) for this purpose. I hoped to find similar functionality in EM Express for 12c (https://myserver:5500/em) but there seems to be nothing that allows to set up notification rules or notification methods. All the online references that I could find talk about this functionality in Enterprise Manager Cloud Control.

Is Cloud Control the only way to get e-mail alerts from 12c database, or am I missing something?
Re: E-mail alerts in 12c [message #644051 is a reply to message #644050] Tue, 27 October 2015 06:29 Go to previous message
John Watson
Messages: 8560
Registered: January 2010
Location: Global Village
Senior Member
Welcome to the forum. Please read our OraFAQ Forum Guide and How to use [code] tags and make your code easier to read

The alert mechanism hasn't changed in release 12.x. Configure your thresholds with dbms_server_alert, then set up your email notifications with code that dequeues the messages from the sys.alert_que queue. If you want to configure notifications through OEM, remember that you have to pay for it: Enterprise Edition plus Diagnostics Pack. If you do it programmatically, it is free in all editions.
Previous Topic: Process stucks while OEM Installation
Next Topic: Failed script
Goto Forum:

Current Time: Sat Jun 19 23:29:52 CDT 2021