Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

ORA-02020: too many database links in use

SOLVED
Go to solution
Petr Simik_1
Valued Contributor

ORA-02020: too many database links in use

Hello my simple SQL fails on
select * from status.subscount@dbsm7

ORA-02020: too many database links in use

When I do the same for another servers dbsm1 - dbsm6 than it works.
Can you help me please?
3 REPLIES
Steve Steel
Honored Contributor
Solution

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

Hi

Oracle has a neat tool oerr

oerr ora 2020
02020, 00000, "too many database links in use"
// *Cause: The current session has exceeded the INIT.ORA open_links maximum.
// *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.


Thus change open_links and restart the DB


Steve Steel
If you want truly to understand something, try to change it. (Kurt Lewin)
Hein van den Heuvel
Honored Contributor

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

Looks like you simply exceeded the default maximum links which I think is 4.
See below.
Regards,
Hein.

oerr ora 2020
02020, 00000, "too many database links in use"
// *Cause: The current session has exceeded the INIT.ORA open_links maximum.
// *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> show parameter links
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
open_links integer 4
open_links_per_instance integer 4

Petr Simik_1
Valued Contributor

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

Hi steeve,
I did oerr ora 02020

// *Cause: The current session has exceeded the INIT.ORA open_links maximum.
// *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.

But I thougt that problem is comming from remote DB.
I did commit on local DB and than it works.
I am so stupid ;-).