My Oracle Support Banner

On R12 With 11g Database Getting ORA-03137 & ORA-03149 In Database alert.log (Doc ID 1986072.1)

Last updated on DECEMBER 03, 2019

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)


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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.