OPatch

How to Install OPatch on Windows

by Ed Chen
January 12, 2022October 23, 2022

OPatch Windows Assuming that you have downloaded the latest OPatch from Oracle. Let's see current version of OPatch utility. C:\Users\Administrator>opatch version OPatch Version: 12.2.0.1.15 OPatch… Read More »

How to Install OPatch

by Ed Chen
January 12, 2022October 23, 2022

In this post, I'm trying to design the best practice to install OPatch. In fact, the procedure means to replace the old OPatch utility with… Read More »

How to Check Oracle Version

by Ed Chen
December 13, 2021June 29, 2022

Database Version Sometimes, you would like to determine what release of Oracle database you are operating on in order to take some other action you… Read More »

How to Patch Grid and Oracle Home 12c (PSU 32917447)

by Ed Chen
August 4, 2021October 20, 2022
2 Comments

In this post, I want to patch PSU 32917447 on grid and oracle home 12.1.0.2. Since I have talked about patching Grid and RAC database… Read More »

How to Patch Oracle Database 19c Steps

by Ed Chen
December 19, 2020October 14, 2022
2 Comments

Here are steps to apply Database Release Update (DBRU) 19.9 on Oracle database 19.3. 1. Upload Patches We should download the newest Opatch utility and… Read More »

How to Patch Oracle GoldenGate 12c

by Ed Chen
September 19, 2020October 14, 2022

Use the Latest OPatch First of all, we have to download the latest OPatch utility for GoldenGate. In this case, we downloaded OPatch 11.2.0.3.25 for… Read More »

How to Patch RAC Database 12c

by Ed Chen
September 16, 2020November 9, 2022

If you know how to patch a single-instance database, then you'll learn that patching a RAC database has some additional steps and risk after reading… Read More »

How to Patch Grid and Oracle Home 12c

by Ed Chen
September 12, 2020October 20, 2022

To patch a Grid infrastructure including Oracle home, we need to download the correct patch from My Oracle Support (MOS) for your current version of… Read More »

How OPatch Check Conflict

by Ed Chen
August 29, 2020October 14, 2022

Before you apply the new patch, you probably want to know whether the current configuration of Oracle home that conflict with the patch. Here in… Read More »

Opatch Prereq CheckConflictAgainstOHWithDetail

by Ed Chen
August 28, 2020October 14, 2022

Opatch Prereq CheckConflictAgainstOHWithDetail Always use opatch prereq checkconflictagainstohwithdetail command to check any conflict before patching. In which, the option CheckConflictAgainstOHWithDetail is pretty self-explanatory. checkconflictagainstohwithdetail =… Read More »