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…

Advertisements