Indexing Fails with the Exception "Ora-04031: Unable To Allocate 32 Bytes Of Shared Memory" and "kglHeapInitialize:temp"
(Doc ID 1449691.1)
Last updated on MARCH 05, 2024
Applies to:
Oracle WebCenter Content - Version 10.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
>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
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 |