Re: weird 11.2.0.4 db link issue

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Thu, 18 Jun 2015 17:36:11 +0100
Message-ID: <CABe10saxGup++pdckmN65TY7BBvvsWSapUCy1efE74n+C=vhYA_at_mail.gmail.com>

And despite the title Bug 17890099 looks like it might be pertinent. Found from a MOS query on ORA-02072. That one looks like it isn't available for your platform yet though, which would suggest an SR to firstly confirm the issue and secondly request a backport as appropriate.

On Thu, Jun 18, 2015 at 4:43 PM, MacGregor, Ian A. <ian_at_slac.stanford.edu> wrote:

> There is an issue with 11.2.0.4 when a single statement employs two
> database links and not all the participating databases are at 11.2.0.4.
> For instance on database A
>
> issue; delete from table_at_databaseB where <column_name> in (select
> column_name from table_at_databaseC);
>
> The problem occurs if B is at 11.2.0.4 and C is not or vice versa.
> See the matrix for base bug 5702977. On of the child bugs may match your
> situation. We hit bug 18329037.
> There is a patch for that bug, and Oracle has been very good at updating
> that patch after every quarterly Critical Patch Update so that it does not
> produce conflict. However, who knows if they will continue to do so as
> everything below 11.2.0.4 goes off support?
>
> Your best bet is probably rewriting the statement to avoid the use of
> two db links.
>
>
>
>
>
>
>
>
>
> On Jun 17, 2015, at 12:16 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.
>
>
> -- Patrice
> My profiles: [image: Facebook]
> <http://www.facebook.com/home.php?#!/profile.php?id=100000206805521>[image:
> LinkedIn] <http://ca.linkedin.com/pub/patrice-boivin/a/933/5a9>[image:
> Twitter] <http://www.twitter.com/PatriceBoivin>
> <http://www.twitter.com/PatriceBoivin>
> Signature powered by WiseStamp <http://www.wisestamp.com/email-install>
>
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jun 18 2015 - 18:36:11 CEST