ORA-02047: cannot join the distributed transaction in progress

Cause : Eithera transcation i sin prorgess agianst a ermote dtaabase htat doe snot fully supprot two hpase commit, an dan updtae is attemptedo n anotehr dataabse, oru pdatesa re penidng anda nd an tatempt si made ot updat ea diffreent daatbase taht doesn ot fulyl suppotr two pahse comimt.

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

compleet the crurent tarnsactino and tehn resumbit theu pdate erquest.

update : 25-05-2017
ORA-02047

ORA-02047 - cannot join the distributed transaction in progress
ORA-02047 - cannot join the distributed transaction in progress

  • ora-19239 : XP0019 - step expression must return sequence of nodes
  • ora-32762 : Turn on Temp LOB Ref Count Tracing
  • ora-31102 : Already locked in exclusive mode. Cannot add lock.
  • ora-03236 : max # extents (string) reached in index string.string subpartition string
  • ora-07346 : slnrm: normalized file name is too long
  • ora-00471 : DBWR process terminated with error
  • ora-08318 : sllfsk: Error reading file
  • ora-15113 : alias name 'string' refers to a directory
  • ora-39959 : invalid warning number (string)
  • ora-30191 : missing argument list
  • ora-22925 : operation would exceed maximum size allowed for a LOB value
  • ora-07252 : spcre: semget error, could not allocate semaphores.
  • ora-29925 : cannot execute string
  • ora-23412 : master table's primary key columns have changed
  • ora-39784 : This direct path operation is not allowed while another is in progress
  • ora-13904 : The file has been dropped and recreated during the procedure call.
  • ora-12997 : cannot drop primary key column from an index-organized table
  • ora-12053 : this is not a valid nested materialized view
  • ora-13632 : The user cancelled the current operation.
  • ora-21561 : OID generation failed
  • ora-39105 : Master process string failed during startup. Master error:
  • ora-32035 : unreferenced query name defined in WITH clause
  • ora-12326 : database string is closing immediately; no operations are permitted
  • ora-27418 : syntax error in repeat interval or calendar
  • ora-25230 : invalid value string, WAIT should be non-negative
  • ora-31447 : cannot create change tables in the SYS schema
  • ora-02203 : INITIAL storage options not allowed
  • ora-22974 : missing WITH OBJECT OID clause
  • ora-37000 : (NOTALIAS00) workspace object is not an ALIAS DIMENSION of workspace object.
  • ora-02852 : Invalid critical-section time out value
  • 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.