Indexing Fails with Exception "Ora-04031: Unable To Allocate 32 Bytes Of Shared Memory" and "kglHeapInitialize:temp" (Doc ID 1449691.1)

Last updated on SEPTEMBER 16, 2016

Applies to:

Oracle WebCenter Content - Version 10.1.3.3.0 to 11.1.1.6.0 [Release 10gR3 to 11g]
Information in this document applies to any platform.

Symptoms

Upon attempt to start an index cycle, the indexing fails and the below exception is thrown. It is expected that indexing would start, run, and complete without error.

Exception:

>searchprovider/6 03.20 15:01:12.977 index rebuild work !csDbUnableToCreateResultSet,SELECT 1 FROM DUAL!$ORA-04031: unable to allocate 32 bytes of shared memory ("shared pool"\,"unknown object"\,"KGLH0^1ea38a7"\,"kglHeapInitialize:temp")

>searchprovider/6 03.20 15:01:12.978 index rebuild work {[index rebuild work.4(Not In Transaction) Active time: 330s]}
searchprovider/6 03.20 15:01:12.978 index rebuild work {( Action executed
searchprovider/6 03.20 15:01:12.978 index rebuild work SELECT 1 FROM DUAL )}
searchprovider/6 03.20 15:01:12.978 index rebuild work
searchprovider/6 03.20 15:01:12.978 index rebuild work Long connection active time at 3/20/12 3:01 PM for 330 (secs)
>searchprovider/6 03.20 15:01:12.978 index rebuild work !csJdbcConnectionFailure,\!csDbFailedToGetTableList\,\!$ORA-04031: unable to allocate 32 bytes of shared memory ("shared pool"\\\,"unknown object"\\\,"KGLH0^af76e51"\\\,"kglHeapInitialize:temp")

>(internal)/7 03.20 15:01:12.978 index rebuild work !csJdbcConnectionFailure,\!csDbFailedToGetTableList\,\!$ORA-04031: unable to allocate 32 bytes of shared memory ("shared pool"\\\,"unknown object"\\\,"KGLH0^af76e51"\\\,"kglHeapInitialize:temp")
(internal)/7 03.20 15:01:12.978 index rebuild work exception stack
(internal)/7 03.20 15:01:12.978 index rebuild work intradoc.data.DataException: !csJdbcConnectionFailure,\!csDbFailedToGetTableList\,\!$ORA-04031: unable to allocate 32 bytes of shared memory ("shared pool"\\\,"unknown object"\\\,"KGLH0^af76e51"\\\,"kglHeapInitialize:temp")
(internal)/7 03.20 15:01:12.978 index rebuild work
(internal)/7 03.20 15:01:12.978 index rebuild work at intradoc.jdbc.JdbcWorkspace.handleSQLException(JdbcWorkspace.java:2461)
(internal)/7 03.20 15:01:12.978 index rebuild work at intradoc.jdbc.JdbcWorkspace.getTableList(JdbcWorkspace.java:1441)
(internal)/7 03.20 15:01:12.978 index rebuild work at intradoc.data.WorkspaceUtils.doesTableExist(WorkspaceUtils.java:44)
(internal)/7 03.20 15:01:12.978 index rebuild work at intradoc.indexer.OracleTextCollectionHandler.checkCollectionExistence(OracleTextCollectionHandler.java:90)
(internal)/7 03.20 15:01:12.978 index rebuild work at intradoc.indexer.IndexerCollectionManager.doWork(IndexerCollectionManager.java:82)
(internal)/7 03.20 15:01:12.978 index rebuild work at intradoc.indexer.Indexer.doIndexing(Indexer.java:411)
(internal)/7 03.20 15:01:12.978 index rebuild work at intradoc.indexer.Indexer.buildIndex(Indexer.java:319)
(internal)/7 03.20 15:01:12.978 index rebuild work at intradoc.server.IndexerMonitor.doIndexing(IndexerMonitor.java:1021)
(internal)/7 03.20 15:01:12.978 index rebuild work at intradoc.server.IndexerMonitor$4.run(IndexerMonitor.java:841)
(internal)/7 03.20 15:01:12.978 index rebuild work Caused by: java.sql.SQLException: ORA-04031: unable to allocate 32 bytes of shared memory ("shared pool","unknown object","KGLH0^af76e51","kglHeapInitialize:temp")
(internal)/7 03.20 15:01:12.978 index rebuild work
(internal)/7 03.20 15:01:12.978 index rebuild work at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:457)
(internal)/7 03.20 15:01:12.978 index rebuild work at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
(internal)/7 03.20 15:01:12.978 index rebuild work at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:889)
(internal)/7 03.20 15:01:12.978 index rebuild work at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:476)
(internal)/7 03.20 15:01:12.978 index rebuild work at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:204)
(internal)/7 03.20 15:01:12.978 index rebuild work at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:540)
(internal)/7 03.20 15:01:12.978 index rebuild work at oracle.jdbc.driver.T4C

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