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@]

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

转载于:http://blog.itpub.net/9533994/viewspace-1006205/