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 : 25-04-2017

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

  • ora-22910 : cannot specify schema name for nested tables
  • ora-12505 : TNS:listener does not currently know of SID given in connect descriptor
  • ora-32819 : AQ queue string must be a normal queue
  • ora-27366 : job "string.string" is not running
  • ora-13000 : dimension number is out of range
  • ora-22997 : VARRAY | OPAQUE stored as LOB is not specified at the table level
  • ora-15175 : cannot create alias for diskgroup metadata file 'string'
  • ora-39763 : stream must be completely loaded before it is reset
  • ora-22305 : attribute/method/parameter "string" not found
  • ora-00396 : error string required fallback to single-pass recovery
  • ora-01877 : string is too long for internal buffer
  • ora-27365 : job has been notified to stop, but failed to do so immediately
  • ora-06916 : CMX: error in data read (t_datain)
  • ora-31025 : Invalid document element
  • ora-23392 : could not find materialized view to be associated with "string"."string"
  • ora-01489 : result of string concatenation is too long
  • ora-21611 : key length [string] is invalid
  • ora-00832 : no streams pool created and cannot automatically create one
  • ora-31679 : Table data object string has long columns, and longs can not be loaded/unloaded using a network link
  • ora-27303 : additional information: string
  • ora-01351 : tablespace given for Logminer dictionary does not exist
  • ora-28181 : proxy 'string' failed to enable one or more of the specified initial roles for client 'string'
  • ora-03278 : duplicate ALLOCATE EXTENT option specification
  • ora-32621 : illegal aggregation in UNTIL iteration condition
  • ora-02471 : SYSDATE, UID, USER, ROWNUM, or LEVEL incorrectly used in hash expression.
  • ora-30341 : dropped level has references
  • ora-12496 : cannot change existing level, category, or release numbers
  • ora-01125 : cannot disable media recovery - file string has online backup set
  • ora-13644 : The user "string" is invalid.
  • ora-02176 : invalid option for CREATE ROLLBACK SEGMENT
  • 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.