ORA-02020: too many database links in use
- 2 Answers
- 15365 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 |
PLS-00536: Navigation through REF variables is not supported in PL/SQL.
RMAN-06705: text script line is too long (>1024)
ORA-16103: Logical Standby apply must be stopped to allow this operation
ORA-24037: schema string in QUEUE_NAME is not same as schema string in QUEUE_TABLE
ORA-19331: Last argument to CREATE_DBURI operator must be a column
ORA-29374: resource plan string in top-plan string has no plan directives
ORA-28550: pass-through SQL: cursor not found
ORA-12812: only one PARALLEL or NOPARALLEL clause may be specified
NZE-28780: invalid data access method specified by the parameter
NZE-28823: Number of random bytes to generate is not specified.
EXP-00097: Object type "string"."string" is not in a valid state, type will not be exported
ORA-15132: block string of file string in diskgroup string could not be written
Oracle Errors 
