eygle.com   eygle.com
eygle.com eygle
eygle.com  
 

« Oracle10g:v$session_wait_history视图 | Blog首页 | PGA_AGGREGATE_TARGET参数的变更 »

Oracle10g与各版本的连通性

昨天有朋友问到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.
            


历史上的今天...
    >> 2012-04-06文章:
    >> 2008-04-06文章:
           偶遇孟静
    >> 2007-04-06文章:
           CSDN英雄会上会英雄
    >> 2005-04-06文章:
    >> 2004-04-06文章:

无觅

By eygle on 2006-04-06 16:35 | Comments (2) | Oracle12c/11g | 731 |

2 Comments

我安装Oracle11g后 用Object Browser10连接Oracle9i的数据库也报这个错 是不是11g的OCI不再支持老版本啦?

有这种可能,没试过OCI。


CopyRight © 2004~2020 云和恩墨,成就未来!, All rights reserved.
数据恢复·紧急救援·性能优化 云和恩墨 24x7 热线电话:400-600-8755 业务咨询:010-59007017-7040 or 7037 业务合作: marketing@enmotech.com