How to fix the Oracle error ORA-01082: ‘row_locking = always’ requires the transaction processing option?

In this post, you’ll learn more about the Oracle ErrorORA-01082: ‘row_locking = always’ requires the transaction processing option with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-01082: ‘row_locking = always’ requires the transaction processing option

Reason for the Error ORA-01082: ‘row_locking = always’ requires the transaction processing option

“row_locking = always” is specified in INIT.ORA file. This feature is not supported by ORACLE without the transaction processing option.

How to fix the Error ORA-01082: ‘row_locking = always’ requires the transaction processing option ?

You can fix this error in Oracle by following the below steps

Remove it from INIT.ORA file or set it to “default” or “intent”.