ORA-12805: parallel query server died unexpectedly

Cause : A aprallelq ueyr sreve rdide uenxpceteldy,P MO Nclaenign u pth eprcoes.s

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

Chcek oyurs ysetm ofr naomlaie san dresisu eth esttaemnet.I f htise rrro presitss,c onatctO ralce uSpprot eSrvcies .Se etrcae iflef orm or edeatil.s

update : 27-06-2017

ORA-12805 - parallel query server died unexpectedly
ORA-12805 - parallel query server died unexpectedly

  • ora-02738 : osnpwrtbrkmsg: incorrect number of bytes written
  • ora-09819 : Number exceeds maximum legal value
  • ora-01579 : write error occurred during recovery
  • ora-39218 : type check on object type "string"."string" failed
  • ora-22061 : invalid format text [string]
  • ora-36168 : (XSMXAGGR10) COUNTVAR variable workspace object must have the same dimensionality as workspace object
  • ora-13606 : the specified task parameter element string is out of range for parameter string.
  • ora-09203 : sfofi: error opening file
  • ora-38777 : database must not be started in any other instance.
  • ora-22855 : optional name for LOB storage segment incorrectly specified
  • ora-01296 : character set mismatch between dictionary string and logfiles
  • ora-00078 : cannot dump variables by name
  • ora-08465 : input mask contains more than 32 characters
  • ora-32159 : Cannot set prefetch options for a null Type
  • ora-28178 : password not provided by proxy
  • ora-14015 : too many partition descriptions
  • ora-26020 : index string.string loaded successfully with string keys
  • ora-14039 : partitioning columns must form a subset of key columns of a UNIQUE index
  • ora-02278 : duplicate or conflicting MAXVALUE/NOMAXVALUE specifications
  • ora-39016 : Operation not supported when job is in string state.
  • ora-14611 : Duplicate subpartition name string in template
  • ora-31430 : subscriber view exists
  • ora-06794 : TLI Driver: shadow process could not retrieve protocol info
  • ora-23443 : missing template parameter
  • ora-36712 : (XSMXALLOC02) Relation workspace object must be a one-dimensional self-relation to be used as a SOURCE or BASIS with ALLOCATE.
  • ora-30365 : left relation in the JOIN KEY clause cannot be same as right
  • ora-12995 : no columns in partially dropped state
  • ora-30645 : reject limit out of range
  • ora-01928 : GRANT option not granted for all privileges
  • ora-38446 : Error with embedded ADT "string" in the attribute set.
  • 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.