We upgraded the database by using Oracle Data Pump technology and the upgradable tablespace method. Upgrading from Oracle Database 12cR2 to 18cR1 involves the following steps:
This section provides a high-level overview of the process. For detailed information about the Oracle 18cR1 upgrade, see the following Oracle documentation:
To upgrade Oracle 12cR2 GI to 18cR1:
Download the 18c GI binary LINUX.X64_180000_grid_home.zip and unzip the files to the new 18c GI home: /u01/app/18.3.0/grid
Check the version and status of the current clusterware with crsctl commands and run the clusterware verification utility runcluvfy.sh as shown in this command:
$ /u01/app/18.3.0/grid/runcluvfy.sh stage -pre hacfg
Download and unzip this patch (p27006180_122010_Linux-x86-64.zip) to the /home/grid/patches directory, and then use the opatchauto utility to apply the patch to 188.8.131.52 GI home as the grid user:
[grid@]$/u01/app/12.2.0/grid/OPatch/opatchauto apply /home/grid/patches/27006180
To upgrade Oracle Database 12cR2 to 18cR1:
Download and unzip the Oracle Database 18c software LINUX.X64_180000_db_home.zip, and then run the installer to install the software to the new 18c Oracle home: /u01/app/oracle/product/18.3.0/dbhome_1
During the installation, select the Set up Software Only configuration option.
Also, during database installation, select the Single Instance database installation option and select Enterprise Edition for the database edition.
java -jar /u01/app/oracle/product/18.3.0/dbhome_1/rdbms/admin/preupgrade.jar TERMINAL
This command checks the current Oracle Database 12cR2 and identifies any required pre-upgrade actions. The output of this command includes the pre-upgrade actions and post-upgrade actions.
The dbua upgrade utility prompts the database to upgrade. To speed up the upgrade process, select Enable parallel upgrade and Recompile invalid objects during post upgrade. Once the upgrade is complete, upgrade results are displayed, as shown in the following figure.
Figure 18. Upgrade results