Client / Server / Interoperability Support Between Different Oracle Versions
Oracle Client / Server Interoperability Support
Introduction
This note gives a summary of the support for interoperability between Oracle client and server versions. This includes support for connections over database links between Oracle versions. Note that this relates to support for investigation of defects / ability to obtain bug fixes.
Note that this is a general guide for interoperability only – certain products or utilities may impose additional restrictions on supported combinations specific to the product / utility. eg: Precompilers, Export / Import utilities etc..
For a summary of the support status of each Oracle release see Note:161818.1
General Policy
Oracle’s general policy is to test and support each new Oracle release for compatibility with older releases thus:
- Test the NEW client to each OLDER server release where the OLDER release is still covered by Premier Support (formerly Primary Error Correction support) at the time that the NEW version is released.
- Test OLDER clients to the NEW server release where the OLDER release is still covered by Premier Support (formerly Primary Error Correction support) OR is in the first two years of Extended Support (formerly Extended Maintenance support).
- Tests between the NEW version and other OLDER releases may be added where Oracle deems it sensible to support interoperability between those releases.
Current Interoperability Support Situation
The matrix below summarizes client and server combinations that are supported.
New interoperability problems will only be investigated if BOTH releases involved are covered by a valid support contract at the time that the issue is reported .
eg:
A 9.2.0 client to a 10.2.0 server issue requires the customer to have a valid Extended Support contract for the 9.2.0 client in order for Oracle to investigate it.
Server Version Client Version 11.2.0 11.1.0 10.2.0 10.1.0 9.2.0 9.0.1 8.1.7 8.1.6 8.1.5 8.0.6 8.0.5 7.3.4 11.2.0 Yes Yes ES #7 No ES #5 No #3 No #3 No #3 No #3 No #3 No #3 No #3 11.1.0 Yes Yes ES #7 ES #6 ES #5 No #3 No #3 No #3 No #3 No #3 No #3 No #3 10.2.0 ES #7 ES #7 ES ES ES #5 No Was No #3 No #3 No #3 No #3 No #3 10.1.0(#4) ES #6 ES #6 ES ES ES Was Was #2 No #3 No #3 No #3 No #3 No #3 9.2.0 ES #5 ES #5 ES #5 ES ES Was Was No No Was No No #1 9.0.1 No No No Was Was Was Was Was No Was No Was 8.1.7 No No Was Was Was Was Was Was Was Was Was Was 8.1.6 No No No No No Was Was Was Was Was Was Was 8.1.5 No No No No No No Was Was Was Was Was Was 8.0.6 No No No No Was Was Was Was Was Was Was Was 8.0.5 No No No No No No Was Was Was Was Was Was 7.3.4 No No No No Was Was Was Was Was Was Was Was Key:
Yes Supported ES Supported but fixes only possible for customers with Extended Support . Was Was a supported combination but one of the releases is no longer covered by any of Premier Support , Primary Error Correct support , Extended Support nor Extended Maintenance Support so fixes are no longer possible. No Has never been Supported
- #1 – See Note:207319.1
- #2 – An ORA-3134 error is incorrectly reported if a 10g client tries to connect to an 8.1.7.3 or lower server. See Note:3437884.8 .
- #3 – An ORA-3134 error is correctly reported when attempting to connect to this version.
- #4 – There are problems connecting from a 10g client to 8i/9i where one is EBCDIC based. See Note:3564573.8
- #5 – For connections between 10.2 (or higher) and 9.2 the 9.2 end MUST be at 9.2.0.4 or higher. Connections between 10.2 (or higher) and 9.2.0.1, 9.2.0.2 or 9.2.0.3 are not supported.
- #6 – For connections between 11.1 (or higher) and 10.1 / 10.2 the 10g end MUST be at 10.1.0.5 / 10.2.0.2 (or higher) respectively in order to use PLSQL between those versions. See Note:4511371.8 for more details.
- #7 – For connections between 11.2 (or higher) and 10.2 the 10g end MUST be at 10.2.0.2 (or higher) in order to use PLSQL between those versions. See Note:4511371.8 for more details.
General Notes:
- For database links between different Oracle versions connections must be supported in BOTH directions in the matrix above.
eg: As 11.2 -> 10.1 is not supported then database links between these version are not supported in either direction.
- Unsupported combinations may appear to work but can encounter errors for particular operations. The fact that they appear to work should not be relied upon – issues on unsupported combinations will not be investigated.
- Since new database servers are compatible with a limited set of older OCI clients, it may not be necessary to upgrade the client software when upgrading the database. However, some new features may not work without upgrading the client software. So, for example, an Oracle 10.2 client is able to connect to an 11.2 database, but is not able to take advantage of newer features such as Client Result Cache (introduced in 11.1).
- Oracle Applications , or other Oracle products, may have supported configurations not listed in the matrix above.
- The matrix above also applies between different platforms and between 32/64 bit releases of Oracle client / server except where any Oracle platform desupport notice indicates otherwise .
- Unix BEQUEATH (BEQ) connections are NOT supported between different releases. eg: Client 10.2 is not supported to make an Oracle Net connection to a 11.2 server using the BEQ protocol adapter regardless of the interoperability support listed above. See Note:364252.1 for more details.
Terminology
See the “Terminology” section of Note:161818.1 for a description of Premier Support, Extended Support, Primary Error Correction Support and Extended Maintenence Support
Related Articles
- JDBC, JDK, and Oracle Database Certification Note:401934.1
For JDBC clients information in Note:401934.1 takes priority over information in the above matrix.
- Support Status of each Oracle Server (RDBMS) Release Note:161818.1
- For Precompiler interoperability support also see:
“Pro*C/C++ Programmer’s Guide 11g Release 2 (11.2)” [Part Number E10825-01]
“1 Introduction”
-> Frequently Asked Questions
-> Can I Use Any Release of Pro*C/C++ with Any Version of the Oracle Server?
- Export / Import Compatibility Note:132904.1
© 2009, www.oracledatabase12g.com. 版权所有.文章允许转载,但必须以链接方式注明源地址,否则追究法律责任.
相关文章 | Related posts:
- Minimum Software Versions and Patches Required to Support Oracle Products on IBM Power Systems
- 11gR2 NEW FEATURE OCI Client Result Cache – Table annotations support
- Compatibility Matrix for Export And Import Between Different Oracle Versions
- Export/Import DataPump Parameter VERSION – Compatibility of Data Pump Between Different Oracle Versions
- OCP-8i DBA:Getting Started with the Oracle Server
- Design for Higher Availability and Faster Recovery Lawrence To Center of Expertise Worldwide Customer Support Oracle Corporation October 18th,
- Oracle In-Memory Database Cache Oracle TimesTen In-Memory Database
- RAC Support for RDS Over Infiniband
- How to Relink Oracle Database Software on UNIX
Oracle Database (RDBMS) Releases Support Status Summary
Oracle Database (RDBMS) Releases Support Status Summary
Information here was last updated on 19-Aug-2010
This note shows the current main Oracle Database releases along with information about the support status of each release and its Patch Sets.
(Click to see Details)
11.1.0.7 is the terminal 11.1 Patch Set
First year of Extended Support to be free of charge.
Upgrade to 10.2.0.5 is not required immediately upon start of Extended Support.
The end patching dates for 10.2.0.4 can be found in Note:742060.1 .
10.1 is now in Extended Support – see Note:761713.1
Limited Extended Support is available from July 2010 to July 2012 on selected platforms.
See the “Extended Support” details here
First year Extended Support was free for 9.2
The Free Extended Support period ended on 31-Jul-2008. See Note:392222.1
Key to coloring of above table:
(Click to see Details)
(Click on dates to see Desupport Notices)
(Click on dates to see Desupport Notices)
(9.0.1.5 for iAS)
Fixes only possible for iAS infrastructure instances on 9.0.1.5.
31-Dec-2003 for other platforms
(Novell NetWare ended 31-Jan-2003)
31-Dec-2005 (or earlier) for others
(No EMS for Novell NetWare)
EMS has ended.
Fixes only possible for exception cases listed in the Desupport Notice.
HPUX 64 bit 01-Jan-2001
AIX 64 bit 01-Jan-2001
Other platforms 30-June-2000
Key to coloring of above table:
Interoperability Support
Terminology Used in this Article