How to Check Oracle Version
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 Check Oracle Version
Patching
How to Patch Grid and Oracle Home 12c (PSU 32917447)
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 Grid and Oracle Home 12c (PSU 32917447)
How to Resolve OPATCHAUTO-72030: Cannot execute in rolling mode, as CRS home is shared
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 Resolve OPATCHAUTO-72030: Cannot execute in rolling mode, as CRS home is shared
How to Patch Oracle Database 19c on Linux (DBRU 19.9)
Here are steps to apply Database Release Update (DBRU) 19.9 (p31771877) on Oracle database 19.3. Upload Patches Update Opatch utility Backup Oracle Home Apply Release… Read More »How to Patch Oracle Database 19c on Linux (DBRU 19.9)
How to Resolve Opatchauto Failed with Error Code 42
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 »How to Resolve Opatchauto Failed with Error Code 42
How to Resolve OPATCHAUTO-72043 Error Message
OOPATCHAUTO-72043: Failed to create bundle patch object When I tried to apply a bundle patch, I got errors like this: [root@primary01 ~]# opatchauto apply /home/patches/31307682… Read More »How to Resolve OPATCHAUTO-72043 Error Message
How to Resolve opatchauto must run from one of the homes specified
opatchauto must run from one of the homes specified Met an error when I tried to apply a patch by root. [root@primary01 ~]# opatchauto apply… Read More »How to Resolve opatchauto must run from one of the homes specified
How to Patch Oracle GoldenGate 12c
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 Oracle GoldenGate 12c
How to Patch RAC Database 12c
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 RAC Database 12c
How to Patch Grid and Oracle Home 12c
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 to Patch Grid and Oracle Home 12c