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";