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 : 30-05-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-28595 : Extproc agent : Invalid DLL Path
  • ora-04930 : open sequence number failed or initial state is valid
  • ora-00017 : session requested to set trace event
  • ora-15177 : cannot operate on system aliases
  • ora-13610 : The directive string does not exist for task string.
  • ora-38105 : Delete not yet supported when Update row-migration is possible
  • ora-25109 : standby lock name space has illegal character 'string'
  • ora-09873 : TASDEF_OPEN: open error when opening tasdef@.dbf file.
  • ora-07579 : spini: $DCLEXH failure
  • ora-07601 : spguno: $GETJPIW failure
  • ora-09976 : skxfqdini: Error Creating Port
  • ora-27013 : skgfqdel: cannot delete an open file
  • ora-29267 : illegal call
  • ora-09889 : osnTXtt: access error on oracle executable
  • ora-33262 : (DBERR01) Analytic workspace string does not exist.
  • ora-26724 : only SYS is allowed to set the Capture or Apply user to SYS.
  • ora-38612 : FI item length cannot exceed half of one database block.
  • ora-39093 : FLASHBACK automatically enabled to preserve database integrity.
  • ora-22875 : cannot drop primary key of an object table whose object identifier is primary key based
  • ora-09878 : sstascre/sstasat: shmat error, unable to attach tas write page
  • ora-06521 : PL/SQL: Error mapping function
  • ora-27371 : jobs of type EXECUTABLE are not supported on this platform
  • ora-19229 : XP0009 - schema import not supported
  • ora-27434 : cannot alter chain step job string.string.string
  • ora-28175 : incorrect certificate type
  • ora-29257 : host string unknown
  • ora-24004 : invalid column name string in SORT_LIST, should be ENQ_TIME or PRIORITY
  • ora-28651 : Primary index on IOTs can not be marked unusable
  • ora-15168 : rolling downgrade prevented by string
  • ora-02439 : Unique index on a deferrable constraint is not allowed
  • 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.