WORKFLOW BACKGROUND PROCESS IS FAILING WITH ORA-7445 AND TXN ROLLBACK BY SMON (Doc ID 1667530.1)

Last updated on APRIL 15, 2017

Applies to:

Oracle Workflow - Version 12.1.3 and later
Oracle Database - Enterprise Edition - Version 11.2.0.3 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.

Symptoms

Oracle Workflow background process (WF Workflow Background Engine) is failing with ORA-07445 errors
when run for deferred purchase order Approval item types.

 

Database alert contains these ORA-07445 exception errors and each time is followed by
"SMON: Parallel transaction recovery tried"
indicating the transaction was killed and SMON is trying to rollback the transaction.

ORA-07445: exception encountered: core dump [WF_DIRECTORY: (Line342)()+14662] [SIGSEGV] [ADDR:0x3FFFDFFB000] [PC:0x3FFFB0BD9BE] [Invalid permissions for mapped object] []

ORA-07445: exception encountered: core dump [sskgds_getcall()+170] [SIGBUS] [ADDR:0x3FFFE000000] [PC:0x86E928CA] [Non-existent physical address] []

ORA-07445: exception encountered: core dump [kdxlin()+40] [SIGBUS] [ADDR:0x3FFFE000000] [PC:0x833515E8] [Non-existent physical address] []




Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms