| 導購 | 订阅 | 在线投稿
分享
 
 
 

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- 王朝網路 版權所有