Checking if LNS processes need to be shutdown
These trace files are normal trace files which can be generated during instance shutdown and startup.
The LGWR trace with message "Checking if LNS processes need to be shutdown." was added in 188.8.131.52 and 10g to check if the LNS process is running while the database thread is being dismounted. In this check, we would log this information in a trace file and then shutdown the LNS process. This functionality will be removed in the 10.1.0.5 and higher releases as result of enhancement request bug 3605489. Reference Note.270554.1 "Generating trace file each time shutdown the database,after applying 184.108.40.206.0 patchset".
The QMN0 trace with errors "ORA-00447: fatal error in background process", "ORA-00604: error occurred at recursive SQL level 1", and "ORA-01219: database not open: queries allowed on fixed tables/views only" will occur during startup if the Queue Monitor Process (QMN0) has detected that the instance as not opened after a 5 minute interval. This functionality was added as result of bug 3248886 to know the exact reason for the QMN process exiting. Prior to the change there were only alert.log messages for restarting dead background messages. Reference Bug 3977829.
Ignore these traces or for the case of the QMN0 trace start instance with init parameter aq_tm_processes=0 so that QMN0 process does not start and you don't see these messages and the tracefiles and then do an "alter system set aq_tm_processes=n" when the database is completely open to start the queue monitor process if needed.
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/936/viewspace-60706/，如需转载，请注明出处，否则将追究法律责任。