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)