Tip of the week: Resolving 12C Cloud Control database backup notification issues.


Scenario:

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>spool output.html
SQL>select * from mgmt_targets where target_name=’PRD1′;
SQL>select * from mgmt_notification_log;
SQL>spool off
2.2 Set EM 12c OMS to DEBUG level
cd <OMS_HOME>/bin
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

Resolution:

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.

Reference:

Mandatory Enterprise Manager Cloud Control 12c Release 12.1.0.1 Bundle Patch 1 (BP1) for all available platforms (Doc ID 1430518.1)
Document 1395505.1 – Announcing Enterprise Manager Cloud Control 12c Release 12.1.0.1 Bundle Patch 1(BP1) and 12.1.0.2 Plug-ins.

EM 12c How to Configure Notifications for Job Executions? (Doc ID 1386816.1)

About these ads

About Sunthar Tharmalingam
Bio: Sunthar is an Oracle Certified Professional with over 14 years of experience in multifaceted architectural design and implementation of mission-critical global Oracle Applications. He provides technical leadership to the enterprise project teams and manages the comprehensive implementation life-cycle. Sunthar has exhaustive hands-on competencies in vital Oracle technologies such as Oracle E-Business Suite, Databases, OBI Applications, Oracle Identity Management and Webcenter suites. This Blog has been categorized according to the Oracle products that integrates with Oracle E-Business Suite. Should you wish to participate as an author for a related module or category please register as a member and mail me to let me know which category you would like to write under.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: