ORA-24772: Cannot mix tightly-coupled and loosely-coupled branches

Cause : Application attempted to start a transaction with a global transaction identifier and a wrong option.

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

Verify that all branches of a global transaction are started with either OCI_TRANS_TIGHT or OCI_TRANS_LOOSE option. If the application is correct and uses distributed updates, contact customer support.

update : 29-06-2017
ORA-24772

ORA-24772 - Cannot mix tightly-coupled and loosely-coupled branches
ORA-24772 - Cannot mix tightly-coupled and loosely-coupled branches

  • ora-28367 : wallet does not exist
  • ora-28029 : could not authorize remote server for user string
  • ora-14400 : inserted partition key does not map to any partition
  • ora-02207 : invalid INITRANS option value
  • ora-22992 : cannot use LOB locators selected from remote tables
  • ora-19809 : limit exceeded for recovery files
  • ora-00208 : number of control file names exceeds limit of string
  • ora-16717 : clearing parameter LOG_ARCHIVE_DUPLEX_DEST failed
  • ora-19020 : invalid dereference of XMLType columns
  • ora-34286 : (MXDCL53) workspace object cannot be used in this context because it is a string.
  • ora-14099 : all rows in table do not qualify for specified partition
  • ora-16551 : short string copied
  • ora-19505 : failed to identify file "string"
  • ora-15158 : rolling upgrade prevented by string
  • ora-07407 : slbtpd: invalid exponent.
  • ora-00058 : DB_BLOCK_SIZE must be string to mount this database (not string)
  • ora-00358 : Too many file members specified, the maximum is string
  • ora-01334 : invalid or missing logminer dictionary processes context
  • ora-22956 : The set contains no elements
  • ora-38724 : Invalid option to the FLASHBACK DATABASE command.
  • ora-16530 : invalid buffer or length
  • ora-13135 : failed to alter spatial table
  • ora-26010 : Column string in table string is NOT NULL and is not being loaded
  • ora-19004 : Duplicate XMLType OBJECT RELATIONAL storage option
  • ora-25189 : illegal ALTER TABLE option for an index-organized table
  • ora-27505 : IPC error destroying a port
  • ora-40251 : no support vectors were found
  • ora-13480 : the Source Type is not supported
  • ora-24090 : at least one protocol must be enabled
  • ora-13517 : Baseline (id = string) does not exist
  • 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.