조회 수 23214 추천 수 0 댓글 1
Client / Server / Interoperability Support Between Different Oracle Versions [ID 207303.1]

  수정 날짜 20-OCT-2010     유형 BULLETIN     상태 PUBLISHED  

Oracle Client / Server Interoperability Support

Introduction

This note gives a summary of the support for interoperability between Oracle client and server versions. This includes support for connections over database links between Oracle versions. Note that this relates to support for investigation of defects / ability to obtain bug fixes.

Note that this is a general guide for interoperability only - certain products or utilities may impose additional restrictions on supported combinations specific to the product / utility. eg: Precompilers, Export / Import utilities etc..

For a summary of the support status of each Oracle release see Note:161818.1

General Policy

Oracle's general policy is to test and support each new Oracle release for compatibility with older releases thus:
  • Test the NEW client to each OLDER server release where the OLDER release is still covered by Premier Support (formerly Primary Error Correction support) at the time that the NEW version is released.
  • Test OLDER clients to the NEW server release where the OLDER release is still covered by Premier Support (formerly Primary Error Correction support) OR is in the first two years of Extended Support (formerly Extended Maintenance support).
  • Tests between the NEW version and other OLDER releases may be added where Oracle deems it sensible to support interoperability between those releases.
  • Current Interoperability Support Situation

    The matrix below summarizes client and server combinations that are supported.

    New interoperability problems will only be investigated if BOTH releases involved are covered by a valid support contract at the time that the issue is reported .
    eg:

    A 9.2.0 client to a 10.2.0 server issue requires the customer to have a valid Extended Support contract for the 9.2.0 client in order for Oracle to investigate it.

    Server Version
    Client Version 11.2.0 11.1.0 10.2.0 10.1.0 9.2.0 9.0.1 8.1.7 8.1.6 8.1.5 8.0.6 8.0.5 7.3.4
    11.2.0 Yes Yes ES #7 No ES #5 No #3 No #3 No #3 No #3 No #3 No #3 No #3
    11.1.0 Yes Yes ES #7 ES #6 ES #5 No #3 No #3 No #3 No #3 No #3 No #3 No #3
    10.2.0 ES #7 ES #7 ES ES ES #5 No Was No #3 No #3 No #3 No #3 No #3
    10.1.0(#4) ES #6 ES #6 ES ES ES Was Was #2 No #3 No #3 No #3 No #3 No #3
    9.2.0 ES #5 ES #5 ES #5 ES ES Was Was No No Was No No #1
    9.0.1 No No No Was Was Was Was Was No Was No Was
    8.1.7 No No Was Was Was Was Was Was Was Was Was Was
    8.1.6 No No No No No Was Was Was Was Was Was Was
    8.1.5 No No No No No No Was Was Was Was Was Was
    8.0.6 No No No No Was Was Was Was Was Was Was Was
    8.0.5 No No No No No No Was Was Was Was Was Was
    7.3.4 No No No No Was Was Was Was Was Was Was Was

    Key:
    Yes Supported
    ES Supported but fixes only possible for customers with Extended Support .
    Was Was a supported combination but one of the releases is no longer covered by any of Premier Support , Primary Error Correct support , Extended Support nor Extended Maintenance Support so fixes are no longer possible.
    No Has never been Supported
    Specific Notes:
    • #1 - See Note:207319.1
    • #2 - An ORA-3134 error is incorrectly reported if a 10g client tries to connect to an 8.1.7.3 or lower server. See Note:3437884.8 .
    • #3 - An ORA-3134 error is correctly reported when attempting to connect to this version.
    • #4 - There are problems connecting from a 10g client to 8i/9i where one is EBCDIC based. See Note:3564573.8
    • #5 - For connections between 10.2 (or higher) and 9.2 the 9.2 end MUST be at 9.2.0.4 or higher. Connections between 10.2 (or higher) and 9.2.0.1, 9.2.0.2 or 9.2.0.3 are not supported.
    • #6 - For connections between 11.1 (or higher) database server and 10.1 / 10.2 database server across a database link the 10g end MUST be at 10.1.0.5 / 10.2.0.2 (or higher) respectively in order to use PLSQL between those versions. (This does not apply to normal 11g clients to 10g database server only server to server and a few very specific client products, such as Oracle Forms). See Note:4511371.8 for more details.
    • #7 - For database link connections between 11.2 (or higher) and 10.2 the 10g end MUST be at 10.2.0.2 (or higher) in order to use PLSQL between those versions. See Note:4511371.8 for more details.
    • General Notes:
      1. For database links between different Oracle versions connections must be supported in BOTH directions in the matrix above.
        eg: As 11.2 -> 10.1 is not supported then database links between these version are not supported in either direction.
      2. Unsupported combinations may appear to work but can encounter errors for particular operations. The fact that they appear to work should not be relied upon - issues on unsupported combinations will not be investigated.
      3. Since new database servers are compatible with a limited set of older OCI clients, it may not be necessary to upgrade the client software when upgrading the database. However, some new features may not work without upgrading the client software. So, for example, an Oracle 10.2 client is able to connect to an 11.2 database, but is not able to take advantage of newer features such as Client Result Cache (introduced in 11.1).
      4. Oracle Applications , or other Oracle products, may have supported configurations not listed in the matrix above.
      5. The matrix above also applies between different platforms and between 32/64 bit releases of Oracle client / server except where any Oracle platform desupport notice indicates otherwise .
      6. Unix BEQUEATH (BEQ) connections are NOT supported between different releases. eg: Client 10.2 is not supported to make an Oracle Net connection to a 11.2 server using the BEQ protocol adapter regardless of the interoperability support listed above. See Note:364252.1 for more details.
      7. Terminology

        See the "Terminology" section of Note:161818.1 for a description of Premier Support, Extended Support, Primary Error Correction Support and Extended Maintenence Support

        Related Articles

        • JDBC, JDK, and Oracle Database Certification Note:401934.1
          For JDBC clients information in Note:401934.1 takes priority over information in the above matrix.
        • Support Status of each Oracle Server (RDBMS) Release Note:161818.1
        • For Precompiler interoperability support also see:
           "Pro*C/C++ Programmer's Guide 11g Release 2 (11.2)" [Part Number E10825-01]
           "1 Introduction"
           -> Frequently Asked Questions
           -> Can I Use Any Release of Pro*C/C++ with Any Version of the Oracle Server?
        • Export / Import Compatibility Note:132904.1
          • 
            
            
            
            
            
            
            

    TAG •

    List of Articles
    번호 분류 제목 글쓴이 날짜 조회 수
    공지 Q&A Oracle관련 게시물만 Sean 2014.04.09 84918
    100 TM Oracle Silent Install Guide 3 file 송기성 2011.03.13 20257
    99 TM 엔지니어필수품 file perfstat 2011.03.03 14118
    98 TM RAC10g R2 patch(10.2.0.1->10.2.0.5) file 윤현 2011.03.02 11111
    97 Tip windows os 에서 운영중 listener.log 삭제하기 2 file dbkill 2011.02.21 22292
    96 Tip partition table에 index 생성시 perfstat 2011.01.28 18169
    » TM oracle client 와 database 간 상호 호환성(version) 1 담벼락 2011.01.24 23214
    94 Tip DB계정에 profile설정 perfstat 2011.01.05 14746
    93 TM Automatic Storage Management file 담벼락 2010.12.31 10632
    92 TM 10g Transportable Tablespace 에 대한 세미나 자료 입니다 file 송기성 2010.12.29 9205
    91 TM Replication 세미나 자료 file 고구마 2010.12.29 11200
    90 TM SystemState 세미나자료 file 고구마 2010.12.29 11024
    89 TM Database Replay 담벼락 2010.12.27 9521
    88 TM ORA-1578 조치를 위한 event 10231 1 이성철 2010.12.22 8460
    87 TM (10g) 자동 통계정보 수집(AUTOMATIC OPTIMIZER STATISTICS COLLECTION) 담벼락 2010.12.16 16388
    86 TM 오라클 디렉토리 변경 송기성 2010.12.16 26541
    85 Tip em 실행시 에러 발생 조치 1 dbkill 2010.12.15 27311
    84 Q&A RHEL5에 11gR2 RAC 구성시 ASM 관련 에러 file 송기성 2010.12.11 18177
    83 Tip NetCA 실행시 VM 관련 에러 대처법 2 송기성 2010.12.09 18205
    82 TM UPDATABLE SNAPSHOT 구축하기 고구마 2010.08.23 15509
    81 TM replication table 다른 tablespace 로 옮기기 고구마 2010.08.23 13822
    Board Pagination Prev 1 2 3 4 5 6 7 8 Next
    / 8