I am scheduling my RMAN daily backups via OEM 12c. My goal is that the email notification includes the full log, rather than just the status of results. I was able to do this in 11g fairly easily. I have created a ticket with Oracle, to which they have responded that this may not be possible with 12c. I find that hard to believe. I am probably missing something silly. Any help is greatly appreciated.
In 12c CC, after scheduling database backup job and configuring email notification, system doesn’t successfully email the status of the backup jobs. Email notification within 12c would work otherwise. Interestingly, the notification would not work just for database backup jobs.
Steps to diagnose the issue:
1.Please ensure your database target ‘yourdb’ in issue has been listed in the ‘Job Events For Targets’ by navigating to EM 12c -> Setup -> Incidents -> Job Events
2.If the above doesn’t help, then please do:
2.1 Log on the repository db of EM 12c as SYSMAN user to query the following then upload the output.html file for checking
SQL>set markup html on spool on
SQL>select * from mgmt_targets where target_name=’PRD1′;
SQL>select * from mgmt_notification_log;
2.2 Set EM 12c OMS to DEBUG level
emctl set property -name log4j.rootCategory -value ‘DEBUG, emlogAppender, emtrcAppender’ -module logging
2.3 Then reproduce this issue.
If you find below errors in <gc_inst>/em/EMGC_OMS1/sysman/log/emoms.trc, then perform the below mentioned Resolution to resolve the issue.
2012-08-23 17:05:51,519 [DeliveryThread-EMAIL6] WARN notification.pbs logp.251 – Delivery.run: java.util.MissingResourceException: Can’t find bundle for base name oracle.sysman.db.rsc.rec.BackupJobMsg, locale en_US
java.util.MissingResourceException: Can’t find bundle for base name oracle.sysman.db.rsc.rec.BackupJobMsg, locale en_US
As per the uploaded file emoms_pbs.trc, it shows the exactly same error messages described in the bug 13334194.