[Oracle] How to patch a Database Oracle Home
- Red Hat Linux 7
- Oracle Database 12
- MYPATCH: patch to install
- MYPATCHDIR: directory where the unzipped patch is located
in this tutorial we are going to apply a patch to an existing Database Oracle Home.
First of all, unzip the patch:
unzip MYPATCH -d MYPATCHDIR
Next, just check for conflicts with already installed patches:
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir ./
Prereq "checkConflictAgainstOHWithDetail" passed.
This is the output when no conflicts are present. If there are conflicts, contact Oracle Support to request a Merge Patch.
Next, stop all the database instances running in that Oracle Home:
srvctl stop home -o $ORACLE_HOME -s /tmp/stop.txt
And then install the patch:
$ORACLE_HOME/OPatch/opatch apply ./ -local
Once finished, restart all database instances previously stopped:
srvctl start home -o $ORACLE_HOME -s /tmp/stop.txt
And check if the patch is correctly installed:
Optionally, some patches may require to run datapatch utility on all databases after installing the patch. Just launch the following command for every database instance on the patched Oracle Home:
That’s all, see you in the next tutorial!