java.sql.SQLException

ORA-00604: error occurred at recursive SQL level 1ORA-04031: unable to allocate 4200 bytes of shared memory ("shared pool","unknown object","sga heap","state objects")

Solutions on the web14754

  • via Oracle Community by 539988, 10 months ago
    ORA-00604: error occurred at recursive SQL level 1ORA-04031: unable to allocate 4200 bytes of shared memory ("shared pool","unknown object","sga heap","state objects")
  • via Oracle Community by 539988, 11 months ago
    ORA-00604: error occurred at recursive SQL level 1ORA-04031: unable to allocate 4200 bytes of shared memory ("shared pool","unknown object","sga heap","state objects")
  • via oracle.com by Unknown author, 1 year ago
    ORA-00604: error occurred at recursive SQL level 1ORA-04031: unable to allocate 4200 bytes of shared memory ("shared pool","unknown object","sga heap","state objects")
  • Stack trace

    • java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1ORA-04031: unable to allocate 4200 bytes of shared memory ("shared pool","unknown object","sga heap","state objects") at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:169) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208) at oracle.jdbc.ttc7.O3log.receive2nd(O3log.java:515) at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:256) at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:252) at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:365) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:260) at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290) at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:816) at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:95) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540) at com.hutchison3g.voiprecording.directlogin.database.DBManager.getConnection(DBManager.java:26) at com.hutchison3g.voiprecording.directlogin.database.DBManager.executeStatement(DBManager.java:153) at com.hutchison3g.voiprecording.directlogin.main.DirectLogin.main(DirectLogin.java:29)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown user
    2 times, 2 months ago
    Unknown user
    Once, 1 year ago
    Unknown user
    2 times, 1 year ago
    Unknown user
    Once, 1 year ago
    Once, 6 months ago
    28 more bugmates