首页 > 数据库技术 > 详细

ORA-02020 too many database links in use

时间:2015-05-15 09:02:46      阅读:283      评论:0      收藏:0      [点我收藏+]
   在A库上建DB_link,更新B库。报ORA-2020 too many database links in use,是要设置OPEN_LINKS和OPEN_LINKS_PER_INSTANCE两个参数,它们的默认值都是4。
alter system set open_links=200 scope=both;
alter system set open_links_per_instance=200 scope=both;
问题来了,是修改A库中的参数还是B库,是修改A库的。
修改这类参数数据库要重启。

Error:  ora-02020 
Text:   too many database links in use 
-------------------------------------------------------------------------------
Cause:  The maximum number of active connections to remote databases per user 
        login has been reached.
Action: If the user has no open cursors, the current SQL statement accesses 
        more than the maximum allowed remote databases.
        Otherwise, the user may free remote database connections by closing 
        all cursors that access the databases.
        If this occurs often, consider increasing the value of the 
        initialization parameter OPEN_LINKS, which controls the maximum number 
        of concurrent open connections to remote databases per user process.
        
OPEN_LINKS specifies the maximum number of concurrent open connections to remote databases in one session.
OPEN_LINKS_PER_INSTANCE specifies the maximum number of migratable open connections globally for each database instance.

ORA-02020 too many database links in use

原文:http://blog.csdn.net/stevendbaguo/article/details/45739931

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!