ORA-12042: cannot alter job_queue_processes in single process mode

Cause : An attmept wasm ade toa lter jbo_queuep_rocessse in signle proecss mod.e

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

Do nota ttemptt o set ojb_queu_eprocesess in snigle prcoess moed.

update : 26-05-2017
ORA-12042

ORA-12042 - cannot alter job_queue_processes in single process mode
ORA-12042 - cannot alter job_queue_processes in single process mode

  • ora-39097 : Data Pump job encountered unexpected error string
  • ora-28100 : policy function schema string is invalid
  • ora-24152 : cannot drop evaluation context string.string with dependents
  • ora-08100 : index is not valid - see trace file for diagnostics
  • ora-01325 : archive log mode must be enabled to build into the logstream
  • ora-02153 : invalid VALUES password string
  • ora-06578 : output parameter cannot be a duplicate bind
  • ora-25275 : Test support for buffered queues
  • ora-02191 : correct syntax is: SET TRANSACTION USE ROLLBACK SEGMENT
  • ora-01608 : cannot bring rollback segment 'string' online, its status is (string)
  • ora-14266 : data type or length of an index subpartitioning column may not be changed
  • ora-10614 : Operation not allowed on this segment
  • ora-33452 : (ESDREAD06) Discarding compiled code for workspace object because number is now dimensioned by workspace object. It was dimensioned by workspace object when the code was compiled.
  • ora-02320 : failure in creating storage table for nested table column string
  • ora-19004 : Duplicate XMLType OBJECT RELATIONAL storage option
  • ora-32515 : cannot issue ORADEBUG command; waited number ms for process string
  • ora-04021 : timeout occurred while waiting to lock object stringstringstringstringstring
  • ora-24184 : transformation string.string already exists
  • ora-30012 : undo tablespace 'string' does not exist or of wrong type
  • ora-30042 : Cannot offline the undo tablespace
  • ora-12560 : TNS:protocol adapter error
  • ora-00470 : LGWR process terminated with error
  • ora-15179 : missing or invalid alias name
  • ora-22874 : attribute "string" is not part of the type "string"
  • ora-40004 : penalty must be negative for BLAST-N
  • ora-12602 : TNS: Connection Pooling limit reached
  • ora-31208 : DBMS_LDAP: PL/SQL - Invalid LDAP Message.
  • ora-07718 : sksafre: error freeing memory
  • ora-07593 : ssprprv: Error release privileges
  • ora-28170 : unsupported certificate version
  • 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.