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")

Oracle Community | 539988 | 1 decade ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    SQL ERROR

    Oracle Community | 1 decade ago | 539988
    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")
  2. 0

    SQL ERROR

    Oracle Community | 1 decade ago | 539988
    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")
  3. 0

    SQL ERROR | Oracle Community

    oracle.com | 1 year ago
    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")
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Thalai Muthu Oracle Apps DBA: oracle.apps.fnd.common.PoolException: Exception creating new Poolable object.;

    blogspot.com | 2 years ago
    oracle.apps.fnd.common.AppsException: oracle.apps.fnd.common.PoolException: Exception creating new Poolable object.
  6. 0

    S√łgning

    mysam.dk | 1 year ago
    java.sql.SQLException: ORA-28040: No matching authentication protocol

  1. rp 1 times, last 4 months ago
26 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. 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()
  2. oracle.jdbc.dbaccess
    DBError.throwSqlException
    1. oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:169)
    1 frame
  3. oracle.jdbc.ttc7
    TTC7Protocol.logon
    1. oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
    2. oracle.jdbc.ttc7.O3log.receive2nd(O3log.java:515)
    3. oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:256)
    3 frames
  4. Oracle jdbc
    OracleDriver.connect
    1. oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:252)
    2. oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:365)
    3. oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:260)
    3 frames
  5. Commons DBCP
    PoolableConnectionFactory.makeObject
    1. org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37)
    2. org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)
    2 frames
  6. Commons Pool
    GenericObjectPool.borrowObject
    1. org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:816)
    1 frame
  7. Commons DBCP
    BasicDataSource.getConnection
    1. org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:95)
    2. org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
    2 frames
  8. com.hutchison3g.voiprecording
    DirectLogin.main
    1. com.hutchison3g.voiprecording.directlogin.database.DBManager.getConnection(DBManager.java:26)
    2. com.hutchison3g.voiprecording.directlogin.database.DBManager.executeStatement(DBManager.java:153)
    3. com.hutchison3g.voiprecording.directlogin.main.DirectLogin.main(DirectLogin.java:29)
    3 frames