Oracle10g与各版本的连通性

欢迎进入Oracle社区论坛，与200万技术人员互动交流 >>进入昨天有朋友问到Oracle10g和Oracle8i的连通性问题,一时记不清楚,同事作了一些测试.得到的结论是: Oracle8.1.5可以连接Oracle10g Oracle8.1.7也可以连接Oracle10g Oracle10gR2可以连接Oracle8.1.7,但

欢迎进入Oracle社区论坛，与200万技术人员互动交流 >>进入

昨天有朋友问到Oracle10g和Oracle8i的连通性问题,一时记不清楚,同事作了一些测试.得到的结论是:

Oracle8.1.5可以连接Oracle10g
Oracle8.1.7也可以连接Oracle10g
Oracle10gR2可以连接Oracle8.1.7,但是不能连接Oracle8.1.5
Oracle10g和Oracle9i各版本可以互连.

简要记录于此:

1.Oracle8.1.5连接Oracle10gR1

oracle:/oracle/oracle8/network/admin>sqlplus /nologSQL*Plus: Release 8.1.5.0.0 – Production on Wed Apr 5 17:21:30 2006(c) Copyright 1999 Oracle Corporation.  All rights reserved.SQL> conn mlqin/*****@mmsdbConnected.SQL> select * from v$version  2  /BANNER—————————————————————-Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 – 64biPL/SQL Release 10.1.0.3.0 – ProductionCORE    10.1.0.3.0      ProductionTNS for Solaris: Version 10.1.0.3.0 – ProductionNLSRTL Version 10.1.0.3.0 – ProductionSQL> exit

2.Oracle8.1.7连接Oracle10gR2

本文来源gaodai^.ma#com搞#代!码网

n/*****@hsstatConnected.SQL> select * from v$version;BANNER—————————————————————-Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – 64biPL/SQL Release 10.2.0.1.0 – ProductionCORE 10.2.0.1.0 ProductionTNS for Solaris: Version 10.2.0.1.0 – ProductionNLSRTL Version 10.2.0.1.0 – ProductionSQL> exitDisconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 – 64bit ProductionWith the Partitioning, OLAP and Data Mining options

3.Oracle10gR2连接Oracle8.1.7.4

$ sqlplus /nologSQL*Plus: Release 10.2.0.1.0 – Production on Wed Apr 5 17:19:01 2006Copyright (c) 1982, 2005, Oracle.  All rights reserved.SQL> conn mlqin/*****@test8Connected.SQL> select * from v$version;   BANNER—————————————————————-Oracle8i Enterprise Edition Release 8.1.7.4.0 – 64bit ProductionPL/SQL Release 8.1.7.4.0 – ProductionCORE    8.1.7.0.0       ProductionTNS for Solaris: Version 8.1.7.4.0 – ProductionNLSRTL Version 3.4.1.0.0 – ProductionSQL>

4.Oracle10gR2不能连接Oracle8.1.5

$ sqlplus /nologSQL*Plus: Release 10.2.0.1.0 – Production on Wed Apr 5 17:09:38 2006Copyright (c) 1982, 2005, Oracle.  All rights reserved.SQL> conn mlqin/****@199ERROR:ORA-03134: Connections to this server version are no longer supported.

Hi，您需要填写昵称和邮箱！