Oracle：10g oracle 客户端可以与 11g 服务器一起工作吗？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/1042331/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Oracle: Does a 10g oracle client work with an 11g server?
提问by airportyh
This is the reciprocal to this question. Currently, I am trying to use the instant client for Mac, version 10.2. There's no 11g version for Mac, as of now, based on this page(you have to click into each link to find out the actual version for each platform...lame).
这是这个问题的倒数。目前，我正在尝试使用适用于 Mac 的即时客户端 10.2 版。根据此页面，截至目前，没有适用于 Mac 的 11g 版本（您必须单击每个链接才能找到每个平台的实际版本...蹩脚）。
I tried connecting to our Oracle 11g server, and it just hangs there forever. Are they simply incompatible, or is something else fishy going on?
我尝试连接到我们的 Oracle 11g 服务器，但它永远挂在那里。它们只是不兼容，还是有其他可疑的事情发生？
回答by the.jxc
I would certainly say it should. The SQL*Net protocol it uses is essentially unchanged. Here's an example of me connecting an Oracle 9 to an Oracle 10 server.
我肯定会说它应该。它使用的 SQL*Net 协议基本上没有改变。这是我将 Oracle 9 连接到 Oracle 10 服务器的示例。
oracle@cammi:~$ sqlplus "urs/urs@THANOS_URS"
oracle@cammi:~$ sqlplus "urs/urs@THANOS_URS"
SQL*Plus: Release 9.2.0.8.0 - Production on Thu Jun 25 05:55:57 2009
SQL*Plus：9.2.0.8.0 版 - 2009 年 6 月 25 日星期四 05:55:57 生产
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
版权所有 (c) 1982、2002，甲骨文公司。版权所有。
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, Data Mining and Real Application Testing options
连接到：Oracle 数据库 10g 企业版 10.2.0.4.0 版 - 具有分区、数据挖掘和实际应用程序测试选项的 64 位生产
According to the guys at "http://www.experts-exchange.com/"...
据“ http://www.experts-exchange.com/”上的人说......
11 can talk to 11,10,9
10 can talk to 11,10,9,8
9 can talk to 11,10,9,8,7
8 can talk to 10,9,8,7
7 can talk to 9,8,7
According to Oracle forums, this is defined in Metalink DocID 207303.1, which provides a comprehensive client/ server compatibility matrix. I don't have Metalink access sadly, so I can't confirm this.
根据 Oracle 论坛，这是在 Metalink DocID 207303.1 中定义的，它提供了一个全面的客户端/服务器兼容性矩阵。遗憾的是我没有 Metalink 访问权限，所以我无法确认这一点。
If you are having connection troubles, I suggest you start with the Oracle alert log on your server machine. To find the location of your oracle alert log:
如果您遇到连接问题，我建议您从服务器计算机上的 Oracle 警报日志开始。要查找 oracle 警报日志的位置：
SQL> select value from v$parameter where name = 'background_dump_dest';
Also, you'll probably get something useful out of enabling listener tracing:
此外，您可能会从启用侦听器跟踪中获得一些有用的信息：
$ lsnrctl
LSNRCTL> set trc_level ADMIN
The trace file on my Solaris Oracle 10 install is found in:
我的 Solaris Oracle 10 安装中的跟踪文件位于：
$ORACLE_HOME/network/trace/listener.trc
You can view it directly or use the trcasst program to "format" it. Note that ALL of this is on the server, not your client side.
您可以直接查看它或使用 trcasst 程序对其进行“格式化”。请注意，所有这些都在服务器上，而不是您的客户端。
Hope this helps.
希望这可以帮助。
回答by tobidope
Normally this should just work. Here I sometimes have to connect to a 10g DB with a 9er client. Works flawless.
通常这应该可以正常工作。在这里，我有时必须使用 9er 客户端连接到 10g DB。工作完美。
回答by Rob van Laarhoven
It should work. I have never had problems with upwards compatiblity of Oracle Client. Test:
它应该工作。我从来没有遇到过 Oracle Client 向上兼容性的问题。测试：
myclient{oracle}# sqlplus system@rac11g
SQL*Plus: Release 10.2.0.3.0 - Production on Thu Jun 25 08:44:09 2009
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
PL/SQL Release 11.1.0.7.0 - Production
CORE 11.1.0.7.0 Production
TNS for Linux: Version 11.1.0.7.0 - Production
NLSRTL Version 11.1.0.7.0 - Production
回答by dbaora
There can be problems when a lower version client is used to access a higher version database, particularly when using links where you might get some erroneous results.
当使用较低版本的客户端访问较高版本的数据库时，可能会出现问题，尤其是在使用可能会得到一些错误结果的链接时。
See Document ID 207303.1 on My Oracle Support for more details (if you have access).
有关更多详细信息，请参阅 My Oracle Support 上的文档 ID 207303.1（如果您有访问权限）。
