Error Message:"JDBC error reported: (SQLState = HY000) - tibcosoftwareinc.jdbc.oraclebase.ddej: [tibcosoftwareinc][Oracle JDBC Driver][Oracle]ORA-04031: unable to allocate 12312 bytes of shared memory.

Error Message:"JDBC error reported: (SQLState = HY000) - tibcosoftwareinc.jdbc.oraclebase.ddej: [tibcosoftwareinc][Oracle JDBC Driver][Oracle]ORA-04031: unable to allocate 12312 bytes of shared memory.

book

Article ID: KB0093512

calendar_today

Updated On:

Products Versions
TIBCO ActiveMatrix BusinessWorks -
Not Applicable -

Description

Resolution:

The error, "ORA-04031: unable to allocate 12312 bytes of shared memory", may be caused by insufficient Oracle pool size. Although the error is shown in the application, it should be resolved by increasing the shared pool size on Oracle server.



Issue/Introduction

Error Message:"JDBC error reported: (SQLState = HY000) - tibcosoftwareinc.jdbc.oraclebase.ddej: [tibcosoftwareinc][Oracle JDBC Driver][Oracle]ORA-04031: unable to allocate 12312 bytes of shared memory.

Additional Information

http://www.dba-oracle.com/sf_ora_04031_unable_to_allocate_string_bytes_of_shared_memory.htm

http://www.dbas-oracle.com/2011/06/ora-04031-unable-to-allocate-264-bytes.html