WARNING: AQ_TM_PROCESSES is set to 0. System operation might be adversely affected.


If you get WARNING while starting up your database:

WARNING: AQ_TM_PROCESSES is set to 0. System operation might be adversely affected.

You can do these steps based on Metalink Document: 428441.1

SQL> connect / as sysdba
SQL> alter system reset aq_tm_processes scope=spfile sid='*';
SQL> shutdown immediate;
SQL> startup;

It works for me…

One response to “WARNING: AQ_TM_PROCESSES is set to 0. System operation might be adversely affected.”

  1. Kina Mccoid says :

    Wow! Your site has a bunch comment posts. How did you get so many viewers to see your post I’m jealous! I’m still learning all about article writing on the web. I’m going to view pages on your website to get a better understanding how to achieve success. Thanks!

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: