Atomikos Community Forum

Not for product support. If you need urgent help with your project then buy development or production support or check the known problems...

Only registered users can post (registration is free). Problems registering? Send an email to support@atomikos.com to get help.


ORA-24777 Error when using DB LINK

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.
Med DAB Send private email
Tuesday, April 28, 2009
 
 
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
Med DAB Send private email
Tuesday, April 28, 2009
 
 
Hi,

Thanks for reporting this back! I added this to the known problems page in the wiki...
Guy Pardon Send private email
Monday, May 04, 2009
 
 

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics
 
Powered by FogBugz