Learn Oracle Database Upgrade - Oracle 11g to 12c upgrade

Start learning how to upgrade Oracle databases and learn hands-on approach step by step from Oracle 11G to Oracle 12c

What you'll learn
How to install Oracle Linux and windows on virtual box
Know the database upgrade process and overview
Prepare your servers for database upgrade
Perform 11201 to 11204 database upgrade
Master all the pre and post database upgrade phases
database upgrade from 11G to 12C
How to install Oracle 11G
Oracle install 12c
How to download 11G ,Patch,12C,Oracle linux

Requirements
Basic knowledge of Database Administration
Standard laptop / desktop for practicing course assignments
Windows / Mac / Linux PC, Minimum 8 GB RAM and 70 GB HDD Storage
Virtualization software VirtualBox – Create two machines (Linux,Windows)
OEL 7.6 / 7.6 ISO image file to install Linux on Virtual Box
Description
Hello everyone my name Zulqarnain Hayat and welcome to upgrade oracle 11g to 12c course This course is designed to give knowledge and skills needed to upgrade Oracle databases using Linux and windows platform. As a DBA, it’s your primary job to upgrade Oracle databases and when Oracle releases new versions. This course starts with Oracle 11g upgrade and further upgrade from 11g to 12c upgrade.

The course is mainly designed for working DBAs who are responsible to upgrade databases from 11g to 12c. Right now, as Oracle has released 12c database version, all the companies are moving to 12c Database version. This directly impacts DBAs where they have to showcase skills and upgrade the environment. This course we will go step by step.

Following are the high level order to upgrade from 11G to 12C using Linux.

Part- 1

High level steps to upgrade from Oracle 11G to 12C using Oracle Linux 7.4

Step-1 Download Oracle Linux 7.6 , Oracle 11G and 12C Software

Step-2 Install Oracle Linux 7.6 Step by Step

Step-3 Basic Host Configuration of Linux Server

Step-4 Setup Oracle Perquisites on Linux Server

Step-5 Install Oracle 11G Software

Step-6 Configure Listener using NETCA

Step-7 Create database TESTDB using DBCA

Step-8 Install Oracle 12C Software only

Step-9 Run Pre-upgrade SQL Scripts

Step-10 Upgrade 11G to 12C using DBUA

Step-11 Go Live

Part-2

Upgrade 11G to 12C using Windows platform.

Step-1 Download windows 2012 , Oracle 11G,Patch 11.2.0.4 and 12C Software

Step-2 Install windows 2012 Step by Step

Step-3 Install Oracle 11G Software on windows

Step-4 Install Oracle patch 11.2.0.4 Software on windows

Step-5 Install Oracle 12C Software only

Step-6 Run Pre-upgrade SQL Scripts

Step-7 Upgrade 11G to 12C using DBUA

Step-8 Go Live

Note: Each Step has own sequence of installation

Who this course is for:
Anyone who would like to learn Oracle Database upgrades
On job people, who are looking to become expert in Oracle Database upgrades
Anyone upgrading their current 11g database to 12c version