CLM 4.0.3: Data collection "Star" job fail
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
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.
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.