
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.
Download and install the required Oracle software with proper licensing and 64-bit options. Access Linux and Windows packages and patches for upgrading from 11g to 12c.
Download and install Oracle Linux 7.6 in a new VM, configure language, keyboard, time zone, static IP, DNS, hostname, and firewall, and select server with GUI packages.
Follow an automatic Oracle installation process that covers prerequisites, yum-based package installation, RDBMS startup steps, and unzipping the base software files.
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.
Install Oracle 12c software by extracting the installer, setting environment variables, and running the Oracle installer to configure language, enterprise edition, and post-install security checks.
Enable the flash recovery area, create a recovery directory, and validate system objects before running upgrade scripts; review script outputs and fix as needed.
Upgrade Oracle database from 11g to 12c using the upgrade wizard, with a restore point and recovery options, completing in about 20–30 minutes.
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.
install oracle 12c software only by selecting english language, choosing the oracle home location, and using the built-in windows account in a test environment.
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.
Master the Oracle 11g to 12c upgrade for DBAs in a single revised lecture, covering upgrade strategies, compatibility considerations, and best practices.
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.