ORA-12810: PARALLEL_MAX_SERVERS must be less than or equal to string

Cause : An attempt was made to set the PARALLEL_MAX_SERVERS parameter to a value higher than the maximum allowed by the system.

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

Set PARALLEL_MAX_SERVERS to a value less than or equal to the maximum specified in the accompanying message and retry.

update : 23-08-2017
ORA-12810

ORA-12810 - PARALLEL_MAX_SERVERS must be less than or equal to string
ORA-12810 - PARALLEL_MAX_SERVERS must be less than or equal to string

  • ora-12592 : TNS:bad packet
  • ora-13768 : Snapshot ID must be between string and string.
  • ora-27197 : skgfprs: sbtpcrestore returned error
  • ora-31014 : Attempted to delete the root container
  • ora-03207 : subpartitioned type must be specified for composite object
  • ora-15196 : invalid ASM block header [string:string] [string] [string] [string] [string != string]
  • ora-01274 : cannot add datafile 'string' - file could not be created
  • ora-12071 : definition query of "string"."string" is invalid for offline instantiation
  • ora-19578 : end of volume while duplexing to sequential files, backup piece incomplete
  • ora-31159 : XML DB is in an invalid state
  • ora-30978 : The XML Index is not locally partitioned.
  • ora-12014 : table 'string' does not contain a primary key constraint
  • ora-14132 : table cannot be used in EXCHANGE
  • ora-25179 : invalid PCTTHRESHOLD storage option value
  • ora-39700 : database must be opened with UPGRADE option
  • ora-00339 : archived log does not contain any redo
  • ora-24169 : rule condition has unrecognized variables
  • ora-06539 : target of OPEN must be a query
  • ora-30355 : materialized view container does not exist
  • ora-29306 : datafile string is not online
  • ora-13800 : concurrent DDL failure on SQL repository objects
  • ora-39705 : component 'string' not found in registry
  • ora-14155 : missing PARTITION or SUBPARTITION keyword
  • ora-29658 : EXTERNAL NAME clause is not compatible with its supertype
  • ora-12235 : TNS:Failure to redirect to destination
  • ora-13618 : The specified value is not a valid value for procedure argument string.
  • ora-26742 : Maximum number of ignored transactions exceeded
  • ora-08103 : object no longer exists
  • ora-01538 : failed to acquire any rollback segment
  • ora-12544 : TNS:contexts have different wait/test functions
  • 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.