ORA-02020: too many database links in use

[Petr Simik_1]

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?

[Steve Steel · Accepted solution]

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

[Hein van den Heuvel]

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]

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