How to Install Oracle Database 19.18 on Linux
In this post, we'd like to directly install Oracle database 19.18 in a new database server. If you were looking for a procedure to patch… Read More »How to Install Oracle Database 19.18 on Linux
cfgtoollogs
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 Patch Oracle Database 19c on Windows (DBRU 19.14)
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 (DBRU 19.14)
Where is DBCA Log Location
DBCA Log Location Two locations that you can see the trace log of Database Configuration Assistant (DBCA). DBCA log location The file path and name… Read More »Where is DBCA Log Location
Where is NETCA Log Location
NETCA Log Location Two locations that you can see the trace log of Net Configuration Assistant (NETCA). NETCA log location The file path and name… Read More »Where is NETCA Log Location
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 Remove MGMTDB
Some DBA may consider to remove MGMT database because of resource consuming. I myself found that MGMT database is error-prone when we apply patches on… Read More »How to Remove MGMTDB