
Learn how to upgrade Oracle database from 11g to 12c on Linux and Windows, with a practical step-by-step guide covering download, installation, configuration, and upgrade sequencing.
Copy oracle software, extract and run the installer to install the Oracle software, create a listener, and set up a test DB with utf-8 configuration.
Enable the flash recovery area, create a recovery directory, and validate system objects before running upgrade scripts; review script outputs and fix as needed.
Download Windows 2012 and install it on a new 64-bit virtual machine, allocate 4 GB RAM, 50 GB disk, mount the ISO, and complete the installation.
Copy Oracle 11g software from the host to the VM, extract the zip files, and install Oracle 11g—select enterprise edition, default home, and default schema settings to create the database.
Apply Oracle 11g patch 11.2.0.4 and upgrade from 11g to 12c for DBAs. Unzip, run setup, follow prerequisites, reuse the same home, and upgrade the database from source to target.
Upgrade from 11g to 12c using pre-upgrade scripts, prerequisites, and the database upgrade assistant; follow step-by-step checks, manage Oracle Home, backups, and Enterprise Manager options.
Welcome! My name is Zulqarnain Hayat, and in this course, you will learn how to upgrade Oracle databases from 11g to 12c on both Linux and Windows platforms. This course is designed specifically for DBAs who are responsible for maintaining and upgrading Oracle environments. With the release of Oracle 12c, companies worldwide are upgrading their databases, and DBAs must have the knowledge and skills to perform these upgrades efficiently and safely.
The course provides step-by-step guidance for performing Oracle upgrades, covering everything from initial software installation to making the upgraded database live. On the Linux platform, you’ll learn how to download Oracle Linux 7.6 and Oracle 11g/12c software, install and configure the Linux server, set up Oracle prerequisites, install Oracle 11g, create databases using DBCA, configure listeners using NETCA, and finally upgrade to 12c using DBUA.
On the Windows platform, you’ll gain hands-on experience installing Windows Server 2012, installing Oracle 11g, applying patches, installing Oracle 12c, running pre-upgrade SQL scripts, and upgrading databases to 12c using DBUA.
By the end of this course, you’ll have the confidence and practical skills to perform Oracle 11g to 12c upgrades in real-world environments, on both Linux and Windows servers. This course is ideal for working DBAs, database administrators, and IT professionals looking to enhance their Oracle database upgrade skills and ensure smooth migrations to Oracle 12c.