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 12.1.0.2.0 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 12.1.0.2.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options SQL> select name,open_mode,cdb from v$database; NAME OPEN_MODE CDB --------- -------------------- --- NCDB READ WRITE NO
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:
/u01/sw1/preupgrade.log
/u01/sw1/preupgrade_fixups.sql
/u01/sw1/postupgrade_fixups.sql
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: 12.2.0.1.0 Build: 1
Generated on: 2018-08-27 04:07:10
For Source Database: NCDB
Source Database Version: 12.1.0.2.0
For Upgrade to Version: 12.2.0.1.0
Fixup
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: https://t.me/helporacle
Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/
Joel Perez’s LinkedIn: Joel Perez’s Profile
LinkedIn Group: Oracle Cloud DBAAS
Facebook Page: OracleHelp
