很常见的一个信息，以前并没有太在意，不过即使是这种异常信息，Oracle也认为是bug。
关闭数据库时，信息如下：
Tue Aug 16 15:38:06 2011 Shutting down archive processes Tue Aug 16 15:38:11 2011 ARCH shutting down ARC2: Archival stopped Tue Aug 16 15:43:41 2011 Starting background process EMN0 EMN0 started WITH pid=28, OS id=1294500 Tue Aug 16 15:43:41 2011 Shutting down instance: further logons disabled Tue Aug 16 15:43:41 2011 Stopping background process QMNC Tue Aug 16 15:43:41 2011 Stopping background process CJQ0 Tue Aug 16 15:43:44 2011 Stopping background process MMNL Tue Aug 16 15:43:45 2011 Stopping background process MMON Tue Aug 16 15:43:46 2011 Shutting down instance (immediate) License high water mark = 10 Tue Aug 16 15:43:46 2011 Stopping Job queue slave processes Tue Aug 16 15:43:51 2011 Process OS id : 1474740 alive after KILL Errors IN file Tue Aug 16 15:43:51 2011 Job queue slave processes stopped Tue Aug 16 15:44:01 2011 PMON failed TO acquire latch, see PMON dump PMON failed TO acquire latch, see PMON dump PMON failed TO acquire latch, see PMON dump PMON failed TO acquire latch, see PMON dump PMON failed TO acquire latch, see PMON dump Tue Aug 16 15:44:11 2011 PMON failed TO acquire latch, see PMON dump PMON failed TO acquire latch, see PMON dump PMON failed TO acquire latch, see PMON dump PMON failed TO acquire latch, see PMON dump PMON failed TO acquire latch, see PMON dump Tue Aug 16 15:44:22 2011 PMON failed TO acquire latch, see PMON dump PMON failed TO acquire latch, see PMON dump PMON failed TO acquire latch, see PMON dump PMON failed TO acquire latch, see PMON dump PMON failed TO acquire latch, see PMON dump Tue Aug 16 15:44:32 2011 PMON failed TO acquire latch, see PMON dump PMON failed TO acquire latch, see PMON dump Tue Aug 16 15:44:37 2011 ALTER DATABASE CLOSE NORMAL Tue Aug 16 15:44:37 2011 SMON: disabling tx recovery SMON: disabling cache recovery Tue Aug 16 15:44:37 2011 Shutting down archive processes Archiving IS disabled Tue Aug 16 15:44:42 2011 ARCH shutting down ARC1: Archival stopped Tue Aug 16 15:44:47 2011 ARCH shutting down ARC0: Archival stopped Tue Aug 16 15:44:49 2011 Thread 1 closed at log SEQUENCE 9371 Successful close OF redo thread 1 Tue Aug 16 15:44:49 2011 Completed: ALTER DATABASE CLOSE NORMAL Tue Aug 16 15:44:49 2011 ALTER DATABASE DISMOUNT Completed: ALTER DATABASE DISMOUNT ARCH: Archival disabled due TO shutdown: 1089 Shutting down archive processes Archiving IS disabled Archive process shutdown avoided: 0 active ARCH: Archival disabled due TO shutdown: 1089 Shutting down archive processes Archiving IS disabled Archive process shutdown avoided: 0 active |
Oracle在MOS文档Bug 4632780 – PMON “failed to acquire latch” during shutdown [ID 4632780.8]专门介绍了这个信息，确认影响的版本包括9.2.0.7、10.1.0.5和10.2.0.1，Oracle在9.2.0.8、10.2.0.2和11.1.0.6中进行了修复。