How to Install Oracle Database 19.18 on Linux
To prepare a database server well for Oracle 19c, you may refer to the post: How to Install Oracle Database 19c on Linux. In this… Read More »How to Install Oracle Database 19.18 on Linux
Patching
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 ?
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 Patch Oracle Database 19c on Solaris (DBRU 19.17)
Here are steps to apply Database Release Update (DBRU) 19.17 (p34419443) on Oracle database 19.3 on Solaris. Upload Patches Update Opatch utility Backup Oracle Home… Read More »How to Patch Oracle Database 19c on Solaris (DBRU 19.17)
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 Patch Oracle Database 19c on Windows (p33575656)
After installing Oracle Database 19c on Windows, we may need to upgrade the database regularly. Assuming that you have done the following items: OPatch utility… Read More »How to Patch Oracle Database 19c on Windows (p33575656)
How to Resolve No such file or directory in Patching GIRU
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 Resolve No such file or directory in Patching GIRU
How to Install OPatch on Windows
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 on Windows
How to Install OPatch
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 Install OPatch