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 Fleet Patching and Provisioning Server, run one of the following commands as per your source and destination database:

To patch an Oracle Database home managed by Fleet Patching and 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.
To patch an unmanaged Oracle Database home (source working copy does not exist because the Oracle home is not managed by Fleet Patching and 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.
If for some reason, you want to rollback the patches applied to a managed Oracle Database home, run:
```
rhpctl move database -sourcewc db12102_psu 
-patchedwc db12102 -ignorewcpatches
```
db12102 is the working copy of the unpatched database to which you want to roll back.

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

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), Fleet Patching and 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

Parent topic: Fleet Patching and Provisioning Use Cases