ORA-12820: invalid value for DEGREE

Cause : invalid value for DEGREE was specified within a PARALLEL clause.

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

specify a positive integer or DEFAULT for the DEGREE option within a PARALLEL clause.

update : 25-04-2017

ORA-12820 - invalid value for DEGREE
ORA-12820 - invalid value for DEGREE

  • ora-19596 : SPFILE already included
  • ora-01598 : rollback segment 'string' is not online
  • ora-31669 : Worker process string violated startup protocol.
  • ora-02172 : The PUBLIC keyword is not appropriate for a disable thread
  • ora-24058 : cannot downgrade QUEUE_TABLE that has propagation in a prepared state
  • ora-30688 : maximum program calling depth exceeded
  • ora-29344 : Owner validation failed - failed to match owner 'string'
  • ora-26027 : unique index string.string partition string initially in unusable state
  • ora-08465 : input mask contains more than 32 characters
  • ora-39174 : Encryption password must be supplied.
  • ora-24051 : cannot propagate object type payloads that have a REF attribute
  • ora-26020 : index string.string loaded successfully with string keys
  • ora-30352 : inconsistent numeric precision or string length
  • ora-14102 : only one LOGGING or NOLOGGING clause may be specified
  • ora-15124 : ASM file name 'string' contains an invalid alias name
  • ora-16174 : user requested thread/sequence termination of managed recovery
  • ora-37008 : (AWLISTALL06) number writers
  • ora-38732 : Expected file size string does not match string.
  • ora-07477 : scgcmn: lock manager not initialized.
  • ora-25238 : too many recipients specified for message destination string
  • ora-01093 : ALTER DATABASE CLOSE only permitted with no sessions connected
  • ora-13644 : The user "string" is invalid.
  • ora-37103 : (XSVPART03) The dimensionality or datatype of workspace object does not match the dimensionality or datatype of the partition.
  • ora-26683 : invalid value for value_type
  • ora-02459 : Hashkey value must be a positive integer
  • ora-12400 : invalid argument to facility error handling
  • ora-07264 : spwat: semop error, unable to decrement semaphore.
  • ora-29509 : incorrectly formed Java binary class definition
  • ora-27065 : cannot perform async vector I/O to file
  • ora-07447 : ssarena: usinit failed.
  • 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.