ORA-02020: too many database links in use
- 2 Answers
- 15319 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
ORA-14400: inserted partition key does not map to any partition
ORA-30383: specified dimension level does not exist in the attribute
LSX-00174: "~S" is not a valid derivation of "~S"
ORA-38432: EVALUATE operator only allowed on an expression column
ORA-27470: failed to re-enable "string.string" after making requested change
ORA-22292: Cannot open a LOB in read-write mode without a transaction
ORA-19610: directory block string is corrupt
NID-00002: Parse error: string
QSM-00501: unable to initialize Summary Advisor environment
RMAN-06091: no channel allocated for maintenance (of an appropriate type)
PCC-01500: You are not authorized to run Pro*Ada
SQL*Loader-00500: Unable to open file (string)
Oracle Errors 
