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.