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 [email protected]; select sysdate from [email protected] * ERROR at line 1: ORA-02020: too many database links in use
This is because both server parameter OPEN_LINKS and OPEN_LINKS_PER_INSTANCE are too small. To eliminate the issue, we have to increase both parameters.
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) .