Patch Oracle before DBCA, Can We ?
Yes, the answer is positive. Usually, we patch Oracle home with one or more existing databases for routine software updates. However, for a new database… Read More »Patch Oracle before DBCA, Can We ?
datapatch
How to Patch Oracle Database 19c on Linux (DBRU 19.18)
Here are steps to apply Database Release Update (DBRU) 19.18 (REL-JAN230131, 34765931) to Oracle database 19c (19.3) on Linux. Upload Patches Update Opatch utility Backup… Read More »How to Patch Oracle Database 19c on Linux (DBRU 19.18)
How to Resolve DataPatch Error at line 0: Could not open logfile
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 DataPatch Error at line 0: Could not open logfile
How to Resolve ORA-20016: Unable to get the lock : get_pending_activity : 1
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 Resolve ORA-20016: Unable to get the lock : get_pending_activity : 1
How to Clone PDB with TDE
Before entering our topic, I assumed that you have already know how to clone a PDB to another CDB. In this post, I will show… Read More »How to Clone PDB with TDE
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 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 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
How to Resolve ORA-12560 on Windows Server
ORA-12560 In this post, I'll talk about 3 error patterns of ORA-12560 on Windows platform. Database service is stop Incorrect ORACLE_SID Reach limitation of PROCESSES… Read More »How to Resolve ORA-12560 on Windows Server