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