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 -verbose
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 Resolve ORA-65144: ALTER SYSTEM DISABLE RESTRICTED SESSION is not permitted
ORA-65144 Tried to remove restricted mode from a newly cloned PDB, but it failed with ORA-65144. SQL> show pdbs CON_ID CON_NAME … Read More »How to Resolve ORA-65144: ALTER SYSTEM DISABLE RESTRICTED SESSION is not permitted
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)
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 ORA-12560 on Windows Server
ORA-12560 In this post, I'll talk about several error patterns of ORA-12560 on Windows platform. Database service is stop (SYSDBA) Listener service is stop (Normal… Read More »How to Resolve ORA-12560 on Windows Server