Tip of the week: Resolving 12C Cloud Control database backup notification issues.
August 27, 2012 Leave a comment
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.
Apply the EM 12c BP1( per Doc ID 1430518.1) patch to resolve this issue, as it has included the fix of bug 13334194.
Mandatory Enterprise Manager Cloud Control 12c Release 220.127.116.11 Bundle Patch 1 (BP1) for all available platforms (Doc ID 1430518.1)
Document 1395505.1 – Announcing Enterprise Manager Cloud Control 12c Release 18.104.22.168 Bundle Patch 1(BP1) and 22.214.171.124 Plug-ins.
EM 12c How to Configure Notifications for Job Executions? (Doc ID 1386816.1)