Real-World Oracle Migration Magic: 10g to 19c, Step by Step Guide

Posted on by Ahmed Abdel Fattah

Are you facing the daunting task of migrating an Oracle database across platforms and versions? Struggling to find a reliable, step-by-step resource that actually works in the real world? Look no further. This isn’t just another generic tutorial—it’s a battle-tested, hands-on guide born from a real-life customer project, meticulously crafted by an expert who’s been … Continue reading Real-World Oracle Migration Magic: 10g to 19c, Step by Step Guide

The system cannot find the batch label specified – execute_task when upgrading an Oracle Database

Posted on by Ahmed Abdel Fattah

I created a Windows batch script to upgrade and oracle database from 12.2 to 19.23 on Windows platform. The main script line is the following line (which is the main command to upgrade the Oracle Database):%ORACLE_19C_HOME%\bin\dbupgrade1 -n 4 >> %LOG_FILE% 2>&1 But when running the script, the script is error out when executing the above … Continue reading The system cannot find the batch label specified – execute_task when upgrading an Oracle Database

utltz_upg_apply script hangs while shutting down the Oracle Database

Posted on by Ahmed Abdel Fattah

I was upgrading one Oracle Database from 12.2.0.1 to 19.23 on Windows platform manually. While upgrading the time zone files (from 26 to 43) and running the utltz_upg_apply.sql it hangs while shutting down the database for the first time.This is the last line displayed in the log file:utltz_upg_apply is ready to update to RDBMS DSTv43 … Continue reading utltz_upg_apply script hangs while shutting down the Oracle Database

[DBT-20052] Database upgrade is not supported from Oracle Home with Oracle Home User “dbuser” to an Oracle Home with Windows Virtual Account.

Posted on by Ahmed Abdel Fattah

Background: A customer has an Oracle Database version 12.2.0.1 on Windows server. He asked to upgrade this database to 19c (19.17) on the same server. Procedure: I installed Oracle 19c (19.3) on a new oracle home on the same server.(During the installation I selected "Windows Virtual Account" as the Oracle Home owner) I applied the … Continue reading [DBT-20052] Database upgrade is not supported from Oracle Home with Oracle Home User “dbuser” to an Oracle Home with Windows Virtual Account.