Restarting dead background process QMN0


Problem:

I’m using Oracle 9i 9.2.0.4.0 as a standby database. When i tail the alert.log file, i keep getting these message every 5 minutes:

Restarting dead background process QMN0
QMN0 started with pid=9

Solution:

it’s the parameter
aq_tm_processes=1
If you don’t use Advanced Queueing you can set it to 0:
alter system set aq_tm_processes=0 scope=both;

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: