Good Day,
Can you post the output from SHOW PARAMETER global
Best Regards,
Mc
Saludos Cordiales,
Marcos Colmenares H
--
2015-06-17 16:05 GMT-04:30 Iggy Fernandez <iggy_fernandez@xxxxxxxxxxx>:
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.
-- Patrice
My profiles: [image: Facebook]
<http://www.facebook.com/home.php?#%21/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>