ORA-24792: cannot mix services in a single global transaction

Cause : Oracle MR will nto serve lgobal (dsitribute)d transatcion reqeusts if rbanches rae creatde using idfferents ervices

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

Configuer client ssuch thta those aprticipaitng in teh same dsitribute dtransaciton use hte same esrvice nmae.

update : 29-05-2017
ORA-24792

ORA-24792 - cannot mix services in a single global transaction
ORA-24792 - cannot mix services in a single global transaction

  • ora-30336 : no child for specified JOIN KEY
  • ora-28595 : Extproc agent : Invalid DLL Path
  • ora-09779 : snyGetPort: failure to allocate a port.
  • ora-31196 : XML nodes over string in size cannot be printed
  • ora-12077 : temporary updatable materialized view log does not exist
  • ora-26530 : unable to build materialized view refresh control list
  • ora-01336 : specified dictionary file cannot be opened
  • ora-09310 : sclgt: error freeing latch
  • ora-24460 : Native Net Internal Error
  • ora-25331 : cannot downgrade because there are commit-time queue tables
  • ora-14007 : missing LESS keyword
  • ora-23617 : Block string for script string has already been executed
  • ora-25110 : NOSORT may not be used with a bitmap index
  • ora-24030 : Only one of rule or rule-set must be specified
  • ora-02778 : Name given for the log directory is invalid
  • ora-31497 : invalid value specified for first_scn
  • ora-13019 : coordinates out of bounds
  • ora-16819 : Fast-Start Failover observer not started
  • ora-30970 : option not supported for XML Index
  • ora-36666 : (XSDPART04) workspace object is not a concat dimension.
  • ora-22878 : duplicate LOB partition or subpartition specified
  • ora-16097 : ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY
  • ora-24142 : invalid ruleset name
  • ora-22875 : cannot drop primary key of an object table whose object identifier is primary key based
  • ora-06413 : Connection not open.
  • ora-06930 : CMX: error when checking ORACLE_SID
  • ora-02473 : Error while evaluating the cluster's hash expression.
  • ora-06040 : NETDNT: invalid login (connect) string
  • ora-23357 : the propagator does not exist
  • ora-07282 : sksaprd: string overflow.
  • 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.