Oracle:10g oracle客户端可以与11g服务器一起使用吗? [英] Oracle: Does a 10g oracle client work with an 11g server?

问题描述

这是的倒数这个问题.当前，我正在尝试使用Mac 10.2版的即时客户端.到目前为止，基于此版本，Mac还没有11g版本页面(您必须单击每个链接以找到每个平台的实际版本...标签).

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).

我尝试连接到我们的Oracle 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?

推荐答案

我当然会说.它使用的SQL * Net协议基本上没有变化.这是我将Oracle 9连接到Oracle 10服务器的示例.

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.

oracle @ cammi:〜$ sqlplus"urs/urs @ THANOS_URS"

oracle@cammi:~$ sqlplus "urs/urs@THANOS_URS"

SQL * Plus:9.2.0.8.0版-于2009年6月25日星期四05:55:57生产

SQL*Plus: Release 9.2.0.8.0 - Production on Thu Jun 25 05:55:57 2009

甲骨文公司(c)1982、2002版权所有.保留所有权利.

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

已连接到: Oracle数据库10g企业版10.2.0.4.0版-64位生产 有了分区，数据挖掘和实际应用程序测试选项

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

据" http://www.experts-exchange.com/上的人说"...

According to the guys at "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

根据Oracle论坛，这是在Metalink DocID 207303.1中定义的，该ID提供了全面的客户端/服务器兼容性矩阵.可悲的是我没有Metalink的访问权限，所以我无法确认.

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警报日志开始.要查找Oracle警报日志的位置，请执行以下操作:

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:

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

可在以下位置找到我的Solaris Oracle 10安装上的跟踪文件:

The trace file on my Solaris Oracle 10 install is found in:

$ORACLE_HOME/network/trace/listener.trc

您可以直接查看它，也可以使用trcasst程序对其进行格式化".请注意，所有这些都在服务器上，而不是在客户端上.

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.

希望这会有所帮助.

这篇关于Oracle:10g oracle客户端可以与11g服务器一起使用吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！