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@xxxxxxxxx
To: patrice.boivin@xxxxxxxxx
CC: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxx> 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
