Oracle Database Errors or Warnings from Error ORA-24791 to ORA-24803


ORA-24791: invalid transaction start flags
Cause: An invalid transaction start flag was passed.
Action: Verify that OCI_TRANS_LOOSE was not passed along with OCI_TRANS_JOIN, OCI_TRANS_RESUME. Also, verify that other flags (such as OCI_TRANS_SEPARABLE) passed by the client are supported by the version of the Oracle server.
ORA-24792: cannot mix services in a single global transaction
Cause: Oracle RM will not serve global (distributed) transaction requests if branches are created using different services
Action: Configure clients such that those participating in the same distributed transaction use the same service name.
ORA-24794: no active DTP service found
Cause: Oracle RM will not serve global (distributed) transaction requests until DTP services are configured in RAC. It is possible that a service was stopped while transactions were in-flight.
Action: Provision/Start DTP services first.

ORA-24795: Illegal string attempt made
Cause: An illegal attempt was made to commit/rollback current transaction
Action: Use appropriate commit/rollback mechanism
ORA-24796: operation completed; resume of original transaction rolled back
Cause: The commit, rollback, or prepare completed successfully, but the current transaction for this thread was rolled back.
Action: If desired, retry the current transaction. If the operation was prepare, then end transaction appropriately with a commit or rollback operation.
ORA-24797: cannot promote the current transaction to a distributed transaction
Cause: An illegal attempt was made to promote the current transaction.
Action: Verify that OCI_ATTR_XID, OCI_ATTR_INTERNAL_NAME, and OCI_ATTR_EXTERNAL_NAME attributes have been set properly, and verify that the current transaction has neither performed IDL or PDML operations, nor already been a distributed transaction. Also, verify that the local transaction is in the same isolation level if the isolation flag value is set.

ORA-24798: cannot resume the distributed transaction branch on another instance
Cause: An attempt was made to resume a distributed transaction branch that is physically located on another RAC instance.
Action: Get a connection to the instance where the transaction branch is located.
ORA-24801: illegal parameter value in OCI lob function
Cause: One of the parameter values in the OCI lob function is illegal.
Action: Check every parameter in the OCI Lob function call to make sure they are correct. Offsets should be greater than or equal to one.
ORA-24802: user defined lob read callback error
Cause: The only valid return value for a user defined lob read callback function is OCI_CONTINUE. Any other value will cause this error.
Action: Verify that OCI_CONTINUE is returned from the user defined lob read callback function.
ORA-24803: illegal parameter value in lob read function
Cause: Internal error .
Action: This error should not normally occur. If it persists, please contact your customer service representative.

Above are list of Oracle Database Errors or Warnings from Error ORA-24791 to ORA-24803 received while performing certain operation against Oracle Database or related products.

What are Oracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database. Each Oracle Database Error or Warning Message mentioned above contains the Warning or Error Message Statement, a short explanation of the probable causes of the Error message, and a recommended action.

Hope this was helpful.

SQLServerF1 Team
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.


Leave a Reply

Your email address will not be published. Required fields are marked *