It's all about the answers!

Ask a question

CLM 4.0.3: Data collection "Star" job fail

Kunal Doddanavar (45222732) | asked Oct 21 '13, 10:22 a.m.
     I have just installed CLM 4.0.3, they are using  Oracle 10g as DB. 
I have configured the data warehouse and all the data collection jobs run .o.k, except "Star" job fails.

AT JTS-etl log:
Java.sql.SQLException: ORA-00604: There was an error level 1 recursive SQL ORA-04031: could not be allocated 4120 bytes of shared memory ("shared pool","select Type#,blocks,extents,..." ,"Typecheck","KgghteInit") 

At CCM-etl log:
ERROR Ouse.service.scm.internal.ScmRemoteSnapshotService - java.sql.SQLException: ORA-04031: could not be allocated 2240 bytes of shared memory ("shared pool","F_TEXT_FILE_VERSION_METRICS","KGLS heap","KGLS MEM BLOCK") 

Has anyone come across these errors?


Accepted answer

permanent link
Stephanie Bagot (2.1k1513) | answered Oct 21 '13, 10:42 a.m.
This is usually caused when more shared memory is needed than was allocated in the shared pool in your Oracle configuration.

You should speak with your Oracle DBA in regards to this issue. They will need to increase the amount of available shared memory by increasing the value of the INIT.ORA parameters shared_pool_reserved_size and shared_pool_size. This must be done from the Oracle configuration side, and cannot be adjusted from RTC or JTS.

Kunal Doddanavar selected this answer as the correct answer

Your answer

Register or to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.