Still quite a few remain in 7.3, 8.1.7 and 9.2.0.8 (ofcourse, without a support on very old versions and happy with what they have) – Others are gearing towards to upgrade to Oracle 11g Release 1. The recommended direct and indirect path upgrade listed below:
- Direct Upgrade Path
| Source Database | Target Database |
| 9.2.0.4.0 (or higher) | 11.1.x |
| 10.1.0.2.0 (or higher) | 11.1.x |
| 10.2.0.1.0 (or higher) | 11.1.x |
- Indirect Upgrade Path
| Source Database | Intermediate Upgrade Path | Target Database |
| 7.3.3.0.0 (or lower) | 7.3.4.x –> 9.2.0.8 | 11.1.x |
| 8.0.5.0.0 (or lower) | 8.0.6.x –> 9.2.0.8 | 11.1.x |
| 8.1.7.0.0 (or lower) | 8.1.7.4 –> 9.2.0.8 | 11.1.x |
| 9.0.1.3.0 (or lower) | 9.0.1.4 –> 9.2.0.8 | 11.1.x |
For example – If source database is 8.1.7.0.0 then recommended upgrade path to be followed is
8.1.7.0.0 (to–>) 8.1.7.4 (to–>) 9.2.0.4 (or higher) (to–>) 11.1.x