一大早被電話吵醒，同事說一個數(shù)據(jù)庫應用升級之后無法啟動。 后臺連續(xù)報錯： Sun APR 30 10:48:41 2006 Restarting dead background process QMN0 QMN0 started with pid=9 Sun Apr 30 10:53:42 2006 Restarting dead background process QMN0 QMN0 started with pid=9那么QMN0是什么進程呢?Queue Monitor Processes (QMNn) 隊列監(jiān)視進程是一個可選的后臺進程，為Oracle Streams Advanced Queuing所使用。 最多可以配置10個隊列監(jiān)視進程。和Job進程一樣，該進程的異常不會導致數(shù)據(jù)庫的Crash。通常這個錯誤不會導致數(shù)據(jù)庫無法啟動，但是在某些平臺上會存在Bug,可能會導致數(shù)據(jù)庫無法啟動。 假如沒有用到Oracle Streams Advanced Queuing選件，就可以取消該進程，數(shù)據(jù)庫自然就可以啟動了：SQL> show parameter aqNAME TYPE VALUE ------------------------------------ ----------- ----------------- aq_tm_processes integer 1 SQL> alter system set aq_tm_processes=0 scope=both;System altered.SQL> alter database open;Database altered.此案例的數(shù)據(jù)庫版本為9.2.0.3,平臺為Sun Solaris:SQL> select * from v$version;BANNER ---------------------------------------------------------------- 9i Enterprise Edition Release 9.2.0.3.0 - 64bit ProdUCtion PL/SQL Release 9.2.0.3.0 - Production CORE 9.2.0.3.0 Production TNS for Solaris: Version 9.2.0.3.0 - Production NLSRTL Version 9.2.0.3.0 - ProductionSQL> exit Disconnected from Oracle9i Enterprise Edition Release 9.2.0.3.0 - 64bit Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.3.0 - Production
