Re: Anyone tried connecting to 10.1 DB from 11.2 client?
Date: Wed, 13 Jul 2011 11:18:54 -0700
Message-ID: <CAB9NSfPbiUgxR-9PL=QT86s+DubXmOT+B6=gLeaW=V64190tvg_at_mail.gmail.com>
At a client site, I have an 11.2.0.1 client on 64-bit Windows where SQL*Plus gets called from shell scripts running in Cygwin and the client connects to both 10.2 and 10.1 databases on Unix. I've noticed infrequent wrong query results get returned. It appears to be related to load on the database servers and I've found related bugs on Metalink, but I've not been able to get to the bottom of it (client is on the other side of the world and I do not have access to Production). In their SIT and UAT environments where I do have access, the database connections occasionally hang. Sorry that I don't have better information than that. I've had to move onto other things. Just be watchful. In my situation, I had to add a verification step to the scripts, ie, running the same queries a second time to get verification counts and then instructing the operator on re-running the scripts in the event of incorrect results. This added an hour to a 6-hour process.
Regards,
Mark Strickland
Seattle, WA
On Wed, Jul 13, 2011 at 8:39 AM, Jorgensen, Finn < Finn.Jorgensen_at_constellation.com> wrote:
> I believe the general rule of thumb for Oracle is that they don't support
> more than 2 version jumps in client to RDBMS connectivity. I would have
> expected any 10->11 would have been supported whereas 9->11 would not, but
> maybe 10.1 to 11.2 constitutes more than 2 versions in current Oracle
> terminology?
>
> Anyway, a simple test shows that the connectivity works. YMMV and you may
> run into issues if you do something sophisticated.
>
>
> > sqlplus oem_at_finshdw
>
> SQL*Plus: Release 11.2.0.2.0 Production on Wed Jul 13 11:34:37 2011
>
> Copyright (c) 1982, 2010, Oracle. All rights reserved.
>
> Enter password:
>
> Connected to:
> Oracle Database 10g Enterprise Edition Release 10.1.0.5.0 - 64bit
> Production
> With the Partitioning, OLAP and Data Mining options
>
> FINSHDW> select banner from v$version;
>
> BANNER
> ----------------------------------------------------------------
> Oracle Database 10g Enterprise Edition Release 10.1.0.5.0 - 64bi
> PL/SQL Release 10.1.0.5.0 - Production
> CORE 10.1.0.5.0 Production
> TNS for Solaris: Version 10.1.0.5.0 - Production
> NLSRTL Version 10.1.0.5.0 - Production
>
> FINSHDW>
>
> Thanks,
> Finn
>
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Rich Jesse
> Sent: Monday, July 11, 2011 10:44 AM
> To: Oracle L
> Subject: Anyone tried connecting to 10.1 DB from 11.2 client?
>
> Howdy,
>
> In the throws of a DB upgrade from 10.1.0.5 to 11.2.0.2, I see MOS 207303.1
> and 1065024.1 say that an 11.2 client is not supported for connecting to a
> 10.1 DB.
>
> While I won't need that for our production upgrade, it would be MUCH easier
> for our test upgrade. Our dev ERP has its own 10.1 DB, but also requires
> access to the central repository in the prod DB (those responsible for this
> setup are no longer here!). So when I upgrade our dev DB to 11.2, the ERP
> system will still need access to 10.1 prod DB, and a client upgrade to 11.2
> will supposedly break that.
>
> Has anyone tried an 11.2 client against a 10.1 DB? I'm curious as to the
> reasons why it's not supported.
>
> TIA!
> Rich
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
> >>> This e-mail and any attachments are confidential, may contain legal,
> professional or other privileged information, and are intended solely for
> the
> addressee. If you are not the intended recipient, do not use the
> information
> in this e-mail in any way, delete this e-mail and notify the sender.
> CEG-IP2
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jul 13 2011 - 13:18:54 CDT