Atomikos Forum

Hello,


I'm using Atomikos XA transaction with oracle 10 g database. I get the "ORA-24777: use of non-migratable database link not allowed" error when a select statement is executed on another db from a stored procedure. I can't remove all the statements, we have a lot of queries retrieving data from remote databases.

I haven't this problem when I'm using a simple datasource.

The solution that I found is to install the oracle MTS. I read a article describing impacts and when to use MTS
http://www.dba-oracle.com/t_mts_multithreaded_servers_shared.htm

Is installing MTS the only issu? Can we configure xadatasource to solve this problem?

Please I need Help.

I believe that enabling MTS in oracle is the only issue to solve the "ORA-24777: use of non-migratable database link not allowed" error when we deal with db links.

I found the response to my question in the oracle XA documentation http://download-east.oracle.com/docs/cd/B13789_01/appdev.101/b10795/adfns_xa.htm#1007057

Hi,

Thanks for reporting this back! I added this to the known problems page in the wiki...