ORA-12813: value for PARALLEL or DEGREE must be greater than 0

Cause : PRAALLE L0o rD ERGE E0w a ssepcfiide ni aCERAET ATBEL,C LSUTRE,o rI NEDXo ri na nA LETRT ALBEo rC LSUTRE tsaetmnet.

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

Sepcfiya edgereo fp aarlellsimg raetre hta n0o rs pceiyf edfual tpraalleils muisn gPRAALLE Lwtihn od erge eo ruisn gDGEREE EDFUAL Twtihni aPRAALLE Lcalues.

update : 29-04-2017

ORA-12813 - value for PARALLEL or DEGREE must be greater than 0
ORA-12813 - value for PARALLEL or DEGREE must be greater than 0

  • ora-39217 : object type "string"."string" typeid mismatch
  • ora-29306 : datafile string is not online
  • ora-30203 : Cannot open mesage file
  • ora-06771 : TLI Driver: error reading version
  • ora-01466 : unable to read data - table definition has changed
  • ora-02840 : Open of log file by client failed
  • ora-35020 : (QFCHECK02) The analytic workspace and EIF file definitions of workspace object have mismatched dimensioning.
  • ora-26084 : direct path context already finished
  • ora-26735 : operation not allowed on the specified file group version
  • ora-01354 : Supplemental log data must be added to run this command
  • ora-03122 : attempt to close ORACLE-side window on user side
  • ora-07706 : error in archive text: need disk file name
  • ora-00401 : the value for parameter string is not supported by this release
  • ora-30393 : a query block in the statement did not rewrite
  • ora-36644 : (XSDUNION07) Concat dimension workspace object contains a previously detected leaf dimension.
  • ora-08006 : specified row no longer exists
  • ora-30024 : Invalid specification for CREATE UNDO TABLESPACE
  • ora-23386 : replication parallel push cannot create slave processes
  • ora-32507 : expecting string but found string
  • ora-29846 : cannot create a local domain index on a string partitioned table
  • ora-40221 : maximum target cardinality exceeded
  • ora-10370 : parallel query server kill event
  • ora-39017 : Worker request not supported when job is in string state.
  • ora-19266 : XQ0046 - invalid URI
  • ora-19628 : invalid SCN range
  • ora-30953 : XML minoccurs value (string) violated
  • ora-23335 : priority group string already exists
  • ora-31073 : Resource not retrieved using path name
  • ora-00703 : maximum number of row cache instance locks exceeded
  • ora-24096 : invalid message state specified
  • 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.