Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


ORA-02020: too many database links in use

Answers were Sorted based on User's Feedback



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

Answer / bala

This is a simple error, this can be resolved by adding
open_links parameter value with specified number of links
you want for the database.

open_links=25 for example

this parameter needs the database bounce

Is This Answer Correct ?    15 Yes 2 No

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

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    11 Yes 2 No

Post New Answer

More Oracle Errors Interview Questions

ORA-01720: grant option does not exist for 'string.string'

1 Answers  


ORA-30941: Cannot specify empty URI for non-default namespace 'string'

1 Answers  


ORA-00706: error changing format of file 'string'

1 Answers  


ORA-19036: Invalid query result set in newContextFromHierarchy()

1 Answers  


ORA-36182: (XSAGGR09) Could not locate a value for variable number in measure dimension workspace object.

1 Answers  






TNS-04021: The SET command is unsuccessful for parameter string.

1 Answers  


ORA-16724: the intended state for the database has been set to OFFLINE

1 Answers  


ORA-36644: (XSDUNION07) Concat dimension workspace object contains a previously detected leaf dimension.

1 Answers  


NNF-00001: Not a TNS address

1 Answers  


PCC-02393: SQL statement found inside an EXEC SQL DECLARE SECTION

1 Answers  


ORA-24317: define handle used in a different position

1 Answers  


ORA-13434: GeoRaster metadata cellRepresentation error

1 Answers  






Categories