ORA-02020: too many database links in use - solution

One of my database is used as remote database for distributed transactions as well as master table access. For one requirement we have created 'n' number of db links. So many queries fired to use the dblink and at that time we found below error:

"ORA-02020: too many database links in use "

Cause:  The current session has exceeded the INIT.ORA open_links maximum.


How to find?
The above error will be reported if open_links parameter value is less. Default value of this parameter is 4. If frequently you are getting this error, then change the value to higher one.

e.g.,
SQL> show parameter open_links;
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------
open_links                           integer     4
open_links_per_instance              integer     4

Action: 
Increase the open_links limit, or free up some open links by committing or rolling back the transaction and canceling open cursors that reference remote databases.

SQL> alter system set open_links_per_instance=10 scope=spfile;
SQL> alter system set open_links=10 scope=spfile;

and then, bounce the database.