My Oracle Support Banner

Large Amount Of Archive Log Files Are Generated During Mgp Process And Compose/Apply Cycle Error (Doc ID 1199103.1)

Last updated on MAY 15, 2018

Applies to:

Oracle Lite - Version 10.3.0.3.0 and later
Information in this document applies to any platform.
***Checked for relevance on 07-Aug-2013***

Symptoms

On : 10.3.0.3.0 version, Mobile Server

When attempting to Compose/apply the data the MGP fails with the error Ora-00942 and it does not truncate the CLG$tables which increase the Amount of Archives.


ERROR
-----------------------
ORA-00942


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. start MGP
2. All the MGP Cycle fails with the Error Ora-00842
3. the MGP does not truncate the clg$tables and keep all their records which are composing again and increase the Amount of Archives.


Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.