RE: Anyone tried connecting to 10.1 DB from 11.2 client?

  • From: "Jorgensen, Finn" <Finn.Jorgensen@xxxxxxxxxxxxxxxxx>
  • To: "'rjoralist2@xxxxxxxxxxxxxxxxxxxxx'" <rjoralist2@xxxxxxxxxxxxxxxxxxxxx>, 'Oracle L' <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 13 Jul 2011 11:39:15 -0400

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@finshdw

SQL*Plus: Release 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 - 64bit Production
With the Partitioning, OLAP and Data Mining options

FINSHDW> select banner from v$version;

Oracle Database 10g Enterprise Edition Release - 64bi
PL/SQL Release - Production
CORE      Production
TNS for Solaris: Version - Production
NLSRTL Version - Production



-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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?


In the throws of a DB upgrade from to, 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.



>>> 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


Other related posts: