Oracle Error ORA-02080: database link is in use

Oracle Error Message

ORA-02080: database link is in use

Reason for the Error

a transaction is active or a cursor is open on the database link given in the alter session close database link command.

Solution

commit or rollback, and close all cursors