数据库中默认可打开的数量为4,当超过4个的时候就会报ORA-02020的错误。跟dblink相关的参数有2个,设置完后重启数据库即生效。
SQL> select * from dual@toqycbs;
select * from dual@toqycbs
*
ERROR at line 1:
ORA-02020: too many database links in use
SQL> col name for a50
SQL> col value for a50
SQL> select name,value from v$parameter where name like '%link%';
NAME VALUE
-------------------------------------------------- --------------------------------------------------
open_links 4
open_links_per_instance 4
Elapsed: 00:00:00.01
SQL> alter system set open_links=100 scope=spfile;
System altered.
Elapsed: 00:00:00.07
SQL> alter system set open_links_per_instance=100 scope=spfile;
System altered.
Elapsed: 00:00:00.09
SQL> col name for a50
SQL> col value for a50
SQL> select name,value from v$parameter where name like '%link%';
NAME VALUE
-------------------------------------------------- --------------------------------------------------
open_links 4
open_links_per_instance 4
SQL> startup force
ORACLE instance started.
Total System Global Area 3273641984 bytes
Fixed Size 2217792 bytes
Variable Size 2449475776 bytes
Database Buffers 805306368 bytes
Redo Buffers 16642048 bytes
Database mounted.
Database opened.
SQL> col name for a50
SQL> col value for a50
SQL> select name,value from v$parameter where name like '%link%';
NAME VALUE
-------------------------------------------------- --------------------------------------------------
open_links 100
open_links_per_instance 100
ORA-02020的处理,dblink超出数量的设置
最新推荐文章于 2024-07-24 08:45:00 发布