After the upgrade of database from 18.104.22.168 to 10.2.0.3, the DBA team was applying pre-requisite patches of ATG_PF.H RUP5, One of these patches is 5395066 (DOCUMENTATION FOR ORACLE REPORT MANAGER FRM.H ). While applying this patch, all workers failed on process FNDGFU. The worker log showed "afpexcp failed due to ORA-03114: not connected to ORACLE". The database alert log showed:
ORA-07445: exception encountered: core dump [drurnew()+184] [SIGSEGV] [Address not mapped to object] [0x000000040]
On investigation, we found that it was a known Oracle bug # 5587976. The solution is to apply database patch 5587976. Once you apply this patch on your database through opatch and resume the failed patch, no errors are reported.
Blog dedicated to Oracle Applications (E-Business Suite) Technology; covers Apps Architecture, Administration and third party bolt-ons to Apps