Background: I was upgrading an Oracle Database version 12c(12.2.0.1) to version 19c (19.24) on Microsoft Windows.This is a manual command line line upgrade ( I didn't use DBUA).I started by doing some preparation tasks like::: Task #1: Run pre-upgrade checks:: Task #2: Run the preupgrade_fixups.sql:: Task #3: Connect to sqlplus and create pfile from pfile:: … Continue reading O/S-Error: (OS 5) Access is denied while upgrading Oracle 12c Database to 19c
The system cannot find the batch label specified – execute_task when upgrading an Oracle Database
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
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
After Oracle Database Upgrade to 12.2, Database Express Did not work
I upgraded one database from 11.2.0.4 to 12.2.0.1 on one Solaris Sparc server. After that I configured the Enterprise Manager Database Express, but when I tried to access it, I got the following error: For more information about Oracle Enterprise Manager Database Express, please refer to my post:https://ahmedfattah.com/2018/10/14/oracle-enterprise-manager-database-express-12c-overview/ Environment: Oracle Solaris 11Oracle Restart 12.2.0.1Oracle Database … Continue reading After Oracle Database Upgrade to 12.2, Database Express Did not work
What is the difference between Oracle RAC One Node and Oracle RAC?
https://www.youtube.com/watch?v=ZM6ckWFlyeM ThanksAhmed
Oracle Database 32-bit Funny Migration to 64-bit
Objective: Migrating one 11.1.0.7 32-bit database that resides on an old Windows 2008 (32-bit) (4GB memory) to Windows 2008 64-bit (no upgrade) on a brand new server with 64GB memory. {At 2017 and still there is 11.1.0.7 database ==> yes there is!} Introduction and Background I have a client with the following very old environment: … Continue reading Oracle Database 32-bit Funny Migration to 64-bit
Oracle Database Upgrade to 12c (In a Fail Safe Environment)
This a step-by-step detailed procedure for upgrading one Oracle Database 11gR2 (11.2.0.4) on Windows Server 2012 to the latest version 12c (12.1.0.2) with the latest available Windows Bundle Patch. The database is configure with Fail Safe (Active/Passive) cluster to provide some sort of high availability. This is an actual live upgrade for one of my … Continue reading Oracle Database Upgrade to 12c (In a Fail Safe Environment)
Ahmed AbdelFattah Blog ! 