Upgrading to Oracle Database 12c Release 2

1.8 Upgrading to Oracle Database 12c Release 2

This procedure describes how to upgrade an Oracle Database from 11.2 to 12c release 2 with a single command, using Rapid Home Provisioning, both for managed and unmanaged Oracle homes.

Before you Begin

To upgrade to Oracle Database 12c release 2 (12.2.0.1), your source database must be either Oracle Database 11g release 2 (11.2.0.3 or 11.2.0.4), or Oracle Database 12c release 1 (12.1.0.2).
Oracle Grid Infrastructure on which the pre-upgrade database is running must be of the same release or later than the database release to which you are upgrading.
The source Oracle home to be upgraded can be a managed working copy, that is an Oracle home provisioned using Rapid Home Provisioning, or an unmanaged home, that is, an Oracle home not provisioned using Rapid Home Provisioning. If you are upgrading an unmanaged Oracle home, provide the complete path of the database for upgrade.

Procedure to Upgrade Oracle Database using Rapid Home Provisioning

From the Rapid Home Provisioning Server, run one of the following commands as per your source and destination database:
1. To upgrade an Oracle home managed by Rapid Home Provisioning, and there exist working copies of the source and destination databases, run:
```
[GRID:grid@testuser:/grid_home]>  rhpctl upgrade database -dbname test_database 
-sourcewc db112 -destwc db122 -root
```
  test_database is the name of the database being upgraded.
  
  db112 is the source working copy of the pre-upgrade database.
  
  db122 is the working copy of the upgraded Oracle Database software.
2. To upgrade an unmanaged Oracle home (source working copy does not exist because the Oracle home is not managed by Rapid Home Provisioning), run:
```
[GRID:grid@testuser:/grid_home]>  rhpctl move database -sourcehome 
/u01/app/orabase/product/11.2.0/dbhome_1 -destwc db122 -targetnode node1 -root
```
  /u01/app/orabase/product/11.2.0/dbhome_1 is the path of the database being upgraded.
  
  db122 is the working copy of the upgraded Oracle Database software.
  
  targetnode specifies the node on which the database to be upgraded is running, because the source Oracle Database is on a 11.2.0.4 cluster.

The upgraded database is now managed by Rapid Home Provisioning. You can ensure that your database is patched to the latest level, using Rapid Home Provisioning.

Note:

During upgrade, if an error occurs, the procedure stops and allows you to fix the error. After fixing the error, you can resume the upgrade operation from where it last stopped.

Watch a video

Parent topic: Rapid Home Provisioning Use Cases