It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×42,787
×5,997

question asked: Oct 21 '13, 10:22 a.m.
question was seen: 4,416 times
last updated: Oct 21 '13, 10:42 a.m.

Related questions

FAQ - How this Forum works

CLM 4.0.3: Data collection "Star" job fail

0
Kunal Doddanavar (452●2●27●32) | asked Oct 21 '13, 10:22 a.m.
 Hi,
     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?

Regards,
Kunal

Accepted answer

3
permanent link
Stephanie Bagot (2.1k●1●5●13) | answered Oct 21 '13, 10:42 a.m.
FORUM MODERATOR / JAZZ DEVELOPER
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.