How to fix the Oracle error ORA-02159: installed DLM does not support releasable locking mode?

In this post, you’ll learn more about the Oracle ErrorORA-02159: installed DLM does not support releasable locking mode with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-02159: installed DLM does not support releasable locking mode

Reason for the Error ORA-02159: installed DLM does not support releasable locking mode

The parameter file specified gc_* parameters that allow locks to be release by the LCK process when not in use. This mode requires additional support from the DLM that is not available.

How to fix the Error ORA-02159: installed DLM does not support releasable locking mode ?

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

Specify configuration parameters that do not require the additional function.