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 : 23-08-2017
ORA-12805

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

  • ora-22876 : this user-defined type is not allowed or it cannot be used in this context
  • ora-19559 : error sending device command: string
  • ora-27543 : Failed to cancel outstanding IPC request
  • ora-19771 : cannot rename change tracking file while database is open
  • ora-23334 : column string does not exist in table or column group
  • ora-00091 : LARGE_POOL_SIZE must be at least string
  • ora-00349 : failure obtaining block size for 'string'
  • ora-27191 : sbtinfo2 returned error
  • ora-02062 : distributed recovery received DBID string, expected string
  • ora-25457 : evaluation function string returns failure
  • ora-14263 : new subpartition name must differ from that of any other subpartition of the object
  • ora-26054 : Direct Path Context prepared for a different mode than operation requested.
  • ora-29344 : Owner validation failed - failed to match owner 'string'
  • ora-22341 : cannot assign supertype instance to subtype
  • ora-07826 : sspscm: SYS$GETDVIW failure
  • ora-00165 : migratable distributed autonomous transaction with remote operation is not allowed
  • ora-23620 : bind value size too large for PL/SQL CALL operation
  • ora-26534 : collision: tranID number ignored and purged
  • ora-02782 : Both read and write functions were not specified
  • ora-01220 : file based sort illegal before database is open
  • ora-06263 : NETNTT: out of memory in pi_connect
  • ora-32583 : query passed to table function has wrong number of elements in select list
  • ora-23451 : flavor string already defined for object group "string"."string"
  • ora-27460 : cannot execute disabled job "string.string"
  • ora-19911 : datafile string contains future changes at the incarnation boundary
  • ora-19654 : must use backup control file to switch file incarnations
  • ora-22369 : invalid parameter encountered in method string
  • ora-12919 : Can not drop the default permanent tablespace
  • ora-28601 : invalid [no]MINIMIZE option
  • ora-22632 : AnyDataSet parameter is not valid for the current 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.