首页 > Linux操作系统 > Linux操作系统 > Checking if LNS processes need to be shutdown

Checking if LNS processes need to be shutdown

原创 Linux操作系统 作者:jlandzpa 时间:2019-07-19 22:15:01 0 删除 编辑


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 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 and higher releases as result of enhancement request bug 3605489. Reference Note.270554.1 "Generating trace file each time shutdown the database,after applying 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博客 ” ,链接:,如需转载,请注明出处,否则将追究法律责任。

上一篇: Patch 4658188
请登录后发表评论 登录


  • 博文量
  • 访问量