Start learning how to upgrade Oracle databases and learn hands-on approach step by step from Oracle 11G to Oracle 12c
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.
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
Upgrade 11G to 12C using Windows platform.
Step-1 Download windows 2012 , Oracle 11G,Patch 18.104.22.168 and 12C Software
Step-2 Install windows 2012 Step by Step
Step-3 Install Oracle 11G Software on windows
Step-4 Install Oracle patch 22.214.171.124 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