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 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@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?
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
--
//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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
