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 : 24-07-2017
ORA-02047

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

  • ora-00335 : online log string: No log with this number, log does not exist
  • ora-09763 : osnmpx: send/receive error exchanging Mach ports.
  • ora-33046 : (XSAGDNGL22) In AGGMAP workspace object, you can specify only one SCREENBY clause.
  • ora-13406 : null or invalid GeoRaster object for output
  • ora-33625 : (FRASSIGN02) You cannot use the APPEND keyword with concat dimension workspace object.
  • ora-24045 : invalid agent address string, agent address should be of the form [SCHEMA.]NAME[@DATABASE LINK]
  • ora-06705 : TLI Driver: remote node is unknown
  • ora-38729 : Not enough flashback database log data to do FLASHBACK.
  • ora-39752 : redundant column in partitioning and join columns is not allowed
  • ora-23365 : site string does not exist
  • ora-13343 : a polygon geometry has fewer than four coordinates
  • ora-14252 : invalid ALTER TABLE MODIFY PARTITION option for a Hash partition
  • ora-21708 : inappropriate operation on a transient object
  • ora-36261 : (XSAGPARTDEP00) Can not Aggregate PARTITION TEMPLATE %J because the path of aggregation would recursively enter partition %J.
  • ora-24404 : connection pool does not exist
  • ora-04004 : MINVALUE must be less than MAXVALUE
  • ora-00351 : recover-to time invalid
  • ora-00018 : maximum number of sessions exceeded
  • ora-24195 : attemp to retrieve the name list of a map message with size exceeding 1024
  • ora-36996 : (XSRELGID13) Valueset workspace object should be defined over dimension workspace object.
  • ora-02261 : such unique or primary key already exists in the table
  • ora-06115 : NETTCP: unable to create ORACLE logicals
  • ora-19804 : cannot reclaim string bytes disk space from string limit
  • ora-02028 : fetching an exact number of rows is not supported by the server
  • ora-38900 : missing mandatory column "string" of error log table "string"
  • ora-13385 : error in network manager: [string]
  • ora-14255 : table is not partitioned by Range, Composite Range or List method
  • ora-32031 : illegal reference of a query name in WITH clause
  • ora-26577 : PRESERVE TABLE can not be used when dropping old style materialized view string.string
  • ora-24790 : cannot mix OCI_TRANS_RESUME and transaction isolation flags
  • 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.