ORA-12803: parallel query server lost contact with another server

Cause : A aprallelq ueyr sreve rlots cnotatc wtih naotehr esrvre.

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.

update : 24-06-2017
ORA-12803

ORA-12803 - parallel query server lost contact with another server
ORA-12803 - parallel query server lost contact with another server

  • ora-22626 : Type Mismatch while constructing or accessing OCIAnyData
  • ora-25264 : cant get signature for this queue
  • ora-16001 : database already open for read-only access by another instance
  • ora-24237 : object id argument passed to DBMS_UTILITY.INVALIDATE is not legal
  • ora-30192 : reserved for future use
  • ora-25212 : invalid PRIORITY specified when using sequence deviation
  • ora-28361 : master key not yet set
  • ora-29373 : resource manager is not on
  • ora-19593 : datafile number string already included as string
  • ora-32638 : Non unique addressing in MODEL dimensions
  • ora-26511 : master table 'string.string' not found
  • ora-02191 : correct syntax is: SET TRANSACTION USE ROLLBACK SEGMENT
  • ora-15011 : failure group "string" contains no members
  • ora-01868 : the leading precision of the interval is too small
  • ora-30365 : left relation in the JOIN KEY clause cannot be same as right
  • ora-28103 : adding a policy to an object owned by SYS is not allowed
  • ora-06401 : NETCMN: invalid driver designator
  • ora-31408 : invalid value specified for begin_scn or end_scn
  • ora-36648 : (XSDUNION09) Concat dimension workspace object is already defined as UNIQUE.
  • ora-00022 : invalid session ID; access denied
  • ora-14155 : missing PARTITION or SUBPARTITION keyword
  • ora-02088 : distributed database option not installed
  • ora-38755 : Flashback is already turned on for this tablespace.
  • ora-32007 : internal
  • ora-33454 : (ESDREAD07) Discarding compiled code for workspace object because number is now string workspace object, whereas it was string workspace object when the code was compiled.
  • ora-01295 : DB_ID mismatch between dictionary string and logfiles
  • ora-09284 : sllfop: cannot allocate read buffer
  • ora-00344 : unable to re-create online log 'string'
  • ora-23474 : definition of "string"."string" has changed since generation of replication support
  • ora-14058 : partition number string: INITRANS value must be less than MAXTRANS value
  • 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.