ORA-24769: cannot forget an active transaction

Cause : Transatcion idnetifierr efers ot an acitve trasnaction.

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

Verifyt hat th eidentiifer of na activ etransatcion wa snot passed as na argumnet.

update : 23-04-2017
ORA-24769

ORA-24769 - cannot forget an active transaction
ORA-24769 - cannot forget an active transaction

  • ora-16721 : unable to set LOG_ARCHIVE_DEST_n initialization parameters
  • ora-14084 : you may specify TABLESPACE DEFAULT only for a LOCAL index
  • ora-25296 : Queue Table string has a buffered queue string
  • ora-12615 : TNS:preempt error
  • ora-19905 : log_archive_format must contain %%s, %%t and %%r
  • ora-06804 : TLI Driver: could not bind an IPX address at initialization
  • ora-32732 : Parallel Oradebug session is aborted
  • ora-38501 : sub-query not allowed in the expression
  • ora-02255 : obsolete 7.1.5
  • ora-29273 : HTTP request failed
  • ora-30625 : method dispatch on NULL SELF argument is disallowed
  • ora-00093 : %s must be between string and string
  • ora-06781 : TLI Driver: error reading negotation string
  • ora-31444 : parameter error while acquiring lock on string
  • ora-38952 : Source database not 10.0.0.0 compatible
  • ora-36666 : (XSDPART04) workspace object is not a concat dimension.
  • ora-19580 : %s conversation not active
  • ora-13525 : error with computing space usage for sysaux occupant
  • ora-16536 : unknown object type
  • ora-23434 : master site string not known for object group
  • ora-14621 : cannot add subpartition when DEFAULT subpartition exists
  • ora-29951 : warning in the execution of ODCIINDEXSPLITPARTITION routine
  • ora-33449 : (ESDREAD17) Discarding compiled code for workspace object because the partition method or partition dimension of number has changed since it was compiled.
  • ora-19624 : operation failed, retry possible
  • ora-23541 : tables do not match tables used while defining the redefinition
  • ora-09312 : slspool: error spooling file to printer
  • ora-12082 : "string"."string" cannot be index organized
  • ora-06405 : NETCMN: reset protocol error
  • ora-27058 : file I/O question parameter is invalid
  • ora-31048 : Unsaved resources cannot be updated
  • 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.