RE: weird 11.2.0.4 db link issue
Date: Wed, 17 Jun 2015 13:35:22 -0700
Message-ID: <BLU179-W92A714E0113E28033E655FEBA60_at_phx.gbl>
re: because there are two db links in a row, connectivity failed It sounds more plausible that connectivity broke on one of the legs; that is, the fact that that there are two db links in row may not matter. Iggy
Date: Wed, 17 Jun 2015 15:22:39 -0400
Subject: Re: weird 11.2.0.4 db link issue
From: bdbafh_at_gmail.com
To: patrice.boivin_at_gmail.com
CC: oracle-l_at_freelists.org
11.2.0.4.15 (and newer) has known issues on ms win. If one applied the 11.2.0.4.15 patch against one db and attempted to access objects in it across a database link from say a database of version 11.2.0.4.10 ... You're going to have a bad time.
Paul
On Jun 17, 2015 3:18 PM, "Patrice sur GMail" <patrice.boivin_at_gmail.com> wrote:
Hi,
I patched our databases on unix and on windows.... now one app won't work because it goes like this:
From 11.2.0.4 Unix --> db link --> 11.2.0.4.16 on win32 view + db link --> 10.1 on (something, it's another organization's site).
(no I can't tell them 10.1 is no longer supported etc., cue the funeral parlor music)
Well because there are two db links in a row, connectivity failed after the latest 11.2.0.4 PSU was applied and I upgrade the database from 11.2.0.3 to 11.2.0.4.
The latest psu was applied to 11g on win32, no change.
Any ideas? Maybe there's a patch I don't know about to fix this.
Meanwhile I suggested to the developer that he might want to use mviews instead of views in the middle, but it would be easier if we just fixed that bug.
- PatriceMy profiles: Signature powered by WiseStamp -- http://www.freelists.org/webpage/oracle-l