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 : 30-04-2017

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

  • ora-39004 : invalid state
  • ora-01933 : cannot create a stored object using privileges from a role
  • ora-14257 : cannot move partition other than a Range or Hash partition
  • ora-13052 : unsupported geometric type for geometry string.string
  • ora-12235 : TNS:Failure to redirect to destination
  • ora-08468 : mask option string is not supported
  • ora-02475 : maximum cluster chain block count of string has been exceeded
  • ora-28010 : cannot expire external or global accounts
  • ora-39086 : cannot retrieve job information
  • ora-29707 : inconsistent value string for initialization parameter string with other instances
  • ora-02028 : fetching an exact number of rows is not supported by the server
  • ora-15178 : directory 'string' is not empty; cannot drop this directory
  • ora-25957 : join index where clause cannot contain cycles
  • ora-24230 : input to DBMS_DDL.WRAP is not a legal PL/SQL unit
  • ora-33262 : (DBERR01) Analytic workspace string does not exist.
  • ora-06546 : DDL statement is executed in an illegal context
  • ora-26527 : local store callback init phase failed for 'string.string'
  • ora-22809 : nonexistent attribute
  • ora-13501 : Cannot drop SYSAUX tablespace
  • ora-00305 : log string of thread string inconsistent; belongs to another database
  • ora-12549 : TNS:operating system resource quota exceeded
  • ora-30135 : OCI Thread operation fails
  • ora-06918 : CMX: T_NOEVENT during wait for read event
  • ora-06756 : TLI Driver: cannot open oratab
  • ora-33080 : (XSAGDNGL40) In AGGMAP workspace object, you cannot reference dimension workspace object with both a RELATION statement and a DIMENSION statement.
  • ora-13292 : incorrect ARC_TOLERANCE specification
  • ora-22854 : invalid option for LOB storage index
  • ora-24809 : amount specified will not fit in the lob buffers
  • ora-16585 : illegal operation on a primary site
  • ora-02353 : files not from the same unload operation
  • 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.