ORA-10382: parallel query server interrupt (reset)

Cause : internal use only

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

this event should never be set externally

update : 24-07-2017
ORA-10382

ORA-10382 - parallel query server interrupt (reset)
ORA-10382 - parallel query server interrupt (reset)

  • ora-28526 : invalid describe information returned to Heterogeneous Services
  • ora-28275 : Multiple mappings for user nickname to LDAP distinguished name exist.
  • ora-06028 : NETASY: unable to intialise for logging
  • ora-39200 : Link name "string" is invalid.
  • ora-00471 : DBWR process terminated with error
  • ora-30678 : too many open connections
  • ora-16653 : failed to reinstate database
  • ora-39038 : Object path "string" is not supported for string jobs.
  • ora-24126 : invalid CASCADE_FLAG passed to DBMS_REPAIR.string procedure
  • ora-29894 : base or varray datatype does not exist
  • ora-06913 : CMX: error during redirection of connection
  • ora-16172 : archive logs detected beyond Terminal End-Of-Redo
  • ora-01622 : thread number must be specified - default not specific
  • ora-33048 : (XSAGDNGL23) In AGGMAP workspace object, the relation workspace object and the relation workspace object are both over the same base dimension.
  • ora-24341 : bad mode specified
  • ora-13343 : a polygon geometry has fewer than four coordinates
  • ora-04021 : timeout occurred while waiting to lock object stringstringstringstringstring
  • ora-07468 : spwat: mset error, unable to set semaphore.
  • ora-36712 : (XSMXALLOC02) Relation workspace object must be a one-dimensional self-relation to be used as a SOURCE or BASIS with ALLOCATE.
  • ora-23329 : successful user-provided ddl but no materialized view "string"."string"
  • ora-14632 : cannot specify PARALLEL clause when adding a List subpartition
  • ora-36913 : (XSAGDNGL49) In AGGMAP workspace object, LOAD_STATUS object workspace object must be an undimensioned VALUESET over the relation dimension.
  • ora-16583 : bad Data Guard Connection Process DRCX state
  • ora-08455 : syntax error in CURRENCY SIGN environment clause
  • ora-01172 : recovery of thread string stuck at block string of file string
  • ora-12235 : TNS:Failure to redirect to destination
  • ora-16635 : NetSlave connection was broken in the middle of a transmission session
  • ora-31459 : system triggers for DBMS_CDC_PUBLISH package are not installed
  • ora-38304 : missing or invalid user name
  • ora-01093 : ALTER DATABASE CLOSE only permitted with no sessions connected
  • 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.