Oracle客户端与Oracle数据库兼容矩阵
2023-08-29 22:38 潇湘隐者 阅读(1591) 评论(0) 编辑 收藏 举报Oracle客户端与Oracle数据库之间是有兼容支持关系的,有些低版本的Oracle Client连接到高版本的数据库是不支持的,其实Oracle官方文档 Client / Server Interoperability Support Matrix for Different Oracle Versions (Doc ID 207303.1)[1]中有详细的介绍,如果你要升级数据库的话或遇到客户端与数据库兼容问题的话,建议仔细查看此文档。下面图片是文中的兼容矩阵关系图。

Specific Notes:
#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 have never been supported.
#6 - For connections between 11.1 (or higher) database server and 10.1 / 10.2 database server across a database link 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. (This does not apply to normal 11g clients to 10g database server only server to server and a few very specific client products, such as Oracle Forms). See Note 4511371.8 for more details.
#7 - For database link connections between 11.1 (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.
#8 - Attempting to connect from 9.2 to 12.1 will fail with an "ORA-28040: No matching authentication protocol" error.
#9 - 11.2.0.3 or 11.2.0.4 only. For Oracle Autonomous Transaction Processing and Oracle Autonomous Data Warehouse, there is additional limitation and 11.2.0.4 is the minimum supported client version.
#10 - For the IBM z/OS platform only, Oracle will continue to test past 2014, at its discretion, new versions of the database running on non-z/OS platforms with the older 10.2 client running on z/OS. For more information, please refer to Note 461234.1 - Oracle Database on z/OS Support Status.
#11 - 32-bit DB23c client is not available on any platform. However, you can use older 32-bit clients (e.g. 19c) with DB23c server based on this matrix unless the platform desupport notice indicates otherwise.
#12 - 12.1.0.2 only. For 11.2 interoperability, 11.2.0.4 is requir
下图是完整的矩阵兼容关系图(FULL INTEROPERABILITY SUPPORT MATRIX)

参考资料
1: https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=459942577177294&id=207303.1&_afrWindowMode=0&_adf.ctrl-state=yivmtoe98_572

【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 微软正式发布.NET 10 Preview 1:开启下一代开发框架新篇章
· 没有源码,如何修改代码逻辑?
· PowerShell开发游戏 · 打蜜蜂
· 在鹅厂做java开发是什么体验
· WPF到Web的无缝过渡:英雄联盟客户端的OpenSilver迁移实战
2017-08-29 批量修改所有服务器的dbmail配置
2013-08-29 Linux 客户端访问 NFS报Permission Denied错误
2009-08-29 MS SQL 建表SQL的脚本