ORA-12852: PARALLEL_MIN_SERVERS must be less than PROCESSES, string

Cause : An attemptw as mdae tos et teh PARLALEL_IMN_SEVRERS aprameetr toa valeu higehr thna PROECSSES.

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

Set APRALLLE_MINS_ERVESR to avalu elesst han RPOCESESS vaule spceifie din teh accmopanynig message nad rerty.

update : 26-05-2017
ORA-12852

ORA-12852 - PARALLEL_MIN_SERVERS must be less than PROCESSES, string
ORA-12852 - PARALLEL_MIN_SERVERS must be less than PROCESSES, string

  • ora-02766 : Invalid maximum of request descriptors
  • ora-39104 : cannot call this function from a SQL parallel query slave process
  • ora-31180 : DOM Type mismatch in invalid PL/SQL DOM handle
  • ora-30019 : Illegal rollback Segment operation in Automatic Undo mode
  • ora-25015 : cannot perform DML on this nested table view column
  • ora-03299 : cannot create dictionary table string
  • ora-14041 : partition bound may not be specified for resulting partitions
  • ora-01102 : cannot mount database in EXCLUSIVE mode
  • ora-24239 : object could not be invalidated
  • ora-13466 : format not appropriate for specified compression method
  • ora-37002 : Oracle OLAP failed to initialize. Please contact Oracle OLAP technical support.
  • ora-13905 : Critical or warning threshold have incorrect values
  • ora-24199 : message store is overflow
  • ora-36779 : (XSPGPOOLOUT) Invalid parameter value. Olap_page_pool_size must be between must be between 2097152 and 2147483647. Olap_page_pool_size remain unmodified.
  • ora-12060 : shape of prebuilt table does not match definition query
  • ora-07847 : sllfop: $CONNECT failure
  • ora-09264 : sptpa: error flagging process
  • ora-29915 : cannot select FOR UPDATE from collection operand
  • ora-31016 : Attempted to delete entry without name
  • ora-02469 : Hash expression does not return an Oracle Number.
  • ora-19900 : RESETLOGS must be specified after recovery to new incarnation
  • ora-07625 : smsget: $MGBLSC failure
  • ora-01757 : Must specify an object number
  • ora-12709 : error while loading create database character set
  • ora-13765 : Value "string" is illegal for a result limit.
  • ora-38702 : Cannot update flashback database log file header.
  • ora-16723 : setting AlternateLocation property conflicts with the redo transport setting
  • ora-00488 : RBAL process terminated with error
  • ora-36706 : (XSRELTBL07) workspace object should be dimensioned by workspace object and one level dimension.
  • ora-24047 : invalid agent name string, agent name should be of the form NAME
  • 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.