×

Loading...
Ad by
Ad by

@PEI

请是DBA的DX们注意，或有相关经验的DX也行。：）现在有一个问题请教，碰到ORA-02045 ERROR： too many local sessions participating in global transaction。怎么办？

with2001(with2001)
现在的情况是这样的，一台数据库服务器和其他11台数据库服务器用DATABASE LINK的方式连接，然后执行一些UPDATE，INSERT等命令，然后就出了前面提示的信息，不知道这个问题该如何解决，我加大了SESSIONS，加大了OPEN——LINKS，好象都没用。希望大家帮帮我。
以下说的太简单，而且11个 DATABASE LINK也不可能变成一个LINK，所以也不太明白。：（
ORA-02045 too many local sessions participating in global transaction

Cause: There are too many sessions at this site to accommodate this transaction.

Action: Use an existing database link so that another session need not be created at the remote site.
(#546646@0)
Last Updated: 2002-5-29
This post has been archived. It cannot be replied.
Report

Replies, comments and Discussions:

  • 枫下家园 / 电脑用户 / 请是DBA的DX们注意，或有相关经验的DX也行。：）现在有一个问题请教，碰到ORA-02045 ERROR： too many local sessions participating in global transaction。怎么办？ -with2001(with2001); 2002-5-29 {581} (#546646@0)
    现在的情况是这样的，一台数据库服务器和其他11台数据库服务器用DATABASE LINK的方式连接，然后执行一些UPDATE，INSERT等命令，然后就出了前面提示的信息，不知道这个问题该如何解决，我加大了SESSIONS，加大了OPEN——LINKS，好象都没用。希望大家帮帮我。
    以下说的太简单，而且11个 DATABASE LINK也不可能变成一个LINK，所以也不太明白。：（
    ORA-02045 too many local sessions participating in global transaction

    Cause: There are too many sessions at this site to accommodate this transaction.

    Action: Use an existing database link so that another session need not be created at the remote site.
    • You may want to list your runing Environment as a hint. -dundas888(敦达寺); 2002-5-29 (#546662@0)
      • oracle 8.16 -with2001(with2001); 2002-5-29 (#546703@0)
    • come on in -mickeymouse(Part Time DBA); 2002-5-29 {77} (#546696@0)
      MAX_TRANSACTION_BRANCHES= 32
      open_links = 100
      distributed_transactions= 100
      • 多谢！，我明天去试试。我怎么在ORACLE 8.1.6的REFERENCE里没找到MAX_TRANSACTION_BRANCHES这个初始化参数啊？ -with2001(with2001); 2002-5-29 (#546710@0)
        • this parameter is a "obsolete parameter" in 8.1.*, you need to use _MAX_TRANSACTION_BRANCHES instead. -mickeymouse(Part Time DBA); 2002-5-29 (#546724@0)
      • 牛, 你怎么知道应该改这几个参数的? -canewman(newman); 2002-5-29 (#546930@0)
        • read this article -alanwang99(Baby); 2002-5-29 {2572} (#546967@0)
          本文发表在 rolia.net 枫下论坛Thread Status: Closed

          From: Lawson Sharon 02-Nov-99 15:07
          Subject: ORA-02045 Too many local sessions in global transaction

          RDBMS Version:: 8.0.5
          Operating System and Version:: mS windows nT 4.0 sp4
          Error Number (if applicable):: ora-02045
          Server Net Version:: sql net 2.3.4
          Client Operating System and Version:: ms windows nt 4.0
          Client Net Version:: net 80

          ORA-02045 Too many local sessions in global transaction

          I am getting a ora-02045 error . Too many sessions participating in global transaction error when
          using dblinks ( I am using about 6 dblinks in one sql statement). Is there any parameter on the
          server or client side which controls this parameter. please advice

          Thanks

          Sharath Adengada
          s.adengada@worldnet.att.net





          --------------------------------------------------------------------------------

          From: Oracle, Rhoderick Butial 02-Nov-99 15:57
          Subject: Re : ORA-02045 Too many local sessions in global transaction


          Hello,

          Error: ORA 2045
          Text: too many local sessions participating in global transactions
          Cause: There are too many sessions at this site to accommodate this
          transaction.
          Action: Use an existing database link so that another session need not be created at the remote site.

          Set the related parameters in the init.ora (client):

          MAX_TRANSACTION_BRANCHES= 32
          open_links = 100
          distributed_transactions= 100

          Try this out and reply back with your progress.


          Thank you,

          Rod
          Oracle Technical Support




          --------------------------------------------------------------------------------

          From: Lawson Sharon 02-Nov-99 17:35
          Subject: Re : Re : ORA-02045 Too many local sessions in global transaction


          Thanks!! It worked . Is there any load on the server by increasing the max_transaction_branches and the open_links.





          --------------------------------------------------------------------------------

          From: Oracle, Rhoderick Butial 04-Nov-99 14:53
          Subject: Re : Re : Re : ORA-02045 Too many local sessions in global transaction


          Hello,

          Whenever you allow the number of concurrent transaction branches or open links, your available resources dwindles causing your system to be less efficient.

          Thank you,

          Rod
          Oracle Technical Support



          --------------------------------------------------------------------------------



          --------------------------------------------------------------------------------

          Copyright (c) 1995,2000 Oracle Corporation. All Rights Reserved. Legal Notices and Terms of Use.更多精彩文章及讨论，请光临枫下论坛 rolia.net

More Topics

  • 以前在College 买的MS office 已经过期了,用不了。LibreOffice 能用吗？可以编辑以前的 MS Word 不？
  • 想在Android的手机里装上这些正规的字体，比方说,Times New Roman，Courier New。怎么装法？ Google Playstore里面的Font App尽是那些乌烟瘴气，花哩唿哨的comic字体，一味迎合年轻人和teenager口味，很讨厌。
  • 发现了ESIM Pay as you go plan: 充值即用，说是不会过期，不收手续费。有兴趣的可以看看，总结一下经验让大家一起分享。
  • Qualcomm wants to buy Intel
  • 乍一看还以为苹果出折叠手机了。
    • 枫下论坛主坛 /  枫下家园 /  电脑用户