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
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  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")

    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