In this article, we will see upgrading Oracle Database from 12c Release 1 to 12C Release 2.

Step 1: Check database details

[oracle@localhost u01]$ sqlplus / as sysdba

SQL*Plus: Release Production on Mon Aug 27 04:08:28 2018

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Connected to:
Oracle Database 12c Enterprise Edition Release - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> select name,open_mode,cdb from v$database;

--------- -------------------- ---

Step 2: Run preupgrade script

[oracle@localhost oradata]$ /u01/oracle/product/12.1.0/db_1/jdk/bin/java -jar /u01/oracle/product/12.2.0/db_1/rdbms/admin/preupgrade.jar FILE DIR /u01/sw1
Preupgrade generated files:

Step 3: Run preupgrade_fixups.sql

SQL> @/u01/sw1/preupgrade_fixups.sql
Executing Oracle PRE-Upgrade Fixup Script

Auto-Generated by:       Oracle Preupgrade Script
                         Version: Build: 1
Generated on:            2018-08-27 04:07:10

For Source Database:     NCDB
Source Database Version:
For Upgrade to Version:

Check Name                Status  Further DBA Action
----------                ------  ------------------
dictionary_stats          Passed  None
apex_upgrade_msg          Failed  Manual fixup recommended.
min_archive_dest_size     Failed  Manual fixup recommended.

PL/SQL procedure successfully completed.

Step 4: It is giving an error on min_archive_dest_size parameter as It is not having enough free storage available

SQL> alter system set log_archive_dest_1='LOCATION=/u01/arc/ncdb';

Step 5: Run DBUA

[oracle@localhost u01]$dbua

Step 6: As GUI opens select database you want to upgrade and specify username and password

Step 7: Check if there are warnings or errors as prerequisites check, solve them before proceeding

Step 8: Tick  checkboxes you want to upgrade  and specify scripts if you want it to execute before the upgrade or after upgrade

Step 9: Select recovery option here I have instructed it to create a new full RMAN backup.

Step 10: Select listener you want to migrate to new database home

Step 11: Configure EM options

Step 12: Check upgrade summary and click on next

Step 13: Check upgrade progress.

Step 14: After successful completion of the upgrade close window

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

Telegram Channel:

Skant Gupta’s LinkedIn:

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

About The Author

Leave a Reply

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