Oracle Database
An Oracle Database (DB) is a collection of data treated as a unit. A database stores and retrieves related information. Oracle Database is widely used and known for its reliability, scalability, and extensive features.
Patching an Oracle Database with BigFix involves three basic steps:
- Deploying an "Update" Fixlet as a Policy Action
- This action captures information about all databases in the oratab file (or Oracle services on Windows) along with their respective patch levels.
- Deploying a "Precheck" Fixlet
- This steps includes updating the Oracle opatch utility to the version required by the patch, and to verify the prerequisites (disk space, patch conflicts, etc) for installing the patch.
- Deploying a "Patch" Fixlet
- The final step is to deploy a "Patch" Fixlet that installs both the binary and database patches.
Note: On non-Windows systems, the Update Fixlet can only capture
information about databases that are in the oratab file. If a database is not in the
oratab file, the patch Fixlet will not include it in the patching process.
Note: The Precheck and Patch Fixlets are specific to OS, Oracle
version, and specific patch level such as "OracleDB 19c on Linux - 2023-10 Patch".
(There are also Fixlet variants specific to ASM and RAC.) When a Precheck or Patch
Fixlet is deployed to a database server, it performs prechecks or patches on all the
targeted databases on that server. For example, "OracleDB 19c on Linux - 2023-10 Patch"
will patch all 19c databases on the server to 2023-10, that are listed in the oratab
file.
Note: The Precheck Fixlet is designed to be run multiple times as
needed prior to patching. Running the Precheck Fixlet allows you to verify that all the
prerequisites are met before deploying the corresponding Patch Fixlet.