There are different ways of upgrading to the latest release of Oracle database and Oracle provides multiple methods to upgrade. Few are listed below:
- Database Upgrade Assistant (DBUA)
- Manual Upgrade
- Transportable Tablespaces
- Datapump export/import
- Oracle Streams
- Oracle GoldenGate
I chose DBUA to upgrade my test database as it was the simplest and quickest of all. Below are the database environment details prior to upgrade:
Oracle Database Version: Oracle Database 11gR2 (220.127.116.11) (64-bit)
Operating System: Oracle Enterprise Linux 6.1 (64-bit)
To begin the upgrade process, I copied Oracle 12c software to the database server and did the following
- Backup Oracle database
- Stop the database
- Stop listener
- Change ORACLE_HOME environment variable in the bash profile of “oracle” user
- Launch Oracle 12c Installer (./runInstaller)
You will see the following screen:
Click "Next" and chose "Skip software updates".
Click "Next" and select "Upgrade an existing database". When you select this option Oracle will install Oracle 12cR1 software and then automatically launch DBUA to upgrade the databases.
Click "Next" and continue as shown in the screenshots below:
Make sure all the warnings are resolved before proceeding with the next step. In my case, I ignored the warning as this is a test database and the swap size is almost closer to the expected value.
Installation of Oracle 12 software begins as shown below:
After installing the software and completing Net configuration, Oracle Universal Installer will launch DBUA to upgrade existing databases.
Below are the screenshots from DBUA:
I ignored the warnings as this is our test database. You would like to resolve these warning for your production, development, testing, etc databases.
Well, it took more than 90 minutes to upgrade my test database. DBUA generates log files under "/u01/app/oracle/cfgtoollogs/dbua/
/upgrade1/" location. You may monitor the logs to see the progress and scripts that DBUA executes during the upgrade process.
Well, that's it. My database is now upgraded to Oracle Database 12c.
SQL> select * from v$version;
Oracle Database 12c Enterprise Edition Release 18.104.22.168.0 - 64bit Production 0
PL/SQL Release 22.214.171.124.0 - Production 0
CORE 126.96.36.199.0 Production 0
TNS for Linux: Version 188.8.131.52.0 - Production 0
NLSRTL Version 184.108.40.206.0 - Production 0
I am sure you would like to look for alternative and near zero downtime database upgrade approaches to upgrade your production databases. Here are few of the helpful links in this regard:
- Oracle White Paper on "Upgrading to Oracle Database 12c"
- Upgrade, Migrate, and Consolidate to Oracle Database 12c
- Complete Checklist for Manual Upgrades to Oracle Database 12c Release 1 (12.1) [ID 1503653.1]
Enjoy your Oracle Database 12c.