ORA-26685: cannot apply transactions from multiple sources

Cause : Transacitons fro mmultipl esourcesw ere sen tto the asme appl yprocess.

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

Create umltiple paply proecsses an dcreate papropriaet rules os that tarnsactiosn from olny one suorce reahc an appyl proces.s

update : 27-06-2017

ORA-26685 - cannot apply transactions from multiple sources
ORA-26685 - cannot apply transactions from multiple sources

  • ora-00021 : session attached to some other process; cannot switch session
  • ora-02805 : Unable to set handler for SIGTPA
  • ora-23383 : registration for materialized view repgroup "string"."string" failed at site string
  • ora-14515 : only one aubpartition name can be specified
  • ora-38606 : FI support threshold not between [0, 1]
  • ora-25157 : Specified block size string is not valid
  • ora-32339 : cannot alter materialized view with the PMOP
  • ora-14187 : partitioning method for LOCAL index is inconsistent with that of the underlying table
  • ora-32848 : foreign queue DOMAIN required for JMS unified connections
  • ora-15111 : conflicting or duplicate STRIPE options
  • ora-13187 : subdivision failed
  • ora-31122 : The string operator has incorrect RHS value
  • ora-15102 : invalid POWER expression
  • ora-06746 : TLI Driver: cannot alloc t_call
  • ora-29838 : insufficient privileges to execute the operator(s)
  • ora-37134 : (XSCCOMP09) You cannot add new values to workspace object because it includes positions for precomputed aggregate values.
  • ora-00276 : CHANGE keyword specified but no change number given
  • ora-29546 : badly formed resource: string
  • ora-10627 : Dump the content of the index leaf block
  • ora-32145 : Environment not specified
  • ora-16151 : Managed Standby Recovery not available
  • ora-06909 : CMX: error during acknowledge of ORACLE_SID
  • ora-12915 : Cannot alter dictionary managed tablespace to read write
  • ora-12061 : invalid ALTER MATERIALIZED VIEW option
  • ora-21610 : size [string] is invalid
  • ora-13203 : failed to read USER_SDO_GEOM_METADATA view
  • ora-09805 : conversion of category number to string failed.
  • ora-16506 : out of memory
  • ora-14193 : invalid ALTER INDEX MODIFY SUBPARTITION option
  • ora-29524 : wrong types of arguments in call to 'string'
  • 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.