1.7 Patching Oracle Database 12c Release 1 Without Downtime

This procedure explains how to patch Oracle Database 12c release 1 (12.1.0.2) with the latest patching without bringing down the database.

Before You Begin

You have an Oracle Database db12102 that you want to patch to the latest patch level.

Ensure that the working copy db12102_psu based on the image DB12102_PSU contains the latest patches and is available.

Procedure

From the Rapid Home Provisioning Server, run one of the following commands as per your source and destination database:

1. To patch an Oracle Database home managed by Rapid Home Provisioning, and there exist working copies of the source and destination databases, run:

   rhpctl move database -sourcewc db12102 -patchedwc db12102_psu

   db12102 is the source working copy of the database being patched

   db12102_psu is the working copy of the Oracle Database software with patches applied, based on the image DB12102_PSU.

2. To patch an unmanaged Oracle Database home (source working copy does not exist because the Oracle home is not managed by Rapid Home Provisioning), run:

   rhpctl move database -sourcehome /u01/app/orabase/product/12.1.0.2/dbhome_1
    -patchedwc db12102_psu -targetnode node1

   targetnode specifies the node on which the database to be upgraded is running, because the source Oracle Database is on a 12.1.0.2 cluster.

   /u01/app/orabase/product/12.1.0.2/dbhome_1 is the path of the database being patched

   db12102_psu is the working copy of the Oracle Database software with patches applied, based on the image DB12102_PSU.

   Use the saved gold image for standardized patching of all your databases of release 12c release 1 to the same patch level.
3. If for some reason, you want to rollback the patches applied to an unmanaged Oracle Database home, run:

   rhpctl move database -patchedwc db12102_psu 
   -sourcehome /u01/app/orabase/product/12.1.0.2/dbhome_1
    targetnode node1

For all Oracle Databases, you can also specify these additional options with the move database command:

• -keepplacement: For admin-managed Oracle RAC Databases (not Oracle RAC One Node Database), Rapid Home Provisioning retains the services on the same nodes after the move.

• -disconnect: Disconnects all sessions before stopping or relocating services.

• -drain_timeout: Specify the time, in seconds, allowed for resource draining to be completed for planned maintenance operations. During the draining period, all current client requests are processed, but new requests are not accepted. This option is available only with Oracle Database 12c release 2 (12.2) or later.

• -stopoption: Stops the database.

• -nodatapatch: Ensures datapatch is not run for databases you are moving.

Watch a video