Learn Oracle Database Upgrade - Oracle 11g to 12c upgrade
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
Course content
- Preview05:09
- Preview04:09
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
Instructor
I have done Master in Computer science (IT) and additionally I have more than 17 years of professional experience UNIX administration, Oracle database administration with different flavors (Solaris, Linux, Oracle Linux, Red Hat) and working as role Database specialist.I have completed command over following functions and skills.
Key Skills:
· Oracle Database Administration
· MS SQL Server Administrations
· MYSQL/MariaDB Administration
· Sun Solaris Administration (Certified)
· Linux Administration (Red Hat ,CENTOS,UBUNTU)
· Oracle Application Server Administration
· Banner UDC technology stack DBA track
· Application Administration (LAMP,LEMP)
· Oracle EBS Administration
· Oracle Database Administration (RAC, Data Guard)
· Oracle Business Intelligence Administration
· Hyperion /ESBASE/WEB LOGIC
· Windows Server Administration
· Oracle Data Warehouse Builder
· SQL Server Administration
· Project Management
· Problem solving skills and approach
· Systems audit and control
· Oracle OAM 11G,OSSO 10G EBS R12
· Data Center Design and Implementation
· VMware Infrastructure
· EMC Storage and Legato Networker Administration