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