Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

Rasul Allah (sal Allahu alaihi wa sallam) said: "Restore the trusts of those who trust you, and deal not falsely with him who deals falsely with you." [Abu Dawud, Tirmidhi]

Search This Blog

Wednesday, September 14, 2011

ORA-02020: too many database links in use

Got the below error:

ORA-02020: too many database links in use at

In the OBIEE query testing.

State: HY000. Code: 0. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 17001] Oracle Error code: 2020, message: ORA-02020: too many database links in use at OCI call OCIStmtFetch. [nQSError: 17012] Bulk fetch failed.

Solution:
By default you will have only 4 links open and if your query is using more than 4 db links then you might get the above error.


Increase the open_links and open_links_instance parameter in the DB to appropriate level.
and bounce the db & app servers.

if the above parameter is set to appropriate values then consider closing the open db links using

SQL>alter session close database link "link name";


No comments: