ORA-02020 too many database links in use

by

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.

Fixing 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.

ORA-02020 too many database links in use

Reproduce issue ORA-02020.

SQL> select sysdate from dual@dblink10;
select sysdate from dual@dblink10
*
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

Solution:-

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;

SQL> startup;

You may check out another post for ORA error click here ORA Error ! Oracle database symptoms (ORA Error).

Leave a Comment