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-01871: the number of seconds must be less than 60

1 Answers  


RMAN-06499: skipping archive log file string; already backed up string time(s)

1 Answers  


ORA-16514: the request was not found

1 Answers  


ORA-07574: szrfc: $GETUAI failure

1 Answers  


NCR-02005: NCRF: Invalid session mode

1 Answers  






RMAN-08121: keep attributes for the backup are deleted

1 Answers  


ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized view

1 Answers  


ORA-36882: (XSSRF01) The second parameter of an AW single row function cannot be NULL.

1 Answers  


RMAN-08158: executing script: string

1 Answers  


PLS-00333: "string" must match an object-table alias in this context

1 Answers  


ORA-14318: DEFAULT partition must be last partition specified

1 Answers  


ORA-16091: dependent archive log destination already archived

1 Answers  


Categories