Monday, December 29, 2014

Oracle Database 12c Patch/Upgrade from to

For manual upgrade guide from 11g to 12c, click here. Same guide can also be followed to manually upgrade from to
Before going through this upgrade guide, you may be interested to view the guide to patch/upgrade standalone Grid Infrastructure from to

In this guide, you will see how we patch/upgrade our existing Oracle RDBMS software form to This would be an out-of-place upgrade and hence we would be installing new software in a new home.
As we know that Oracle now provides full installation binaries for patchset releases so the binaries are required to be downloaded from MOS. You would need to download Patch 17694377 disk 1 and 2. This upgrade was done on Oracle Linux 6 (x86-64) running on Oracle Virtual Box. There is a (cdb) database and an (db11g) database running on this host having files on ASM.

To install RDBMS software, log in as “oracle” (RDBMS software owner) and unset ORACLE_BASE and ORACLE_HOME environment variables. After this initiate the installer.
Unset ORACLE_HOME, ORACLE_SID and ORACLE_BASE environment variables


Click Next

Select “Install database software only”, and click Next

Make sure you have selected first option. Click Next 

Click Next

Click Next

Specify path for Oracle Base and Oracle Software Home directories. Click Next

Make necessary changes if required. Click Next

Click Install

When prompted, execute by opening a new terminal window and logging in as root

Installation is complete. Click Close

Now you should update your .bast_profile for “oracle” user to reflect new ORACLE_BASE and ORACLE_HOME directories.

Now it is time to upgrading existing database to Here I will be using DBUA to upgrade the database which is the recommended way to do an upgrade.
Same method can be used to upgrade any database with version or above (for 11G R2), or Otherwise you would need to use some other method to upgrade your database. Please see this white paper for the details.

Open DBUA by executing command dbua. Select first option to upgrade the Oracle database. Click Next.

Select your source database for upgrade. Click Next

If this is a container database, all pluggable databases would also be upgraded automatically. Click Next

Make sure there is not error or warning on this screen. If you see any error or warning, resolve it before moving further. Click Next

Select upgrade parallelism carefully. I selected 4 with my single processor Virtual Machine and it took several hours to finish. Your parallelism should never go beyond the number of processors. Click Next

Specify the port on with OEM is needed to be configured. Click Next

Click Next

Select the Listener to which this database will be registered. Or if you want to create a new Listener. local_listener entry in the parameter file would be updated to register the database with the specified listener. Click Next

Select if you either want RMAN to create a new backup before upgrade, or if you want to create or use an existing guaranteed restore point to revert back the database in case of a failed upgrade. Or if you don’t want to take any backup because you already have backed up your database before starting the upgrade. Click Next

Click Finish

Monitor the progress

Click on the Upgrade Results button to see the details. Ignore the Time taken for upgrade, in bellow screen shot because for my case it took quite a long time to finish because of limited resources I had for my virtual machine.

Now you many click on Close to DBUA interface.
DBUA would automatically register database in grid infrastructure from new ORACLE_HOME (, as can be seen bellow

[grid@salman1 ~]$ srvctl config database -d cdb
Database unique name: cdb
Database name: cdb
Oracle home: /u01/app/oracle/product/12.1.0/dbhome_1
Oracle user: oracle
Spfile: +DATA/cdb/spfilecdb.ora_1418278365037
Password file:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Disk Groups: DATA
Services: pdb_srv
OSDBA group:
OSOPER group:
Database instance: cdb

No comments:

Post a Comment