Manual upgrading Oracle database 11gR2 to 19c

If you want to know how we upgrade an 11.2.0.4 database to 19.0.0.0.0 using DBUA, click here.

This article explains how to upgrade 11.2.0.3 and above, and 12.1.0.1, 12.2.0.1, 18c to 19.0.0.0.0 manually.

Manually upgrading to 19c

There are many DBAs who don’t want to follow the recommended way of an upgrade using DBUA (Database Upgrade Assistant). Following is the method of manually upgrading the 11gr2 database to 19c. I will be using here 11.2.0.4 to upgrade to 19.1.0.0.0, on Oracle Linux (x64_86) platform.

I already install new software for Oracle 19c

Below is my environment detail

DBNAME  – MANUAL19C

CURRENT ORACLE_HOME – /u01/app/oracle/product/11.0.0/dbhome_1

NEW ORACLE_HOME – /u01/app/oracle/product/19.0.0/dbhome_1

PRE-UPGRADE STEPS:

1. Run the preupgrade tool

Preupgrade tool is available under new $ORACLE_HOME/rdbms/admin.

SYNTAX

$OLD_ORACLE_HOME/jdk/bin/java -jar $NEW_ORACLE_HOME/rdbms/admin/preupgrade.jar -FILE DIR $OS_DIRECTORY

Where OS_DIRECTORY is any directory at OS level.

Run the preupgrade_fixup.sql

To get rid of from the warnings. Steps are below

Again re-run preupgrade_fixup.sql.

Shutdown the database and take full database backup. Alternatively, you can turn on the flashback database and create a Guaranteed Restore Point which can be used to rollback if upgrade process fails.

Copy the parameter and password file from the 11g home to the 18c home.

Set new ORACLE HOME of 19c location and start the database in upgrade mode.

Run catctl.pl

If used catctl.pl, the output of this upgrade process would be similar to the following. For this example, log files would be in /tmp folder as specified in upgrade command. For conventional running of catupgrd.sql from SQLPLUS, please see the spool file for output or any errors

-n is used for parallelism (new feature on Oracle 12c). Run the below command from $ORACLE_HOME/rdbms/admin

$ORACLE_HOME/perl/bin/perl catctl.pl -n 4 catupgrd.sql

For the output log, click here

Start the database and run “postupgrade_fixups.sql” which was created earlier.

To fix the manual error related to timezone

The database is using timezone datafile version 14 and the target 19.1.0.0.0 database ships with timezone datafile version 34. Oracle recommends using the most recent timezone data.  For further information, refer to My Oracle Support Note 1585343.1

Or we can do manually from here

To get rid of from the warnings. Steps are below

Lastly, execute utlrp.sql script to compile if there are any invalid objects.

Set COMPATIBLE parameter value to 19.0.0 and also start the listener with a new home.

Restart the database

Cheers!!!

Upgradation Successfully Done

Stay tuned for More articles on Oracle 19c

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

Anuradha’s LinkedIn: Anuradha’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

Comments

  1. Dariusz Domanski

    Since 12c invoking catupgrd.sql in sqlplus returns information to use parallel upgrade utility. Is it really changed back in 19c?

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.