Clarity Error on Oracle - ORA-04031: unable to allocate 'X' bytes of shared memory
search cancel

Clarity Error on Oracle - ORA-04031: unable to allocate 'X' bytes of shared memory

book

Article ID: 198961

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

Error in logs such as below: 

FATAL 2020-09-02 11:36:34,258 [http-nio-8082-exec-458] union.persistence (clarity:SomeRandomUser:xxxx_xxxxxxxx:PPM_REST_API) 
java.sql.SQLClientInfoException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-04031: unable to allocate 40 bytes of shared memory ("shared pool","BEGIN DBMS_SESSION.SET_IDENT...","SQLP","tmp")

 at com.ca.clarity.jdbc.oraclebase.ddai.a(Unknown Source)
 at com.ca.clarity.jdbc.oraclebase.ddai.setClientInfo(Unknown Source)
 at com.ca.clarity.jdbc.oraclebase.ddai.setClientInfo(Unknown Source)
 at jdk.internal.reflect.GeneratedMethodAccessor97.invoke(Unknown Source)
 at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.base/java.lang.reflect.Method.invoke(Method.java:566)

Symptoms in the application:

  • Invalid or no object data found in portlets
  • Failures may happen when running jobs or processes.

Environment

Release : Any Supported Clarity release with Oracle

Resolution

  • This is not a Clarity product issue
  • This is an Oracle error which needs to be investigated by DBA team and Oracle Support
  • Request your DBA to open a ticket with Oracle Support to address this
Powered by Wolken Software