Master Oracle 11g to 12c Database Upgrade

Name: Master Oracle 11g to 12c Database Upgrade
Rating: 4.7 (478 reviews)

Learn to perform Oracle database upgrade from 11g to 12c with real-time approach

Created byArun Kumar

Last updated 7/2019

English

English [Auto],

What you'll learn

Know the database upgrade process and overview
Real-time database upgrade phases
Prepare your servers for database upgrade
Perform 11201 to 11204 database upgrade
Perform 11204 to 12101 database upgrade
Master all the pre and post database upgrade phases

Course content

4 sections • 13 lectures • 2h 34m total length

Before you start0:18
Oracle upgrade overview11:25
Identify Oracle versions by major release, maintenance release, and numbers, and use the upgrade matrix to plan upgrades from 11g to 12c, including critical patch updates and patch set updates.
Oracle real time upgrade process17:42
Learn how Oracle upgrades affect base and dictionary tables while preserving user data, plan pre, during, and post upgrade steps, coordinate with application teams, and perform PoC and backups.

Oracle 11201 to 11204 upgrade steps11:44
master the manual upgrade from 11g to 12c, including pre-upgrade backups, os-level copies of the Oracle home, and utlu112i validation, then install 12c in a new home.
11201 to 11204 prepare for upgrade11:56
Prepare for the 11g to 12c upgrade by backing up the database, verifying space and Oracle home details, and performing pre-upgrade validation before running required scripts in parallel.
11201 to 11204 pre-upgrade phase25:53
Copy the 11.2 and 11.4 binaries from Windows to Linux, install 11.2.0.4 in /u02, run the pre-upgrade utility, disable flashback, and purge the recycle bin in preparation for upgrade.
11201 to 11204 database upgrade phase11:32
Begin the upgrade by copying the DBS and network folder from the old Oracle home to the new. Set Oracle_home to the new location, then start sqlplus and run cat_upgrade.sql.
11201 to 11204 post-upgrade phase17:28
Upgrade Oracle from 11g to 11.2.0.4 and master the post-upgrade phase: start the database normally from the correct Oracle home, run the post-upgrade script, and verify with the status tool.

11204 to 12101 prepare for upgrade6:12
Upgrade 11g to 12c in a new Oracle home, migrating spfile entries. Back up, verify disk space, and run three scripts for statistics, dictionary, and fixed objects.
11204 to 12101 pre-upgrade phase20:57
Install and configure a 12c normal database. Explain CDB and PDB concepts, run the pre-upgrade utility from the new Oracle home, and purge the recycle bin before upgrading.
11204 to 12101 database upgrade phase7:58
Copy the spfile and network admin from 11g to 12c home, set Oracle home and path, start sqlplus from 12c, and run the upgrade script to complete 56 phases.
11204 to 12101 post-upgrade phase11:02
Complete post-upgrade steps by starting the database in normal mode on 12.1 home and running utlu 12 one dot SQL to validate components, then update oratab to 12c home.

Requirements

Basic knowledge of Database Administration
Standard laptop / desktop for practicing course assignments
Windows / Mac / Linux PC, Minimum 8 GB RAM and 100 GB HDD Storage
Virtualization software VirtualBox – Create two machines
OEL 5.9 / 6.5 ISO image file to install Linux on Virtual Box

Description

Master Oracle Database Upgrade course is designed to give knowledge and skills needed to upgrade Oracle databases. As a DBA, its your primary job to upgrade Oracle databases as and when Oracle releases new versions. This course starts with Oracle 11g upgrade and further talks about 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.

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

Master Oracle 11g to 12c Database Upgrade

What you'll learn

Explore related topics

Course content

Introduction to Oracle Database Upgrade3 lectures • 29min

Oracle 11201 to 11204 Upgrade5 lectures • 1hr 19min

Oracle 11g to 12c Upgrade4 lectures • 46min

Summary1 lecture • 1min

Requirements

Description

Who this course is for: