Bug 4632780 - PMON "failed to acquire latch" during shutdown

今天做實驗，遭遇Bug 4632780

shutdown immedaite

hang住

alert中出現大量PMON "failed to acquire latch" during shutdown

ctrl＋c，不起作用，然後在另外一個視窗中登入

[oracle@xh bdump]$ sqlplus '/as sysdba'

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jun 28 10:21:58 2008

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected.
SQL> alter system checkpoint;
alter system checkpoint
*
ERROR at line 1:
ORA-01012: not logged on

SQL> conn sys/password as sysdba
Connected to an idle instance.
SQL> show parameter
ORA-01012: not logged on

SQL> exit
Disconnected
[oracle@xh bdump]$ ps -ef|grep ora_
oracle 3149 1 0 09:29 ? 00:00:04 ora_pmon_test
oracle 3151 1 0 09:29 ? 00:00:00 ora_psp0_test
oracle 3153 1 0 09:29 ? 00:00:01 ora_mman_test
oracle 3155 1 0 09:29 ? 00:00:01 ora_dbw0_test
oracle 3157 1 0 09:29 ? 00:00:06 ora_lgwr_test
oracle 3159 1 0 09:29 ? 00:00:00 ora_ckpt_test
oracle 3161 1 0 09:29 ? 00:00:03 ora_smon_test
oracle 3163 1 0 09:29 ? 00:00:00 ora_reco_test
oracle 3177 1 0 09:29 ? 00:00:01 ora_arc0_test
oracle 3179 1 0 09:29 ? 00:00:00 ora_arc1_test
oracle 6655 6159 0 10:25 pts/1 00:00:00 grep ora_
[oracle@xh bdump]$ sqlplus '/as sysdba'

SQL*Plus: Release 10.2.0.1.0 - Production on Sat Jun 28 10:27:02 2008

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected.
SQL> shutdown abort
ORACLE instance shut down.

本想 alter system checkpoint後shutdown abort

然而根本無法執行alter system checkpoint，提示登入不上，看oracle程式，orace應該沒有關閉，但死活登入不上，奇怪的是執行shutdown abort卻沒有問題。邪門了～～

資料庫重啟後，一切正常。

metelink上：

Bug 4632780 - PMON "failed to acquire latch" during shutdown

Affects:

Product (Component)	Oracle Server (Rdbms)
Range of versions believed to be affected	Versions < 11
Versions confirmed as being affected	9.2.0.7 10.1.0.5 10.2.0.1
Platforms affected	Generic (all / most platforms affected)

Fixed:

This issue is fixed in

9.2.0.8 (Server Patch Set) 10.2.0.2 (Server Patch Set) 11g (Future version)

Symptoms:	Related To:
(None Specified)	Miscellaneous

Description

"PMON failed to acquire latch" messages can appear in the 
alert log during shutdown.

[@more@]