Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Database > Oracle
|
Oracle General Oracle database discussions.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Oracle section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old April 10th, 2005, 08:57 PM
Registered User
 
Join Date: Apr 2005
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default ORA-24777 : "use of non-migratable database link n

I have 4 Oracle Databases named DB1, DB2, DB3, DB4.
I configured DB1, DB2 as Master Sites to synchronously replicate row data in one table from DB1 to DB2 and they worked.
I used COM+ services to coordinate a transaction between DB3 & DB4 and it also worked.
Moreover, I redirected to coordinate this transaction between DB3 & DB1,
then I got the ORA-24777 : "use of non-migratable database link not allowed".

Detail configuration:
DB1:
+Microsoft Windows Server 2003. Enterprise Edition.
+Oracle 9.2.0.1.0, Multimaster Replication, Shared Server mode
+

DB2:
+Microsoft Windows Server 2003. Enterprise Edition.
+Oracle 9.2.0.1.0, Multimaster Replication, Shared Server mode

DB3:
+Microsoft Windows Server 2003. Enterprise Edition + security update patches
+Oracle 9.2.0.1.0, Shared Server mode

DB4:
+Microsoft Windows Server 2003. Enterprise Edition + security update patches
+Oracle 9.2.0.1.0.

I used Oracle Data Provider for .NET Developer's 9.2.0.4, VC++. NET 2003, .Net Framework 1.1

Please help me as soon as possible. Thank you very much.


 
Old May 2nd, 2005, 03:47 AM
Authorized User
 
Join Date: Dec 2004
Posts: 19
Thanks: 0
Thanked 0 Times in 0 Posts
Default

check thiss,
http://asktom.oracle.com/pls/ask/f?p...:5414746274062

Sujit Ku. Mahapatra





Similar Threads
Thread Thread Starter Forum Replies Last Post
[Oracle][ODBC][Ora][ORA-01013 Corey Access 1 December 15th, 2006 10:29 AM
Database link in excell paul20091968 Excel VBA 7 November 17th, 2006 08:02 AM
ORA-24777 : "use of non-migratable database link n lethuvpsc Oracle ASP 0 April 10th, 2005 08:55 PM
How to Active a Database-Link zhangmin Oracle 0 October 20th, 2004 07:41 PM
Link to database jlnashrod Oracle 3 April 22nd, 2004 12:48 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.