AWR Snapshots Are Not Being Created Because MMON Is Not Being Respawned (Doc ID 2023652.1)

To Bottom

Oracle Database - Enterprise Edition - Version 11.2.0.4 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.

Due to other reasons, the MMON process died and subsequent AWR reports are therefore not getting generated.

The MMON process should automatically be respawned but it is not.

MMON/MMNL not being respawned or recreated is due to:

unpublished bug: Bug 19565533 - MMON/MMNL CAN NOT BE AUTOMATICALLY RESTARTED AFTER KILLED

The issue only occurs on 11.2.0.4 and is a regression of the fix for Bug 14213856

To solve the issue:

• Apply interim patch 19565533 for 11.2.0.4, if available for your platform.
  
  To check for conflicting patches, please use the MOS Patch Planner Tool
  Please refer to
  Note 1317012.1 - How To Use MOS Patch Planner To Check And Request The Conflict Patches?
  
  If no patch exists for your version, please contact Oracle Support for a backport request.
  
  - OR -
• As a workaround, you can respawn the MMON process by next methods:
  • Restart the database instance
    
    - OR -
  • Set the instance to "restricted session" mode and then bring it back to normal mode using following commands as SYSDBA:
      

alter system enable restricted session;
alter system disable restricted session;