OWB Runtime Repository Assistant Fails With ORA-04031

(Doc ID 341303.1)

Last updated on MAY 05, 2017

Applies to:

Oracle Warehouse Builder - Version 10.1 and later
Information 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

 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 ...


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