Atomikos Forum

All feedback will be investigated, but priority support, confidential support, and product priority updates are reserved for customers. Interested in becoming a customer? Subscribe here...

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
dinsdag 28 april 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
dinsdag 28 april 2009
 
 
Hi,

Thanks for reporting this back! I added this to the known problems page in the wiki...
Guy Pardon Send private email
maandag 4 mei 2009
 
 

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

Other recent topics Other recent topics
 
Powered by FogBugz