Dear All,
• Let me put my current Environment Info.
Single Laptop Machine of 16GB RAM.
Assigned 13GB to VM.
I have installed Oracle Database 11g. 11.2.00
When I try to access my application many times I received below error
• Error:
“”Caused by: java.sql.SQLException: Could not retrieve datasource via JNDI url 'jdbc/oimJMSStoreDS' weblogic.jdbc.extensions.ConnectionDeadSQLExceptio n: 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:qertbIAlloca te")
at org.quartz.utils.JNDIConnectionProvider.getConnect ion(JNDIConnectionProvider.java:166)
at org.quartz.utils.DBConnectionManager.getConnection (DBConnectionManager.java:112)
at org.quartz.impl.jdbcjobstore.JobStoreCMT.getNonMan agedTXConnection(JobStoreCMT.java:164)
... 3 more””
Some time it says oimJMSStoreDS,SOADATAStore.
• Even when above error occur I have 7GB free JVM so JVM is not an Issue.
•I have updated Max Capacity of oimOperationsDB =100,oimOperdationDB, oimJMSStoreDS=80,SOADATAStore =80. But still I have error
• ERROR::
• ““Aug 30, 2012 3:24:10 PM EST> <Warning> <oracle.integration.platform.blocks.event.saq> <SOA-31013> <Error handling message (rolling back).
java.sql.SQLException: ORA-04031: unable to allocate 352 bytes of shared memory ("shared pool","select /*+ rule */ bucket_cn...","SQLA^337fc737","qertbs:qertbIAlloca te")
ORA-06512: at "SYS.DBMS_AQ", line 335
ORA-06512: at "DEV_SOAINFRA.EDN_DEQUEUE_OAOO_DELIVERY", line 14”
• “<Aug 30, 2012 3:28:58 PM EST> <Error> <JDBC> <BEA-001112> <Test "SELECT 1 FROM DUAL" set up for pool "SOADataSource" failed with exception: "java.sql.SQLException: ORA-04031: unable to allocate 32 bytes of shared memory ("shared pool","SELECT 1 FROM DUAL","SQLA","tm”
• ug 30, 2012 3:46:58 PM EST> <Error> <JDBC> <BEA-001112> <Test "SELECT 1 FROM DUAL" set up for pool "oimOperationsDB" failed with exception: "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)
at oracle.mds.config.PConfig.<init>(PConfig.java:758)
at oracle.mds.config.MDSConfig.loadFromBean(MDSConfig .java:787)
at oracle.mds.config.MDSConfig.loadFromElement(MDSCon fig.java:848)
at oracle.mds.config.MDSConfig.<init>(MDSConfig.java: 491)
Truncated. see log file for complete stacktrace
Caused By: oracle.mds.exception.MDSExceptionList: MDS-01329: unable to load element "persistence-config"
MDS-01370: MetadataStore configuration for metadata-store-usage "mdsRepos" is invalid.
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..
MDS-01370: MetadataStore configuration for metadata-store-usage "mdsReposOIM" is invalid.
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..
•I have modified Shared_pool_size,large_pool_size. Content of my mofified Pfile is as below.
o orcl.__db_cache_size=822083584
o orcl.__java_pool_size=2777216
o orcl.__large_pool_size=56777216
o orcl.__oracle_base='/home/oracle/app/oracle'#ORACLE_BASE set from environment
o orcl.__pga_aggregate_target=805306368
o orcl.__sga_target=1174405120
o orcl.__shared_io_pool_size=0
o orcl.__shared_pool_size=601989888
o orcl.__streams_pool_size=0
What’s value of parameter I need to set for datastore, pfile ? (I have 13GB of memory).
Help Appreciated.