ORA-25261: JOB_QUEUE_PROCESSES must be at least 2 for AQ propagation

Cause : AQ Propagator encountered a setting for JOB_QUEUE_PROCESSES that is insufficient for AQ propagation.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Set the number of JOB_QUEUE_PROCESSES to at least 2 for AQ propagation.

update : 28-04-2017
ORA-25261

ORA-25261 - JOB_QUEUE_PROCESSES must be at least 2 for AQ propagation
ORA-25261 - JOB_QUEUE_PROCESSES must be at least 2 for AQ propagation

  • ora-25190 : an index-organized table maintenance operation may not be combined with other operations
  • ora-00370 : potential deadlock during kcbchange operation
  • ora-28261 : CURRENT_USER can not be used in PLSQL Definer's Right procedure.
  • ora-19334 : Invalid column specification for CREATE_DBURI operator
  • ora-16757 : resource guard could not get property
  • ora-29841 : invalid option for ALTER INDEXTYPE
  • ora-27045 : unable to close the file
  • ora-32732 : Parallel Oradebug session is aborted
  • ora-06604 : LU6.2 Driver: Unable to allocate session with remote LU
  • ora-02025 : all tables in the SQL statement must be at the remote database
  • ora-39212 : installation error: XSL stylesheets not loaded correctly
  • ora-00100 : no data found
  • ora-26524 : nls subsystem initialization failure for product=string, facility=string
  • ora-04076 : invalid NEW or OLD specification
  • ora-06116 : NETTCP: unable to create ORASRV process
  • ora-01195 : online backup of file string needs more recovery to be consistent
  • ora-16631 : operation requires shutdown of database/instance "string"
  • ora-26675 : cannot create Streams capture process string
  • ora-08457 : syntax error in SEPARATE CHARACTER option of SIGN clause
  • ora-39771 : stream must be loaded before its handle is freed
  • ora-02295 : found more than one enable/disable clause for constraint
  • ora-19727 : cannot plug data [string] at level string into database running Oracle string
  • ora-23320 : the request failed because of values string and string
  • ora-19612 : datafile string not restored due to string
  • ora-30361 : unrecognized string type
  • ora-16076 : unknown standby database destination
  • ora-22634 : Error adding new instance to AnyDataSet
  • ora-14636 : only 2 resulting subpartition can be specified for SPLIT SUBPARTITION
  • ora-06020 : NETASY: initialisation failure
  • ora-02194 : event specification syntax error string (minor error string) near 'string'
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.