ORA-24785: Cannot resume a non-migratable transaction

Cause : An attempt was made to resume a non-migrateable transaction.

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

none

update : 26-09-2017
ORA-24785

ORA-24785 - Cannot resume a non-migratable transaction
ORA-24785 - Cannot resume a non-migratable transaction

  • ora-31010 : XML element index string exceeds maximum insertion index string
  • ora-14253 : table is not partitioned by Composite Range method
  • ora-27413 : repeat interval is too long
  • ora-01664 : Transaction which has expanded the Sort Segment has aborted
  • ora-00289 : suggestion : string
  • ora-01629 : max # extents (string) reached saving undo for tablespace string
  • ora-01342 : LogMiner can not resume session due to inability of staging checkpointed data
  • ora-40285 : label not in the model
  • ora-40225 : model is currently in use by another process
  • ora-30755 : error during expansion of view hierarchy
  • ora-38610 : FI "string" name prefix is reserved for frequent itemset counting
  • ora-02080 : database link is in use
  • ora-27048 : skgfifi: file header information is invalid
  • ora-32843 : value for string is outside the valid range of string to string
  • ora-22345 : recompile type string.string before attempting this operation
  • ora-07446 : sdnfy: bad value 'string' for parameter string.
  • ora-28661 : Object already has COMPRESS clause specified
  • ora-23406 : insufficient privileges on user "string"
  • ora-26724 : only SYS is allowed to set the Capture or Apply user to SYS.
  • ora-13505 : SYSAUX tablespace can not be made read only
  • ora-00407 : rolling upgrade from release string.string to string.string is not allowed
  • ora-01295 : DB_ID mismatch between dictionary string and logfiles
  • ora-09763 : osnmpx: send/receive error exchanging Mach ports.
  • ora-37155 : OLAP API bootstrap error: (case string)
  • ora-25295 : Subscriber is not allowed to dequeue buffered messages
  • ora-22131 : hexadecimal string length is zero
  • ora-33922 : (MAKEDCL35) You cannot define a surrogate of dimension workspace object because it is a time dimension.
  • ora-08459 : invalid format parameter length
  • ora-37113 : OLAP API initialization error: (string)
  • ora-12566 : TNS:protocol error
  • 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.