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 : 23-07-2017

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

  • ora-01544 : cannot drop system rollback segment
  • ora-40003 : wordsize must be in the range string - string for BLAST-P
  • ora-36961 : Oracle OLAP is not available.
  • ora-09716 : kslcll: Unable to fix in-flux lamport latch.
  • ora-24100 : error in ktz testing layer
  • ora-31650 : timeout waiting for master process response
  • ora-36652 : (XSDUNION11) workspace object is not a string type dimension.
  • ora-28511 : lost RPC connection to heterogeneous remote agent using SID=string
  • ora-02189 : ON required
  • ora-38717 : Invalid DUMP FLASHBACK option.
  • ora-16543 : invalid request made to broker
  • ora-28580 : recursive external procedures are not supported
  • ora-16740 : redo transport service for standby database "string" incorrectly set to ALTERNATE
  • ora-27016 : skgfcls: sbtinfo returned error
  • ora-24077 : cannot create propagation schedule for EXCEPTION queue string.string
  • ora-09940 : ORACLE password file header is corrupt
  • ora-16103 : Logical Standby apply must be stopped to allow this operation
  • ora-17503 : ksfdopn:string Failed to open file string
  • ora-00032 : invalid session migration password
  • ora-32623 : incorrect use of MODEL PRESENT* functions
  • ora-16129 : unsupported dml encountered
  • ora-02365 : error seeking in file: string
  • ora-28137 : Invalid FGA audit Handler
  • ora-19123 : fn:zero-or-one() called with a sequence containing more than one item
  • ora-14269 : cannot exchange partition other than a Range or Hash partition
  • ora-07446 : sdnfy: bad value 'string' for parameter string.
  • ora-08106 : cannot create journal table string.string
  • ora-38956 : Target platform string not cross platform compliant
  • ora-16205 : DDL skipped due to skip setting
  • ora-00211 : control file does not match previous control files
  • 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.