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 : 26-09-2017
ORA-24792

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

  • ora-24057 : cannot define subscriber with rule for queue string
  • ora-00206 : error in writing (block string, # blocks string) of control file
  • ora-02455 : The number of cluster key column must be 1
  • ora-28173 : certificate not provided by proxy
  • ora-16521 : unable to create generic template id
  • ora-29832 : cannot drop or replace an indextype with dependent indexes
  • ora-07219 : slspool: unable to allocate spooler argument buffer.
  • ora-38786 : Flash recovery area is not enabled.
  • ora-16215 : history metadata inconsistency
  • ora-16086 : standby database does not contain available standby log files
  • ora-14272 : only a partition with higher bound can be reused
  • ora-28347 : encryption properties mismatch
  • ora-12319 : database (link name string) is already open
  • ora-22922 : nonexistent LOB value
  • ora-33005 : (XSAGDIMBREAK) Invalid breakout for dimension workspace object.
  • ora-09320 : szrfc: unable to obtain the list of valid OS roles
  • ora-14118 : CHECK constraint mismatch in ALTER TABLE EXCHANGE PARTITION
  • ora-39702 : database not open for UPGRADE or DOWNGRADE
  • ora-06040 : NETDNT: invalid login (connect) string
  • ora-16785 : the database is not in ARCHIVELOG mode
  • ora-02715 : osnpgetbrkmsg: message from host had incorrect message type
  • ora-01240 : too many data files to add in one command
  • ora-28336 : cannot encrypt SYS owned objects
  • ora-16084 : an apply engine is already running
  • ora-10617 : Cannot create rollback segment in dictionary managed tablespace
  • ora-12542 : TNS:address already in use
  • ora-08312 : sllfop: unrecognized processing option
  • ora-20000 : %s
  • ora-22276 : invalid locator for LOB buffering
  • ora-28594 : agent control utility: invalid parameter name
  • 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.