欢迎进入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
$ sqlplus /nologsql*plus: release 8.1.7.0.0 - production on wed apr 5 16:58:05 2006(c) copyright 2000 oracle corporation. all rights reserved.sql> conn mlqin/*****@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.