ORA-04031 unable to allocate X bytes of shared memory when starting application

Cross Product Knowledge

On this page

Still need help?

The Atlassian Community is here for you.

Ask the community

Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.

Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.

*Except Fisheye and Crucible

Problem

Application fails to start and following appears in the daily log file.

CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Unable to open a test connection to the given database. JDBC url = jdbc:oracle:thin:@//DB_URL:1521/bitbucket, username = BITBUCKET. Terminating connection pool. Original Exception: ------
java.sql.SQLException: ORA-04031: unable to allocate 12312 bytes of shared memory ("shared pool","unknown object","ABC123","abc123")

Cause

More shared memory is needed than was allocated in the shared pool.

Resolution

Consult with your DBA to increase the size of the shared memory in the pool. This can usually be done by increasing the value of shared_pool_reserved_size and shared_pool_size

Last modified on May 23, 2016

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.