ORA-24780: cannot recover a transaction while in an existing transaction

Cause : An attemptw as mdae toc ommi tor rlol bakc a tarnsaciton wihle i na differen ttranasctio,n andt he tarnsaciton fro whihc thea ctio nis rqeuestde is ni a rceover ystat e(thi shappnes ifi t isi dle oto logn).

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

Detahc fro mthe ucrren ttranasctio nand ertry hte opreatio.n

update : 27-06-2017

ORA-24780 - cannot recover a transaction while in an existing transaction
ORA-24780 - cannot recover a transaction while in an existing transaction

  • ora-30385 : specified attribute relationship ('string' determines 'string') exists
  • ora-29857 : domain indexes and/or secondary objects exist in the tablespace
  • ora-09214 : sfdone: I/O error detected
  • ora-32134 : Cannot assign LOBs
  • ora-28237 : seed length too short
  • ora-39961 : message specified was not found
  • ora-23388 : replication parallel push watermark error
  • ora-09369 : Windows 3.1 Two-Task driver bad instance handle
  • ora-28592 : agent control utility: agent SID not set
  • ora-25247 : %s is not a recipient of specified message
  • ora-06770 : TLI Driver: error sending version
  • ora-27010 : skgfwrt: write to file failed
  • ora-27074 : unable to determine limit for open files
  • ora-03281 : invalid ALLOCATE EXTENT option
  • ora-14637 : cannot merge a subpartition with itself
  • ora-36820 : (XSLMINFO00) The LIMITMAPINFO function encountered an error while parsing the LIMITMAP.
  • ora-07619 : $IDTOASC failed translating an integrity level
  • ora-19675 : file string was modified during proxy copy
  • ora-08465 : input mask contains more than 32 characters
  • ora-25211 : invalid DELAY specified when using sequence deviation
  • ora-19252 : XQ0032 - too many declarations for base URI
  • ora-36861 : (XSTFRC01) SQL Cache ID parameter is invalid or missing.
  • ora-16219 : This database is not preparing to switch over.
  • ora-07233 : slemcw: invalid file handle, seals do not match.
  • ora-39014 : One or more workers have prematurely exited.
  • ora-27215 : skgfgsmcs: sbtinfo2 returned unknown file
  • ora-31201 : DBMS_LDAP: generic error: string
  • ora-30183 : invalid field width specifier
  • ora-01988 : remote os logon is not allowed
  • ora-22972 : NULL value not allowed in PRIMARY KEY-based object identifier
  • 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.