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 JANUARY 29, 2022

Applies to:

Oracle Lite - Version 10.3.0.3.0 and later
Information in this document applies to any platform.

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!


In this Document
Symptoms
Cause
Solution


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