WORKFLOW BACKGROUND PROCESS IS FAILING WITH ORA-7445 AND TXN ROLLBACK BY SMON
(Doc ID 1667530.1)
Last updated on AUGUST 02, 2024
Applies to:
Oracle Workflow - Version 12.1.3 and laterOracle Database - Enterprise Edition - Version 11.2.0.3 to 11.2.0.4 [Release 11.2]
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
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] []
"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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |