考试网 >> IT认证 >> Oracle >> Oracle指导 >> Oracle10g与各版本的连通性

Oracle10g与各版本的连通性

发布时间：2006-06-28 10:26 点击：

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.

版权申明:未经书面授权请勿转载本站信息!!作品版权归所属媒体与作者所有!!

发表评论：

匿名发表

用户名:

查看评论

您将承担一切因您的行为、言论而直接或间接导致的民事或刑事法律责任
留言板管理人员有权保留或删除其管辖留言中的任意内容
本站提醒：不要进行人身攻击。谢谢配合。