ORA 2020 too many database links in use

Scope: While selecting data with DBLink (Database Link) produces error ORA-02020 instead providing output from source database.

Example:

SQL> select sysdate from dual@neerprd;

This select statement produces error ORA-02020 instead of providing sysdate. ORA-02020: too many database links in use

Cause: The maximum number of active connections to remote databases per user login has been reached.

Solution: Modify the initialization parameters : OPEN_LINKS and OPEN_LINKS_PER_INSTANCE

SQL> alter system set open_links_per_instance=200 scope=spfile sid=’*'; System altered.

SQL> alter system set open_links=100 scope=spfile sid=’*'; System altered.

Pages