Wednesday, January 16, 2013

oracle Alerts erroring with Signal 11 R12 oracle applications

Oracle Alerts started failing in Production environment(R12 12.1.3 applications) one fine day with error Signal 11.
I am sure Signal 11 error no one likes to see and its points to no where.
 To fix the issue was big nightmare and since it was production the pressure was too much.
This issue started after normal patching activity which went through without issue.

Thier is one metalink hit "What To Consider When Receiving A Signal 11 In Oracle Alerts? (Doc ID 1354644.1)"
but this gives 3 patches to applied

Patch 13728376 - Alert fails with signal 11 error after password case sensitivity fix.
Patch 9908378 - RELEASE 12 BUG FOR SIGNAL 11 WITH ALPPWF
Patch 8728439 - R12.ALR.B - CC AND BCC RECIPIENTS SHOWN IN TO FIELD IN ALERT MAILS


We clone Prod to test instance,reproduced the error and applied patch  "
Patch 13728376 - Alert fails with signal 11 error after password case sensitivity fix." and issue got fixed in test environment.

we move the patch to PROD and things started working fine.

thanks,
Edwin.K













 

No comments:

Post a Comment