[转载]Oracle10g与各版本的连通性
来源:互联网 发布:淘宝店标logo设计 编辑:程序博客网 时间:2024/06/03 21:01
作者:eygle 发表于 2006-04-06 16:35
http://www.eygle.com/archives/2006/04/oracle10g_to_oracle8i.html
昨天有朋友问到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 /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
2.Oracle8.1.7连接Oracle10gR2
$ 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
3.Oracle10gR2连接Oracle8.1.7.4
$ 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>
4.Oracle10gR2不能连接Oracle8.1.5
$ 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.
-----
- [转载]Oracle10g与各版本的连通性
- 设置TimesTen与Oracle数据库的连通性
- Oracle10g正式版本迁移到Oracle10g XE 的中文问题
- mondrian的foodmart示例的Oracle10g版本
- ORACLE10g及以后的版本expdp错误
- oracle10g的spfile与pfile
- Oracle10g的安装与卸载
- Oracle10g的spfile与pfile
- Oracle10G各版本下载以及补丁地址
- Oracle10G各版本下载以及补丁地址
- 路与连通性
- 5.3.3 图的遍历与图的连通性
- win7各版本的区别-转载的
- Linux ping --测试与目标主机的连通性
- oracle10g小版本升级
- oracle10g版本不再支持
- 图的连通性小结
- 图的连通性
- js中结合使用php
- 关于"回车"和"换行"
- 关于Alpha.beta,RC等版本意义
- 深入解析 ATL
- JAVA中子类对象的实例化过程
- [转载]Oracle10g与各版本的连通性
- Java 从0开始……
- 龙芯软件开发(6)--CPU龙芯2E
- Cellsea--手机资源DIY工具站
- [转载]JVM调优
- Servlet和JSP 性能调整技术
- VC Studio 使用技巧大全
- (译)2007年关于RIA的10个预测
- Cellsea--手机资源DIY工具站