扫一扫
分享文章到微信
扫一扫
关注官方公众号
至顶头条
昨天有朋友问到Oracle10g和Oracle8i的连通性问题,一时记不清楚,同事作了一些测试.得到的结论是:
Oracle8.1.5可以连接Oracle10g
Oracle8.1.7也可以连接Oracle10g
Oracle10gR2可以连接Oracle8.1.7,但是不能连接Oracle8.1.5
Oracle10g和Oracle9i各版本可以互连.
简要记录于此:
oracle:/oracle/oracle8/network/admin>sqlplus /nolog SQL*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/*****@mmsdb Connected. SQL> select * from v$version 2 / BANNER ---------------------------------------------------------------- oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - 64bi PL/SQL Release 10.1.0.3.0 - Production CORE 10.1.0.3.0 Production TNS for Solaris: Version 10.1.0.3.0 - Production NLSRTL Version 10.1.0.3.0 - Production SQL> exit |
$ sqlplus /nolog SQL*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/*****@hsstat Connected. SQL> select * from v$version; BANNER ---------------------------------------------------------------- oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi PL/SQL Release 10.2.0.1.0 - Production CORE 10.2.0.1.0 Production TNS for Solaris: Version 10.2.0.1.0 - Production NLSRTL Version 10.2.0.1.0 - Production SQL> exit Disconnected from oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production With the Partitioning, OLAP and Data Mining options |
$ sqlplus /nolog SQL*Plus: Release 10.2.0.1.0 - Production on Wed Apr 5 17:19:01 2006 Copyright (c) 1982, 2005, oracle. All rights reserved. SQL> conn mlqin/*****@test8 Connected. SQL> select * from v$version; BANNER ---------------------------------------------------------------- Oracle8i Enterprise Edition Release 8.1.7.4.0 - 64bit Production PL/SQL Release 8.1.7.4.0 - Production CORE 8.1.7.0.0 Production TNS for Solaris: Version 8.1.7.4.0 - Production NLSRTL Version 3.4.1.0.0 - Production SQL> |
$ sqlplus /nolog SQL*Plus: Release 10.2.0.1.0 - Production on Wed Apr 5 17:09:38 2006 Copyright (c) 1982, 2005, oracle. All rights reserved. SQL> conn mlqin/****@199 ERROR: ORA-03134: Connections to this server version are no longer supported. |
如果您非常迫切的想了解IT领域最新产品与技术信息,那么订阅至顶网技术邮件将是您的最佳途径之一。
现场直击|2021世界人工智能大会
直击5G创新地带,就在2021MWC上海
5G已至 转型当时——服务提供商如何把握转型的绝佳时机
寻找自己的Flag
华为开发者大会2020(Cloud)- 科技行者