java.sql.SQLException: Could not retrieve datasource via JNDI url 'jdbc/oimJMSStoreDS' weblogic.jdbc.extensions.ConnectionDeadSQLException: weblogic.common.resourcepool.ResourceDeadException: Could not create pool connection. The DBMS driver exception was: ORA-00604: error occurred at recursive SQL level 3 ORA-04031: unable to allocate 352 bytes of shared memory ("shared pool","select /*+ rule */ bucket_cn...","SQLA^337fc737","qertbs:qertbIAllocate")

Oracle Community | 941300 | 4 years ago
  1. 0

    OIM 11gR2 Error in log file

    Oracle Community | 4 years ago | 941300
    java.sql.SQLException: Could not retrieve datasource via JNDI url 'jdbc/oimJMSStoreDS' weblogic.jdbc.extensions.ConnectionDeadSQLException: weblogic.common.resourcepool.ResourceDeadException: Could not create pool connection. The DBMS driver exception was: ORA-00604: error occurred at recursive SQL level 3 ORA-04031: unable to allocate 352 bytes of shared memory ("shared pool","select /*+ rule */ bucket_cn...","SQLA^337fc737","qertbs:qertbIAllocate")
  2. 0

    ORA-04031: unable to allocate 104 bytes of shared memory | dBforums – Everything on Databases, Design, Developers and Administrators

    dbforums.com | 1 year ago
    java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 2 ORA-04031: unable to allocate 104 bytes of shared memory ("shared pool","select /*+ rule */ bucket, e...","SQLA^bbcee4f7","opiprwd : opitca") ".> • MDS-01376: Unable to get database connection from data source "mds" configured with JNDI name "jdbc/mds/MDS_REPOS". weblogic.common.resourcepool.ResourceDisabledExcep tion: Pool mds-oim is Suspended, cannot allocate resources to applications.. at oracle.mds.config.PConfig.loadFromBean(PConfig.jav a:959)
  3. 0

    Predefined AD connector User provisioning issue

    Oracle Community | 4 years ago | 941383
    org.quartz.JobPersistenceException: Failed to obtain DB connection from data source 'noTXDS': java.sql.SQLException: Could not retrieve datasource via JNDI url 'jdbc/oimJMSStoreDS' weblogic.jdbc.extensions.ConnectionDeadSQLException: weblogic.common.resourcepool.ResourceDeadException: 0:weblogic.common.ResourceException: Could not create pool connection. The DBMS driver exception was: IO Error: Socket read timed out [See nested exception: java.sql.SQLException: Could not retrieve datasource via JNDI url 'jdbc/oimJMSStoreDS' weblogic.jdbc.extensions.ConnectionDeadSQLException: weblogic.common.resourcepool.ResourceDeadException: 0:weblogic.common.ResourceException: Could not create pool connection. The DBMS driver exception was: IO Error: Socket read timed out]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Notification Mailer not starting.

    Oracle Community | 7 years ago | user121044
    java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-04031: unable to allocate 4080 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","library cache")
  6. 0

    SQL ERROR | Oracle Community

    oracle.com | 8 months 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")

    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

      Could not retrieve datasource via JNDI url 'jdbc/oimJMSStoreDS' weblogic.jdbc.extensions.ConnectionDeadSQLException: weblogic.common.resourcepool.ResourceDeadException: Could not create pool connection. The DBMS driver exception was: ORA-00604: error occurred at recursive SQL level 3 ORA-04031: unable to allocate 352 bytes of shared memory ("shared pool","select /*+ rule */ bucket_cn...","SQLA^337fc737","qertbs:qertbIAllocate")

      at org.quartz.utils.JNDIConnectionProvider.getConnection()
    2. quartz
      JobStoreCMT.getNonManagedTXConnection
      1. org.quartz.utils.JNDIConnectionProvider.getConnection(JNDIConnectionProvider.java:166)
      2. org.quartz.utils.DBConnectionManager.getConnection(DBConnectionManager.java:112)
      3. org.quartz.impl.jdbcjobstore.JobStoreCMT.getNonManagedTXConnection(JobStoreCMT.java:164)
      3 frames