On R12 With 11g Database Getting ORA-03137 & ORA-03149 In Database alert.log
(Doc ID 1986072.1)
Last updated on MAY 16, 2024
Applies to:
Oracle E-Business Suite Diagnostics - Version 12.1.3 to 12.1.3 [Release 12.1]Information in this document applies to any platform.
Symptoms
On : 12.1.3 version, Applications DBA when attempting to run Cost Worker job the following error occurs.
ORA-04030: out of process memory when trying to allocate 32 bytes (callheap,kdbmal allocation)
ORA-04030: out of process memory when trying to allocate 56 bytes (callheap,qerrmbv[]: qerrmObnd)
and
ORA-03137: TTC protocol internal error : [3149] [] [] [] [] [] [] []
ORA-03149: Invalid Oracle error code
select count(*) into :b0 from WIP_COST_TXN_INTERFACE where ((ORGANIZATION_ID=:b1 and WIP_ENTITY_ID=DECODE(:b2,(-1),WIP_ENTITY_ID,:b2)) and WIP_COST_TXN_INTERFACE.PROCESS_STATUS=3)
ORA-04030: out of process memory when trying to allocate 56 bytes (callheap,qerrmbv[]: qerrmObnd)
and
ORA-03137: TTC protocol internal error : [3149] [] [] [] [] [] [] []
ORA-03149: Invalid Oracle error code
select count(*) into :b0 from WIP_COST_TXN_INTERFACE where ((ORGANIZATION_ID=:b1 and WIP_ENTITY_ID=DECODE(:b2,(-1),WIP_ENTITY_ID,:b2)) and WIP_COST_TXN_INTERFACE.PROCESS_STATUS=3)
The issue can be reproduced at will with the following steps:
1. Upgrade db to 11.2.0.3
2. Trying to run
Bills of Material: Version : 12.0.0
CMCACW module: Actual Cost Worker
Failing Transaction ID is 17212241.000000 in trace file
3. Get error in database alert.log
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 |