How to fix the error ORA-00061: another instance has a different DML_LOCKS setting?

In this post, you’ll learn more about the Oracle ErrorORA-00061: another instance has a different DML_LOCKS setting with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-00061: another instance has a different DML_LOCKS setting

Reason for the Error ORA-00061: another instance has a different DML_LOCKS setting

The shared instance being started is using DML locks, and the running instances are not, or vice-versa.

How to fix the Error ORA-00061: another instance has a different DML_LOCKS setting ?

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

Ensure that all instances’ INIT.ORA files specify the DML_LOCKS parameter as 0 or all as non-zero.