Does anyone have experience with database links between 10g and 11g?
Is this a supported setup/operation? Is it possible? Are there any problems? Caveats?
+4
A:
I've been using DB Links from 11g to 10g. No big issues.
Only caveat is that 11g can use mixed-case passwords and you might want to switch that off if you are trying to connect from a 10g database to an 11g one.
Gary
2010-03-19 01:13:27
Thanks. Did you consider using just uppercase passwords for connecting from 10g to 11g to still allow mix-case passwords?
JavaRocky
2010-03-19 02:49:39
+1
A:
Sometimes there are problems, when a link from 11G to 10.2.0.4.
Oracle Support Doc ID 730423.1: Select With Local Function and Remote Tables Using a Dblink Hangs Due To Enq DX.
dba.in.ua
2010-03-20 20:48:46
Thanks. Heres some refs for all. http://www.ora600.be/node/1955 http://surachartopun.com/2008/12/dbink-hangs-enq-dx-contention.html
JavaRocky
2010-03-21 22:26:37