ORA-24791: invalid transaction start flags

Cause : An invalid transaction start flag was passed.

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

Verify that OCI_TRANS_LOOSE was not passed along with OCI_TRANS_JOIN, OCI_TRANS_RESUME.

update : 29-05-2017
ORA-24791

ORA-24791 - invalid transaction start flags
ORA-24791 - invalid transaction start flags

  • ora-25963 : join index must be created on tables
  • ora-32144 : Cannot perform operation on a null interval
  • ora-01126 : database must be mounted in this instance and not open in any instance
  • ora-12061 : invalid ALTER MATERIALIZED VIEW option
  • ora-00082 : memory size of string is not in valid set of [1], [2], [4]stringstringstringstringstring
  • ora-09931 : Unable to open ORACLE password file for reading
  • ora-01289 : cannot add duplicate logfile string
  • ora-32134 : Cannot assign LOBs
  • ora-10585 : Test recovery can not apply redo that may modify control file
  • ora-12856 : cannot run parallel query on a loopback connection
  • ora-02049 : timeout: distributed transaction waiting for lock
  • ora-30743 : "string" is not an object view
  • ora-09933 : Deletion of old password file failed.
  • ora-39767 : finish is not allowed when unloaded stream data exists
  • ora-24397 : error occured while trying to free connections
  • ora-26001 : Index string specified in SORTED INDEXES does not exist on table string
  • ora-21611 : key length [string] is invalid
  • ora-16125 : large transaction string string string is waiting for more data
  • ora-30737 : cannot create subtable of a type which is not a subtype of the type of the supertable
  • ora-26017 : global indexes not allowed for direct path load of table partition string
  • ora-24346 : cannot execute without binding variables
  • ora-06531 : Reference to uninitialized collection
  • ora-07635 : smsdbp: $SETPRT failure
  • ora-08206 : ora_addr: cannot translate address file name
  • ora-13388 : invalid value for dst_spec parameter
  • ora-00133 : value of string is too long
  • ora-31661 : there are no metadata transform values of type VARCHAR2
  • ora-06018 : NETASY: message send failure
  • ora-39088 : file name cannot contain a path specification
  • ora-36628 : (XSAGMODLIST03) MODEL workspace object could not be added to AGGMAP workspace object.
  • 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.