ORA-02080: database link is in use

Mehmet Salih Deveci

5 years ago

Hi,

You can get ” ORA-02080: database link is in use ” error during the drop any user.

Details of error are as follows.

ORA-02080: database link is in use

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

Action: commit or rollback, and close all cursors

Check the existing Database links as follows.

SQL>  select db_link,logged_on,open_cursors from v$dblink;

To solve this error, You should increase the open_links parameter as follows.

alter system set open_links=20 scope=spfile sid='*';
alter system set open_links_per_instance=20 scope=spfile sid='*';


Then restart database to activate this parameter as follows.
 
shutdown immediate;
startup

If you don’t want to increase open_links because of restart database, then you can close the existing database links as follows.

SQL> exec DBMS_SESSION.CLOSE_DATABASE_LINK (Database_Link_Name);

SQL> alter session close database link Database_Link_Name;

Do you want to learn Oracle Database for Beginners, then read the following articles.

https://ittutorial.org/oracle-database-19c-tutorials-for-beginners/