ORA-02020: too many database links in use
Solution:-
[oracle@our12-test admin]$ sqlplus "/as sysdba"SQL*Plus: Release 11.1.0.7.0 - Production on Tue Feb 8 12:31:05 2011
Copyright (c) 1982, 2008, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> show parameter open_links;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
open_links integer 4
SQL>
Solution:-
Stop your Database then edit init<$ORACLE_SID>.ora
add below line *.open_links=10 then start your database
SQL> show parameter open_links;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
open_links integer 10
SQL>
No comments:
Post a Comment