OWB Runtime Repository Assistant Fails With ORA-04031
(Doc ID 341303.1)
Last updated on OCTOBER 11, 2019
Applies to:
Oracle Warehouse Builder - Version 10.1 and laterInformation in this document applies to any platform.
Symptoms
Installing the OWB Repository fails with:
ORA-04031: unable to allocate 4032 bytes of shared memory ("java pool")
ORA-06512: at "SYS.DBMS_JAVA", line 313
ORA-06512: at "SYS.DBMS_JAVA", line 313
The complete error message in the installation log file is:
oracle.wh.util.DebugUtility: [processSQLDBAToken]: Script Name is ../../rtasst/platform_system_rights.sql
java.sql.SQLException: ORA-04031: unable to allocate 4032 bytes of shared memory ("java pool","oracle/jdbc/driver/FloatBind...","joxlod exec hp","SGAClass")
ORA-06512: at "SYS.DBMS_JAVA", line 313
ORA-06512: at line 2
[ at runSqlScript(RuntimeInstaller.java ) ].
this is SQL error: continue =false
SQLException: ORA-04031: unable to allocate 4032 bytes of shared memory ("java pool","oracle/jdbc/driver/FloatBind...","joxlod exec hp","SGAClass")
ORA-06512: at "SYS.DBMS_JAVA", line 313
oracle.wh.util.DebugUtility: java.sql.SQLException: ORA-04031: unable to allocate 4032 bytes of shared memory ("java pool","oracle/jdbc/driver/FloatBind...","joxlod exec hp","SGAClass")
ORA-06512: at "SYS.DBMS_JAVA", line 313
ORA-06512: at line 2
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:630)
at oracle.jdbc.driver.T2CCallableStatement.execute_for_describe(T2CCallableStatement.java:846)
at oracle.jdbc.driver.T2CCallableStatement.execute_for_rows(T2CCallableStatement.java:1007)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1028)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2888)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:2979)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4103)
at oracle.wh.ui.install.reposinst.RuntimeInstaller.parseAndRunSqlScript(RuntimeInstaller.java:614)
at oracle.wh.ui.install.reposinst.ReposInstMain.processSQLDBAToken(ReposInstMain.java:2918)
at oracle.wh.ui.install.reposinst.ReposInstMain.processDriverFile(ReposInstMain.java:2331)
at oracle.wh.ui.install.reposinst.ReposInstMain$2.runTask(ReposInstMain.java:1824)
at oracle.ewt.thread.TaskScheduler.runTask(Unknown Source)
at oracle.ewt.thread.TaskScheduler.processTask(Unknown Source)
at oracle.ewt.thread.TaskScheduler$TaskQueue.run(Unknown Source)
at oracle.ewt.timer.Timer.doRun(Unknown Source)
at oracle.ewt.timer.Timer.run(Unknown Source)
at java.lang.Thread.run(Thread.java:534)
Assistant operation is unsuccessful ...
java.sql.SQLException: ORA-04031: unable to allocate 4032 bytes of shared memory ("java pool","oracle/jdbc/driver/FloatBind...","joxlod exec hp","SGAClass")
ORA-06512: at "SYS.DBMS_JAVA", line 313
ORA-06512: at line 2
[ at runSqlScript(RuntimeInstaller.java ) ].
this is SQL error: continue =false
SQLException: ORA-04031: unable to allocate 4032 bytes of shared memory ("java pool","oracle/jdbc/driver/FloatBind...","joxlod exec hp","SGAClass")
ORA-06512: at "SYS.DBMS_JAVA", line 313
oracle.wh.util.DebugUtility: java.sql.SQLException: ORA-04031: unable to allocate 4032 bytes of shared memory ("java pool","oracle/jdbc/driver/FloatBind...","joxlod exec hp","SGAClass")
ORA-06512: at "SYS.DBMS_JAVA", line 313
ORA-06512: at line 2
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:630)
at oracle.jdbc.driver.T2CCallableStatement.execute_for_describe(T2CCallableStatement.java:846)
at oracle.jdbc.driver.T2CCallableStatement.execute_for_rows(T2CCallableStatement.java:1007)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1028)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2888)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:2979)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4103)
at oracle.wh.ui.install.reposinst.RuntimeInstaller.parseAndRunSqlScript(RuntimeInstaller.java:614)
at oracle.wh.ui.install.reposinst.ReposInstMain.processSQLDBAToken(ReposInstMain.java:2918)
at oracle.wh.ui.install.reposinst.ReposInstMain.processDriverFile(ReposInstMain.java:2331)
at oracle.wh.ui.install.reposinst.ReposInstMain$2.runTask(ReposInstMain.java:1824)
at oracle.ewt.thread.TaskScheduler.runTask(Unknown Source)
at oracle.ewt.thread.TaskScheduler.processTask(Unknown Source)
at oracle.ewt.thread.TaskScheduler$TaskQueue.run(Unknown Source)
at oracle.ewt.timer.Timer.doRun(Unknown Source)
at oracle.ewt.timer.Timer.run(Unknown Source)
at java.lang.Thread.run(Thread.java:534)
Assistant operation is unsuccessful ...
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 |