Behind the ORA-02020 Error: A Deep Dive into Database Link Troubleshooting.
This blog is intended for DBA’s who have error while using a database links.Let’s work on a journey to decode, troubleshoot, and over the challenge posed by the ORA-02020 error. Issue: Error While Fetching data against a database link, got below error.ORA-02020: Too Many Database Links In Use Sql>select sysdate from dual@Daatbase_link5; * ERROR at line 1: ORA-02020: too many database links in use CAUSE & SOLUTION: n open_links parameter control, the number of database links each session can use without closing it. n If you access a database link in a session, then the link remains open until you close the session. Check the below parameter: SQL> show parameter open_link NAME TYPE VALUE ———————————— ———– —————————— open_links integer 4 open_links_per_instance integer 4 Here open_links is set to a session can access only 4 open database links in that session.When the open db_link connection reaches the limit(open_links), it throws ORA-02020: too many database links in use. Solution:1 n Close the open db_link connections n Increase the open_links parameter (bounce required) Let’s reproduce this error. SQL> select sysdate from dual@Database_link1; SYSDATE ——— 30-JUL-17 SQL> select sysdate from dual@Database_link2; SYSDATE ——— 30-JUL-17 SQL> select sysdate from dual@Database_link3;…
Read More