If you're an experienced Oracle DBA who wants to boost your skillset or take on more responsibility, this course is ideal. Over two immersive days, you’ll learn with plenty of practical activities as you try out new skills to install 12cR2, set up Grid Infrastructure and carry out upgrades from older versions. Â
15% off eLearning,10% off virtual courses- use code: NSWOCT25NZ
View courses
4cd043ec-6e30-4874-aa86-43b714e91136
Oracle Database 12cR2 Install & Upgrade
Select your learning method
Learn essential skills
Course overview
Confidently install and upgrade Oracle 12cR2
In this practical, two-day course, you'll explore how to install and upgrade Oracle databases using Grid Infrastructure, multitenant tools, DBCA, silent installs and data migration techniques. Led by expert tutors, you’ll be applying your knowledge as you go in our live lab setup to use right away in work projects and to create stronger career development. Â
List of learning objectives:
- Set up Grid Infrastructure for standalone serversÂ
- Install Oracle 12cR2 using silent installation methodsÂ
- Deploy databases using the Database Configuration AssistantÂ
- Configure and control services with Oracle RestartÂ
- Plan and validate database upgrade readinessÂ
- Execute upgrades via DBUA or manual stepsÂ
- Perform all required post-upgrade configuration tasksÂ
- Transfer data sets using Oracle Data Pump utilitiesÂ
What you’ll learn
Across two proactive days, you’ll master the full lifecycle of installing and upgrading Oracle Database 12cR2 from planning and prerequisites through to post-upgrade optimisation. You’ll gain hands-on experience with essential DBA tools and utilities, so you can confidently replicate the process in your own production environment.Â
Creating databases with DBCA
You’ll explore how to create databases with the Database Configuration Assistant (DBCA) in both guided, interactive mode and automated silent mode. You’ll learn how to select between CDB (container) and non-CDB databases, choose the right storage method, configure character sets, and set the NLS_LANG parameter. You’ll also practise using response files for consistent, repeatable builds and explore how to create reusable design templates for future deployments.Â
Oracle Restart
Oracle Restart is an invaluable tool for ensuring high availability on standalone servers. In this course, you’ll learn to configure it to automatically monitor and restart key Oracle components after a system or process failure. You’ll discover how to start, stop and manage services, and see how the ohasd daemon underpins Restart operations. We’ll also look at adding and managing components in Oracle Restart and applying patches to the 12.2 home without disrupting service availability.Â
Pre-upgrade and post-upgrade tasks
Upgrades are most successful when planned and validated carefully. You’ll practise the entire upgrade lifecycle: assessing supported upgrade paths, running the Pre-Upgrade Information Tool, checking for compatibility with ORAchk, and creating a new Oracle home. You’ll perform upgrades using both DBUA and manual methods, handle failed upgrade recoveries, and complete post-upgrade actions such as enabling unified auditing, managing deprecated features, and validating performance. By the end of the course, you’ll know how to deliver a smooth upgrade process that minimises downtime and disruption.Â
What’s included
- Two full days of expert-led online trainingÂ
- Live lab access to practise what you learnÂ
- Digital course resources to keepÂ
- Step-by-step install and upgrade walkthroughsÂ
- ILX certificate on course completionÂ
- Practical migration and upgrade scenariosÂ
Key facts
Ideal for
Oracle DBAs who want to install or upgrade 12cR2 databases in real-world environments.Â
Prerequisites
Some hands-on experience with Oracle database admin is recommended. Familiarity with Linux helps, but we’ll support you if you’re new to it.Â
Learning experience
Our experienced trainers and interactive labs create a focused, practical environment – so you can put theory into practice from day one.Â
FAQs
Taught by ILX’s Oracle specialists, this two-day course gives you valuable experience in installing and upgrading Oracle 12cR2. From Grid Infrastructure right through to DBUA and manual upgrades, you’ll enhance your technical skills with proactive exercised in our live lab setting.Â
Will I get to practise both interactive and silent installations?
Yes, absolutely. You’ll start by using the Oracle Universal Installer in its guided, interactive mode, ideal for getting familiar with the process. Then we’ll switch to silent installations using response files, which is a great way to streamline setups in production environments.Â
Will I learn to install Oracle Grid Infrastructure?
Yes. The course includes a full walkthrough of installing and configuring Oracle Grid Infrastructure for standalone servers, including setting prerequisites, creating the required directories and groups, configuring ASM storage, and enabling Oracle Restart for high-availability service management.Â
Is Data Pump migration covered in this course?
Yes. You’ll migrate databases using Oracle Data Pump, including full database transport and network-based imports. We discuss when migration is preferable to direct upgrade, and you’ll practise reducing downtime during the process.Â
Will I learn how to roll back if an Oracle database upgrade fails?
Yes. The course includes guidance on handling upgrade failures and safely rolling back to a stable state. You’ll practise identifying and resolving common errors, restoring backups, and re-running upgrade processes after making corrections. This ensures you can recover quickly and minimise downtime if an upgrade in your live environment does not go as planned.Â
What our customers say
‘The instructor was particularly good and very knowledgeable and anything he didn't know he would investigate and come with the explanation. That is not my first class with him and one of the reasons I actually book with this company.’Â
Caroline, GovernmentÂ
‘Very well laid out and John does an amazing job of explaining things in detail.’Â
Ali, Operations Technical Service Analyst - UtilitiesÂ
Why study with ILX
500,000+ learners
Join the half a million learners developing their skills with our trainingÂ
5,000+ businesses
A trusted partner to thousands of organisations worldwideÂ
96% customer satisfaction
Our passionate team goes above and beyond to support customer needsÂ
Quote request
Please complete the form to ensure your quote is accurate and we will contact you soon.
For the best prices, get in touch!