Primary Note: Troubleshooting Oracle Background Processes
(Doc ID 1509616.1)
Last updated on SEPTEMBER 22, 2023
Applies to:
Oracle Database Backup Service - Version N/A and laterOracle Database Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
Purpose
This document is intended to assist Database Administrators resolve issues encountered involving Oracle Background Processes. It mainly applies to a single instance environment and looks at a basic typical database configuration.
Troubleshooting Steps
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
| Purpose |
| Troubleshooting Steps |
| Concepts |
| Issues Involving Oracle Background Processes |
| ORA- errors related to Background Processes |
| ORA-443 background process did not start |
| ORA-444 background process failed while starting |
| ORA-445 background process did not start after seconds |
| ORA-446 background process started when not expected |
| ORA-447 fatal error in background process |
| ORA-448 normal completion of background process |
| ORA-449 background process unexpectedly terminated with error |
| ORA-450 background process '%s' did not start |
| Generic issues not related to a specific background process |
| CJQ0 / Jnnn ( Job Queue Coordinator Process / Job Queue Secondary Processes ) |
| Issues Specific to CJQ0 / Jnnn |
| CKPT ( Checkpoint Process ) |
| Issues Specific to CKPT |
| DBWn ( Database Writer Process ) |
| Issues Specific to DBWn |
| EMNC /Ennn ( EMON Coordinator Process / EMON Secondary Process ) |
| Issues Specific to EMNC / Ennn |
| LGWR ( Log Writer Process ) |
| Issues Specific to LGWR |
| MMON / Mnnn ( Manageability Monitor Process / MMON Secondary Process ) |
| Issues Specific to MMON / Mnnn |
| PMON ( Process Monitor ) |
| Issues Specific to PMON |
| QMNC / QMNn ( AQ Coordinator Process / AQ Server Class Process ) |
| Issues Specific to QMNC / QMNn |
| RECO ( Recoverer Process ) |
| Issues Specific to RECO |
| SMON ( System Monitor Process ) |
| Issues Specific to SMON |
| VKTM ( Virtual Keeper of Time Process ) |
| Issues Specific to VKTM |
| Wnnn ( Space Management Secondary Process ) |
| Issues Specific to Wnnn |
| Helpful Articles on Background Processes |
| Further Diagnostics |
| References |