ORA-02020错误:过多的数据库连接使用中问题
来源:网络 责任编辑:栏目编辑 发表时间:2013-07-01 05:11 点击:次
错误现象:
ORA-02020: too many database links in use
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.
再查看参数:
SQL> show parameter open_links;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
open_links integer 10
open_links_per_instance integer 4
Oracle默认是4:
SQL> alter system set open_links=10 scope=spfile;
重启下数据库就好了!
相关新闻>>
最新推荐更多>>>
- 发表评论
-
- 最新评论 更多>>