ORA-02020: too many database links in use

Error :

ORA-02020: too many database links in use


Solution :

Increase the open_links and open_links_instance parameter in the DB . Bounce Database

SQL> alter system set open_links =20 scope =spfile;

System altered.

SQL> alter system set open_links_per_instance=20 scope=spfile;

System altered.



Or

SQL>alter session close database link "link name";