ORA-02020 too many database links in use means that the database limits the number of open database links on every session. You can increase the parameter for later use. For example, after opening 9 db links, we failed to open the 10th db link.
How to fix ORA-02020 too many database links in use.
To fix the issue here we are reproducing the issue and fixing it according to eliminate the issue.
Reproduce issue: –
SQL> select sysdate from dual@dblink10; select sysdate from dual@dblink10 * ERROR at line 1: ORA-02020: too many database links in use
SQL> show parameter open_links NAME TYPE VALUE open_links integer 9 open_links_per_instance integer 9
Here we are increasing the parameter to fix the error ORA-02020 too many database links in use.
SQL> alter system set open_links=20 scope=spfile sid='*'; System altered. SQL> alter system set open_links_per_instance=20 scope=spfile sid='*'; System altered.
After set parameter bounce the database, we can be able to access without any error.
SQL> shutdown immediate;
You may check out another post for ORA error click here ORA Error ! Oracle database symptoms (ORA Error) .