ORACLE9I 实例无法正常启动

jiay

同事通知我在启动一个ORACLE 9I数据库时很长时间没有反应。　　其实就是在startup后没有动静了，等了很长时间。
　　检查下日志，发现有个QMN0的进程不断重新启动。
　　这让我想起了ORACLE9I的一个经典BUG，遇到了-:)
Bug 3248886  Continous 'restarting dead background process qmn0' message in alert.log
This note gives a brief overview of bug 3248886. Affects:

Product (Component)Oracle Server (Rdbms)Range of versions believed to be affectedVersions < 10.1.0.2 Versions confirmed as being affected

• 9.2.0.3
  
• 9.2.0.5
  

Platforms affectedGeneric (all / most platforms affected)

Fixed:

This issue is fixed in

• 9.2.0.6 (Server Patch Set)
  

Symptoms:
Related To:

• (None Specified)
  

• RAC (Real Application Clusters) / OPS
  
• Instance Startup
  
• AQ_TM_PROCESSES
  

Description

"Restarting dead background process QMN" message can continually　　appear in the alert log during startup in RAC environment.
　　Workaround:
　　Set aq_tm_processes=0 in the init.ora.
　　It can be set to desired value through
　　"alter system set aq_tm_processes=n" once the database is open completely.