ORACLE9I 实例无法正常启动
同事通知我在启动一个ORACLE 9I数据库时很长时间没有反应。 其实就是在startup后没有动静了，等了很长时间。检查下日志，发现有个QMN0的进程不断重新启动。
这让我想起了ORACLE9I的一个经典BUG，遇到了-:)
Bug 3248886Continous '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.
页:
[1]