Oracle Database 12c release 1 (12.1) introduced the Parallel Upgrade Utility, catctl.pl. This utility reduces the total amount of time it takes to perform an upgrade by loading the database dictionary in parallel, and by using multiple SQL processes to upgrade the database. Performing parallel upgrades of components enables you to take advantage of your CPU capacity. Oracle continues to make improvements to the upgrade process to simplify both manual upgrades, and upgrades performed with the Database Upgrade Assistant (DBUA). DBUA and the manual upgrade procedures take advantage of the new Parallel Upgrade Utility.

You can run a shell command, dbupgrade, which starts up catctl.pl from the command line, instead of requiring you to run it from Perl.

The dbupgrade shell command is located in the file path $ORACLE_HOME/rdbms/bin on Linux and UNIX, and %ORACLE_HOME%\rdbms\bin on Windows. You can provide any command arguments that are valid for catctl.pl to the shell command. Either run the command directly from the new Oracle home path, or set a user environment variable to point to the file path.

In Oracle 12.1 catcpl.pl had to be run using perl like

Starting with Oracle 12.2, we can use dbupgrade utility which starts up catctl.pl instead to run it from perl.

Step 1: Setting up the environment variable and run necessary jar files

The preupgrade.jar file is located to the oracle 12.2 $ORACLE_HOME/rdbms/admin. We can execute it using the TERMINAL or FILE options. The TERMINAL option will send output in the terminal and with FILE we will have the output in a file.

As specified if we want the output in a file, we can use the option FILE instead of TERMINAL. The output directory is $ORACLE_BASE/cfgtoollogs/$ORACLE_SID

Step 2: Run preupgrade_fixups.sql on Oracle 12.1

Step 3: Prepare the environment variable for Oracle 12.2 and copy spfile in new home

Step 4: Start the database in the new environment in an upgrade mode

Step 5: Run the dbupgrade utility

Here n stands for number of processes and l stands for log file location

Step 6: Run the postupgrade_fixups.sql

Cheers!!! Upgrade has completed

Comments

Leave a Reply