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


update : 23-07-2017

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

  • ora-19333 : Invalid flags for the CREATE_DBURI operator
  • ora-24790 : cannot mix OCI_TRANS_RESUME and transaction isolation flags
  • ora-16641 : failure to acquire broker configuration metadata lock
  • ora-06537 : OUT bind variable bound to an IN position
  • ora-29394 : session id string and serial# string do not exist
  • ora-29801 : missing RETURN keyword
  • ora-36652 : (XSDUNION11) workspace object is not a string type dimension.
  • ora-08112 : a composite partition may not be coalesced as a whole
  • ora-31626 : job does not exist
  • ora-01155 : the database is being opened, closed, mounted or dismounted
  • ora-25248 : duplicate agent specified in the agent list
  • ora-12675 : External user name not available yet
  • ora-32300 : cannot drop a secondary materialized view "string"."string"
  • ora-12354 : secondary object being dropped
  • ora-12521 : TNS:listener does not currently know of instance requested in connect descriptor
  • ora-40208 : duplicate or multiple algorithm settings for function string
  • ora-27454 : argument name and position cannot be NULL
  • ora-01245 : offline file string will be lost if RESETLOGS is done
  • ora-15056 : additional error message
  • ora-02469 : Hash expression does not return an Oracle Number.
  • ora-24240 : invalid database access descriptor (DAD) name
  • ora-12595 : TNS:no confirmation
  • ora-22909 : exceeded maximum VARRAY limit
  • ora-24273 : translation text is required if translation type is T or S
  • ora-01640 : cannot make tablespace read only with active transactions
  • ora-24037 : schema string in QUEUE_NAME is not same as schema string in QUEUE_TABLE
  • ora-38487 : FUNCTION/PACKAGE/TYPE "string" not allowed in the expression
  • ora-26024 : SKIP_UNUSABLE_INDEXES requested and index segment was initially unusable
  • ora-19331 : Last argument to CREATE_DBURI operator must be a column
  • ora-37113 : OLAP API initialization error: (string)
  • 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.