Managing patching

The BMC Database Automation (BDA) patch repository provides an easy method for creating a patch package and automatically applying patches to multiple nodes, one at a time or simultaneously. A patch package consists of the patch itself (from either Oracle, Microsoft, or Sybase) and any pre-provisioning or post-provisioning scripts to be run. After a patch package is created, it can be applied to the hosts and databases you specify, and it can be exported to another Manager. In addition to applying interim software patches, you can roll back, where applicable, a previously applied patch, when necessary. Patches can be applied to nodes that have been provisioned outside of BDA in addition to nodes that have been provisioned by BDA.

You can divide the patch application process in the following phases to optimize the patch application process: 

1. Pre-stage the patch: This step copies the patch media to nodes and extracts it.

   Note

   You can pre-stage a patch outside the patch window, which typically has bandwidth and time constraints. After pre-staging, you can apply the patch in the patch window.

2. Apply the patch: This step determines whether the patch media is already present on the node. If the media exists, it is compared with the patch media to be copied using checksum. If the checksum matches, then the patch is applied to the node. If the media is not present or the checksum does not match, the media is copied and then the patch is applied to the node.

   Example

   A patching job runs on nodes 1 through 10. The job successfully patches nodes 1 through 5 but fails on nodes 6 through 10. If you run the job again, it runs only on nodes 6 through 10.

The following topics provide instructions for managing patching by using BDA: