-
Hi guys!
I don't understand how to avoid that error. Could you help me please. Of course I can read 'Action' but I have no idea what to do exactly.
Thank you
-----------------------------
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.
-
Make changes to these parameters in your init.ora file. BTW what is your oracle version? Always include the version of ORACLE AND THE OS
MAX_TRANSACTION_BRANCHES = 32
open_links = 100
distributed_transactions= 100
These changes require a bounce on the instance.
Sam
-
Sorry,
Oracle 8.17, RedHat 6.2
Thank you
-
As I can see this parameter MAX_TRANSACTION_BRANCHES initialization parameter has been made obsolete,
so I have to use this one
_MAX_TRANSACTION_BRANCHES = 32
Thank you
-
MAX_TRANSACTION_BRANCHES = 32
is obsolete if the oracle is 8.1.6 or higher