June
16th,
2016
工作環境中有台歷史的資料庫，Oracle Database 8.1.7，這出生於 Windows 98 時代的資料庫，要跟他索取資料，那就一定要注意所使用的 Oracle Client 是否符合版本需求，不然你可是會得到 Connections to this server version are no longer supported. 這種令人沮喪的訊息。
一直以來在尋找 Oracle Client 和 Server 的對照表，到底我們的 Oracle Database 8.1.7 能夠支援到多新的 Oracle Client，這個問號藏在心中已久，今天終於找到答案了，就是下表。
| 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 | LES #5 | No #3 | No #3 | No #3 | No #3 | No #3 | No #3 | No #3 |
| 11.1.0 | Yes | Yes | ES #7 | ES #6 | LES #5 | No #3 | No #3 | No #3 | No #3 | No #3 | No #3 | No #3 |
| 10.2.0 | ES #7 | ES #7 | ES | ES | LES #5 | No | Was | No #3 | No #3 | No #3 | No #3 | No #3 |
| 10.1.0(#4) | ES #6 | ES #6 | ES | ES | LES | Was | Was #2 | No #3 | No #3 | No #3 | No #3 | No #3 |
| 9.2.0 | LES #5 | LES #5 | LES #5 | LES | LES | 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 |
| Yes | Supported |
| LES | Supported but fixes only possible for severity 1 issues for customers with Extended Support . Limitations apply - see click here for policy details for 9.2. |
| 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 |
參考資料：