Databases
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 ;-).