Friday, March 27, 2020

Oracle database 8i to 12c R1 upgrade

This blog post provides the overall approach to upgrade from Oracle 8i (specifically 8.1.7.4) to Oracle 12c R1 (specifically 12.1.0.2)

Is your current version 8.1.7.4 (8i R3) ?

If so, this is the approach. You have to perform two upgrades. The first one is called an intermediate upgrade.

We recommend you to use dbua tool (database upgrade assistant GUI tool) instead of export and import tools.

1) Oracle 8.1.7.4 (8i R3) to Oracle 10.2.0.5

Do you have access to Oracle support https://support.oracle.com ?

If so, request them to provide you Oracle 10.2.0.1 software (base edition) through a service request.  Install this 10.2.0.1 base software - Then download 8202632 which is the patch number for patchset 10.2.0.5 and apply to the 10.2.0.1 installed folder to bring it up to 10.2.0.5


Now do a direct upgrade from Oracle 8.1.7.4 to 10.2.0.5

https://docs.oracle.com/cd/B19306_01/server.102/b14238.pdf 


2) In a separate path, install Oracle 12.1.0.2

Then upgrade the 10.2.0.5 upgraded database to Oracle 12.1.0.2.

https://docs.oracle.com/database/121/UPGRD/E41397-13.pdf 

No comments: