连接到不同的数据库版本
我维护一组使用 Pro*C 连接到 Oracle 10g 数据库的应用程序。这些应用程序通常涉及将数据从一个数据库移动到另一个数据库。在每种情况下,都会与源数据库建立连接,并与目标数据库建立单独的连接。由于我无法控制的原因,目标数据库将升级到 11g,而源数据库则不会。我在互联网上搜索失败,我在谷歌中以我能想到的多种方式提出了这个问题,以确定连接到不同版本的数据库是否可以接受。我能找到的唯一的、几乎相关的文档是这个谁能向我指出任何其他可以减轻客户恐惧的文件?
I maintain a set of applications that use Pro*C to connect to Oracle 10g databases. These applications are generally involved with moving data from one database to another. In each case a connection is made to the source database and a separate connection is made to the target database. For reasons that are out of my control the target databases are to be upgraded to 11g whilst the source databases are not. I have searched the internet unsuccessfully, well I have posed the problem as many different ways as I can think of in google, in order to determine whether connecting to different versions of the database is acceptable .The only, almost relevant, documentation I can find is this Can anyone point me to any other documentation that would allay my clients fears?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
Oracle 的官方客户端/服务器兼容性矩阵是 My Oracle Support 207303.1“不同 Oracle 版本之间的客户端/服务器/互操作性支持”。这可能是您的客户希望看到的文档。
快速版本是,如果您的应用程序使用 10.2 Oracle 客户端,您将能够连接到从 9.2.0.4 到 11.2.0.x 的数据库。如果您的应用程序使用 9.2 Oracle 客户端,您将能够连接到 8.1.7.x 到 11.2.0.x 的数据库。如果您使用早期版本的 Oracle 客户端,您将无法连接到 11.1 或 11.2 数据库。
The official client/ server compatibility matrix for Oracle is My Oracle Support 207303.1 "Client/ Server/ Interoperability Support Between Different Oracle Versions". That is probably the documentation that your clients would want to see.
The quick version is that if your application were to use, say, the 10.2 Oracle client, you would be able to connect to databases from 9.2.0.4 to 11.2.0.x. If your application were to use the 9.2 Oracle client, you'd be able to connect to databases from 8.1.7.x to 11.2.0.x. If you used an earlier version of the Oracle client, you would not be able to connect to an 11.1 or an 11.2 database.