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-06-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-01987 : client os username is too long
  • ora-06111 : NETTCP: disconnect failure
  • ora-12628 : TNS:no event callbacks
  • ora-06402 : NETCMN: error receiving break message
  • ora-38750 : FLASHBACK DATABASE may not be performed using a dispatcher.
  • ora-02280 : duplicate or conflicting CYCLE/NOCYCLE specifications
  • ora-22294 : cannot update a LOB opened in read-only mode
  • ora-02736 : osnfpm: illegal default shared memory address
  • ora-07569 : slspool: $CLOSE failure
  • ora-00127 : dispatcher string does not exist
  • ora-28602 : statement not permitted on tables containing bitmap indexes
  • ora-32322 : PCT refresh of "string"."string" not allowed the sequence of DMLs/PMOPs
  • ora-12409 : policy startup failure for string policy
  • ora-36198 : (XSAGGR33) The AGGREGATE operator string does not require a weight, but ARGS variable workspace object specified workspace object as a weight.
  • ora-06525 : Length Mismatch for CHAR or RAW data
  • ora-16642 : db_unique_name mismatch
  • ora-24905 : invalid recepient protocol attribute passed into OCI call
  • ora-02263 : need to specify the datatype for this column
  • ora-09961 : Unable to restore termination signal handler
  • ora-16151 : Managed Standby Recovery not available
  • ora-01721 : USERENV(COMMITSCN) invoked more than once in a transaction
  • ora-00154 : protocol error in transaction monitor
  • ora-01037 : maximum cursor memory exceeded
  • ora-30929 : ORDER SIBLINGS BY clause not allowed here
  • ora-14095 : ALTER TABLE EXCHANGE requires a non-partitioned, non-clustered table
  • ora-00487 : CTWR process terminated with error
  • ora-13022 : polygon crosses itself
  • ora-29867 : cannot create a domain index on a LONG column
  • ora-02164 : DATAFILE clause specified more than once
  • ora-00701 : object necessary for warmstarting database cannot be altered
  • 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.