many local sessions

[kgb]

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.

[sambavan]

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

[kgb]

Sorry,
Oracle 8.17, RedHat 6.2
Thank you

[kgb]

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

[sonofsita]

MAX_TRANSACTION_BRANCHES = 32
is obsolete if the oracle is 8.1.6 or higher