DESCRIPTION:

The size MMON trace files gets increased which is causing trace file Location Overflow.

CAUSE:

Trace files generation with message “AUTO SGA: kmgs_parameter_update_timeout gen0 0 mmon alive 1”.

Regarding excessive MMON trace generation, this is a known issue
This is due to an unpublished Bug 25415713 – MMON TRACE FILE GROWS WHEN NO TRACES ARE ENABLED.

SOLUTION:

Applying Patch in Offline Mode:

  1. Download and apply this one-off patch 25415713 according to your release.
  2. 1. shut down all the services running from the Oracle home
  3. Download the patch 25415713
  4. cd <PATCH_TOP_DIR>/25415713
  5. 1. opatch apply
  6. 1. Verify whether the patch has been successfully installed using “opatch lsinventory”
  7. Start the services from the Oracle home

CONCLUSION:

  • Please make sure that you have a valid backup and install this fix on your test environment prior to installing it on your full production environment.
    Before applying this one-off patch, it is highly recommended to check the patch conflicts.
  • Refer (Doc ID 989072.1)

 

Recent Posts

Start typing and press Enter to search