Patching

How to Resolve DataPatch Error at line 0: Could not open logfile

by Ed Chen
May 4, 2022May 19, 2022

apply: WITH ERRORS When we are close to the end of datapatch, we saw an OS error: Error at line 0: Could not open logfile.… Read More »

How to Resolve ORA-20016: Unable to get the lock : get_pending_activity : 1

by Ed Chen
May 2, 2022June 22, 2022

ORA-20016 Tried to do a datapatch (SQL apply) against a database, but it failed with ORA-20016: Unable to get the lock. C:\Users\Administrator>datapatch -verbose ... Error:… Read More »

How to Patch Oracle Database 19c on Windows (33575656)

by Ed Chen
April 8, 2022June 22, 2022

Assuming that you have done the following items: OPatch utility has been replaced with the newest one. The bundle patch p33575656 (19.14.0.0.220118) we're going to… Read More »

How to Resolve No such file or directory in Patching GIRU

by Ed Chen
February 23, 2022March 6, 2022

Tried to patch the newest GIRU (Grid Infrastructure Release Update) by grid, but it failed with No such file or directory (Exit code 255). [grid@primary01… Read More »

How to Replace OPatch on Windows

by Ed Chen
January 12, 2022June 3, 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 Replace OPatch

by Ed Chen
January 12, 2022March 17, 2022

In this post, I'm trying to design the best practice to replace the old OPatch utility with the new one, either in single-instance or RAC… Read More »

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

by Ed Chen
August 4, 2021April 12, 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 Resolve OPATCHAUTO-72030: Cannot execute in rolling mode, as CRS home is shared

by Ed Chen
March 24, 2021September 25, 2021

OPATCHAUTO-72030 When I patched grid infra (GI) and oracle home (OH) of an Oracle RAC database by opatchauto, I got OPATCHAUTO-72030: Cannot execute in rolling… Read More »

How to Patch Oracle Database 19c Steps

by Ed Chen
December 19, 2020July 2, 2022

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 Resolve Opatchauto Failed with Error Code 42

by Ed Chen
October 14, 2020September 25, 2021

Before reading this post, please refer to the known issues in the README document of your patch first, maybe you can find a solution there.… Read More »