|
一大早被电话吵醒同事说一个数据库应用升级之后无法启动 后台连续报错
Sun Apr :: Restarting dead background process QMN QMN started with pid= Sun Apr :: Restarting dead background process QMN QMN started with pid= 那么QMN是什么进程呢? Queue Monitor Processes (QMNn) 队列监视进程是一个可选的后台进程为Oracle Streams Advanced Queuing所使用 最多可以配置个队列监视进程和Job进程一样该进程的异常不会导致数据库的Crash 通常这个错误不会导致数据库无法启动但是在某些平台上会存在Bug可能会导致数据库无法启动 如果没有用到Oracle Streams Advanced Queuing选件就可以取消该进程数据库自然就可以启动了 SQL> show parameter aq NAME TYPE VALUE aq_tm_processes integer SQL> alter system set aq_tm_processes= scope=both; System altered SQL> alter database open; Database altered 此案例的数据库版本为平台为Sun Solaris: SQL> select * from v$version; BANNER
Oraclei Enterprise Edition Release bit Production PL/SQL Release Production CORE Production TNS for Solaris: Version Production NLSRTL Version Production SQL> exit Disconnected from Oraclei Enterprise Edition Release bit Production With the Partitioning OLAP and Oracle Data Mining options JServer Release Production $ isainfo v bit sparcv applications bit sparc applications |
