2019年4月25日 星期四

Oracle version support matrix

Oracle version support matrix



Oracle Release 19

Oracle Database Client Software Requirements

https://docs.oracle.com/en/database/oracle/oracle-database/19/ntcli/software-requirements.html

Lists the software requirements for Oracle Database client.

Table 2-3 Windows x64 Software Requirements

RequirementValue

Operating System

Oracle Database for Windows x64 is supported on the following operating systems:

  • Windows 8.1 x64 - Pro and Enterprise editions

  • Windows 10 x64 - Pro, Enterprise, and Education editions

  • Windows 11 x64 - Pro, Enterprise, and Education editions

  • Windows Server 2012 R2 x64 - Standard, Datacenter, Essentials, and Foundation editions

  • Windows Server 2016 x64 - Standard, Datacenter, and Essentials editions

  • Windows Server 2019 x64 - Standard, Datacenter, and Essentials editions

  • Windows Server 2022 x64 - Standard, Datacenter, and Essentials editions

Note:

  • Windows Multilingual User Interface Pack is supported.

  • The Server Core option is not supported.

  • Windows 11 x64 - Pro, Enterprise, and Education editions and Windows Server 2022 x64 - Standard, Datacenter, and Essentials editions are supported starting with Oracle Database 19c Release Update (19.13) or later.

Virtualization

Oracle certifies the following virtualization technologies with Oracle Database Client on Windows:

  • Oracle VM Server

  • Microsoft Hyper-V

For more detailed information on certified Oracle VM Server combinations, check My Oracle Support note 464754.1. For more information on certified Hyper-V combinations, you can visit:

http://www.oracle.com/technetwork/database/virtualizationmatrix-172995.html

Oracle Release 18
Oracle Database Client Software Requirements
Lists the software requirements for Oracle Database client.
https://docs.oracle.com/en/database/oracle/oracle-database/18/ntcli/software-requirements.html

Table 2-3 Windows x64 Software Requirements

RequirementValue

Operating System

Oracle Database for Windows x64 is supported on the following operating systems:

  • Windows 7 x64 - Professional, Enterprise, and Ultimate editions

  • Windows 8.1 x64 - Pro and Enterprise editions

  • Windows 10 x64 - Pro, Enterprise, and Education editions

  • Windows Server 2012 x64 - Standard, Datacenter, Essentials, and Foundation editions

  • Windows Server 2012 R2 x64 - Standard, Datacenter, Essentials, and Foundation editions

  • Windows Server 2016 x64 - Standard, Datacenter, and Essentials editions

Note:

  • Windows Multilingual User Interface Pack is supported.

  • The Server Core option is not supported.

Virtualization

Oracle certifies the following virtualization technologies with Oracle Database Client on Windows:

  • Oracle VM Server

  • Microsoft Hyper-V

For more detailed information on certified Oracle VM Server combinations, check My Oracle Support note 464754.1. For more information on certified Hyper-V combinations, you can visit:

http://www.oracle.com/technetwork/database/virtualizationmatrix-172995.html



FULL INTEROPERABILITY SUPPORT MATRIX

This matrix includes interoperability information for older versions and is included here for completeness.

CURRENT INTEROPERABILITY SUPPORT SITUATION

The matrix below summarizes client and server combinations that are supported for the most commonly used product versions. A full matrix appears at the end of this document.

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.

Client
Version
Server Version
23c21c19c18c12.2.012.1.011.2.0
23c#11YesYesYesNoNoNoNo
21cYesYesYesWasWasYes#12No
19cYesYesYesWasWasYes#12Yes#9
18cNoWasWasWasWasWasWas
12.2.0NoWasWasWasWasWasWas
12.1.0NoYes#12Yes#12WasWasYes#12Yes#12
11.2.0NoNoYes#9WasWasYes#12Yes#9

Key:

YesSupported
ESSupported but fixes only possible for customers with Extended Support.
MDSSupported, but fixes only possible for customer with a valid Market-Driven Support contract.
WasWas 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. Fixes are no longer possible.
NoHas never been Supported

Specific Notes:

  • #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 have never been 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.1 (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.
  • #8 – Attempting to connect from 9.2 to 12.1 will fail with an “ORA-28040: No matching authentication protocol” error.
  • #9 – 11.2.0.3 or 11.2.0.4 only. For Oracle Autonomous Transaction Processing and Oracle Autonomous Data Warehouse, there is additional limitation and 11.2.0.4 is the minimum supported client version.
  • #10 – For the IBM z/OS platform only, Oracle will continue to test past 2014, at its discretion, new versions of the database running on non-z/OS platforms with the older 10.2 client running on z/OS. For more information, please refer to Note 461234.1 – Oracle Database on z/OS Support Status.
  • #11 – 32-bit DB23c client is not available on any platform. However, you can use older 32-bit clients (e.g. 19c) with DB23c server based on this matrix unless the platform desupport notice indicates otherwise.
  • #12 – 12.1.0.2 only. For 11.2 interoperability, 11.2.0.4 is required.


Reference:

https://oraclefact.wordpress.com/2018/04/05/client-server-interoperability-support-matrix-for-different-oracle-versions-doc-id-207303-1/comment-page-1/


Client
Version
Server Version
18c12.2.0#1012.1.011.2.011.1.010.2.010.1.09.2.0
18cYesYesYesYes#9NoNoNo#3No#3
12.2.0YesYesYesYes#9NoNoNo#3No#3
12.1.0YesYesYesYesWasMDS #7No#3No#3
11.2.0Yes#9Yes#9YesYesWasMDS #7NoWas #5
11.1.0NoNoWasWasWasWas #7Was #6Was #5
10.2.0NoNoMDS #7MDS #7Was #7MDSWasWas #5
10.1.0#4NoNoNoWas #6Was #6WasWasWas
9.2.0NoNoNo#8Was #5Was #5Was #5WasWas
Key:
YesSupported
ESSupported but fixes only possible for customers with Extended Support .
LES or MDSSupported but fixes only possible for customer with a valid Limited Extended Support or Market-Driven Support contract respectively.
WasWas 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. Fixes are no longer possible.
NoHas never been Supported
Reference:
https://oraclefact.wordpress.com/2018/04/05/client-server-interoperability-support-matrix-for-different-oracle-versions-doc-id-207303-1/



SQL Server Planning, Pricing and License

  Server-CALs授權模式 1.需購買的量應該是所有終端用戶的電腦 例如:一台Data warehouse主機 與 一台Web報表主機,但公司有50人或電腦會連進Web報表主機開啟報表,則應該每一台用戶端電腦都需要有CALs授權,Data warehouse主機購買Ser...