软讯网络 > 冲浪宝典 > 网络资源 > Oracle10g与各版本的连通性
【标 题】：Oracle10g与各版本的连通性
【关键字】：
Oracle10g
【来 源】：http://www.cublog.cn/u/21218/showart.php?id=138946
Oracle10g与各版本的连通性
特别说明：本文出自eygle大师的BLOG
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.
|
# cal 9 1752
September 1752
S M Tu W Th F S
1 2 14 15 16
1 7 18 19 20 21 22 23
2 4 25 26 27 28 29 30
| 网站地图 |