Oracle's daily practice of too many Oracle Dblink connections (Ora-02020)

This article has been redirected from an excessive number of Oracle Dblink connections (Ora-02020)

Today, when dealing with data synchronization issues, it is necessary to synchronize data from several other DB servers to a single target repository, in the following way: Dblink+job, however, Ora-02020 errors occur during the write process compilation. As follows:

Environment: Target server (alias: DB)

Other servers that need to be synchronized (DB1, DB2, DB3, DB4, DB5)

Practice: Establish the DB Link for each server, and then synchronize the relevant data during the process. such as code:

1 Create or replace procedure MBOMDATAIMPORTTW is
2 begin
3
4 DB1 DBLink Treatment
5 DB2 DBLink Treatment
6 DB3 DBLink Treatment
7 DB4 DBLink Treatment
8 DB5 DBLink Treatment
9
Ten end MBOMDATAIMPORTTW;

A Ora-02020 error occurred while processing DB5 Dblink, too many connections.

Analysis: The above can be initially attributed to Oracle the default number of connections is 4. So there was an error when the fifth connection was processed.

To view system parameters:

1 sql> show parameter open_links;
2
3 NAME TYPE VALUE
4-----------------------------------------------------------------------------
5 Open_links Integer 4
6 Open_links_per_instance Integer 4
7
8 sql>

Workaround: Modify the number of connections

1 sql> alter system set OPEN_LINKS=6 Scope=spfile;

Oracle's daily practice of too many Oracle Dblink connections (Ora-02020)