OBIA 7964 ETL Failure With The Error Message 'ORA-04031: unable to allocate 32 bytes of shared memory' As the Data Warehouse Database Has Insufficient Memory Resources (Doc ID 2004293.1)

Last updated on JANUARY 31, 2017

Applies to:

Business Intelligence Applications Consumer - Version 7.9.6.4 and later
Information in this document applies to any platform.

Symptoms

BI Apps 7.9.6.4. ETL fails with the following error message at runtime in the 'SDE_ORA_TransactionSourceDimension_PurchaseReceipt' Mapping :-


ErrorCode : 0
2197 SEVERE Sat Apr 25 13:43:58 AST 2015
ANOMALY INFO::: Error while validating the connection with the sql
SELECT SYSDATE AS CURRENT_TS FROM DUAL
MESSAGE:::ORA-04031: unable to allocate 32 bytes of shared memory ("shared pool","SELECT SYSDATE AS CURRENT_TS...","SQLA","tmp")

EXCEPTION CLASS::: java.sql.SQLException

oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191)
oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523)
oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
..
..
java.lang.Thread.run(Thread.java:619)
2339 SEVERE Sat Apr 25 13:45:34 AST 2015 Number of running sessions : 10
2340 SEVERE Sat Apr 25 13:45:35 AST 2015 MESSAGE:::ORA-04031: unable to allocate 32 bytes of shared memory ("shared pool","DATABASE","KKTIN^ae4fab53","kglHeapInitialize:temp")
ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 32 bytes of shared memory ("shared pool","select obj#,type#,ctime,mtim...","SQLA","tmp")

EXCEPTION CLASS::: java.sql.SQLException

oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:389)
oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:382)
oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:427)

 

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