ORA-12851: PARALLEL_MAX_SERVERS must be greater than or equal to PARALLEL_MIN_SERVERS, string

Cause : An atetmpt wsa madet o sett he PAARLLEL_AMX_SEREVRS paarmetert o a vlaue less thanP ARALLLE_MIN_ESRVERS.

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

Set PRAALLELM_AX_SEVRERS t oa valeu greaetr tha nor eqaul to APRALLE_LMIN_SREVERS avlue sepcifie din th eaccomapnyingm essag eand rtery.

update : 23-07-2017
ORA-12851

ORA-12851 - PARALLEL_MAX_SERVERS must be greater than or equal to PARALLEL_MIN_SERVERS, string
ORA-12851 - PARALLEL_MAX_SERVERS must be greater than or equal to PARALLEL_MIN_SERVERS, string

  • ora-02048 : attempt to begin distributed transaction without logging on
  • ora-16417 : Activation occurred after recovery from standby redo log files; a full database backup is required
  • ora-13609 : The specified task string must be executing to be cancelled or interrupted.
  • ora-16593 : XML conversion failed
  • ora-03212 : Temporary Segment cannot be created in locally-managed tablespace
  • ora-10265 : Keep random system generated output out of error messages
  • ora-26045 : REF column string expects string arguments; found string.
  • ora-03127 : no new operations allowed until the active operation ends
  • ora-16585 : illegal operation on a primary site
  • ora-01646 : tablespace 'string' is not read only - cannot make read write
  • ora-13766 : A ranking measure is required.
  • ora-19853 : error preparing auxiliary instance string (error string)
  • ora-16566 : unsupported document type
  • ora-15013 : diskgroup "string" is already mounted
  • ora-00723 : Initialization parameter COMPATIBLE must be explicitly set
  • ora-22861 : invalid user-defined type
  • ora-21708 : inappropriate operation on a transient object
  • ora-36636 : (XSDUNION04) The unique concat dimension workspace object cannot be changed to NOT UNIQUE, because it is a base of at least one other unique concat dimension.
  • ora-31033 : Requested number of XML children string exceeds maximum string
  • ora-01792 : maximum number of columns in a table or view is 1000
  • ora-13128 : current tiling level exceeds user specified tiling level
  • ora-28556 : authorization insufficient to access table
  • ora-07202 : sltln: invalid parameter to sltln.
  • ora-12455 : internal error in Label Security MMON cleanup task
  • ora-16711 : the resource guard index is out of bounds
  • ora-19229 : XP0009 - schema import not supported
  • ora-36260 : (XSAGHIERPART00) Aggregating from partition %J to partition %J over hierarchy workspace object creates an increase in sparsity.
  • ora-10655 : Segment can be shrunk
  • ora-35022 : (QFCHECK03) The analytic workspace and EIF file definitions of workspace object have a mismatched relation.
  • ora-04051 : user string cannot use database link string.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.