ITPub博客

首页 > 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 删除 编辑

用户电话说,新装了一个数据库,但open一会就当掉,日志内容:

Checking if LNS processes need to be shutdown


在metalink上找到一个类似的:

Cause

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 9.2.0.5 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 9.2.0.5.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.

Solution

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.

但后来用户电话说,找到原因了:另外一个用户写了一个脚本,一运行就把数据库close了.

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/936/viewspace-60706/,如需转载,请注明出处,否则将追究法律责任。

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

注册时间:2001-10-12

  • 博文量
    268
  • 访问量
    172264