| 订阅 | 在线投稿
分享
 
 
 

ORA-02020错误:过多的数据库连接使用中问题

来源:互联网  宽屏版  评论
2008-08-06 07:16:27

错误现象:

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;

重启下数据库就好了!

错误现象: 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; 重启下数据库就好了!
󰈣󰈤
 
 
 
>>返回首页<<
 
 热帖排行
 
 
 
静静地坐在废墟上,四周的荒凉一望无际,忽然觉得,凄凉也很美
©2005- 王朝网络 版权所有