My Oracle Support Banner

Qmn0 And Lgwr Trace Files Are Generated During Shutdown/Startup (Doc ID 308982.1)

Last updated on AUGUST 04, 2018

Applies to:

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


During instance shutdown and restart see trace files for the QMN0 and LGWR processes being generated.

The LGWR trace have following message:

Checking if LNS processes need to be shutdown..


The QMN0 trace have following messages:


SGA initialization / DB open not complete even after 5 minutes, QMN0exiting
error 604 detected in background process
OPIRIP: Uncaught error 447. Error stack:
ORA-00447: fatal error in background process
ORA-00604: error occurred at recursive SQL level 1
ORA-01219: database not open: queries allowed on fixed tables/views only


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

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