This course builds your capability to install Oracle Database 19c Grid Infrastructure and Database software. You’ll cover interactive, silent and RPM-based installations, use tools such as the Database Upgrade Assistant and AutoUpgrade, manage Oracle Restart, complete post-upgrade tasks, and migrate data with DataPump.
Oracle Database 19c Install & Upgrade
Optimise the performance of your Oracle databases
Gain the insight and skills to manage database modernisation with precision and confidence. You’ll explore the latest installation options, upgrade pathways and post-deployment practices, enabling you to streamline processes and reduce risks.
Learning objectives
- Explore multitenant architecture
- Install Grid Infrastructure
- Perform silent and interactive installs
- Use the Database Configuration Assistant
- Set up Oracle Restart
- Plan for database upgrades
- Use DBUA and AutoUpgrade
- Complete manual upgrades
- Tackle post-upgrade tasks
What you’ll learn
Develop practical, ready-to-use skills that enable you to manage Oracle Database installations and upgrades. From understanding multitenant architecture to exploring installation methods, upgrade tools, and data migration strategies, you’ll gain the skills to manage each stage of the process efficiently and in line with best practice.
Silent and interactive installation
Understand how to install Oracle Database software using both interactive and silent methods. Learn how to use Oracle’s Universal Installer for hands-on setup, and silent mode with response files for repeatable, scriptable installs, ideal in enterprise environments. You'll also cover newer options such as RPM installations and image-based client installs. These approaches not only streamline your setup process but give you the flexibility to meet the requirements of different systems and business needs.
Upgrade preparation
We’ll take you through Oracle’s upgrade process step-by-step, from assessing compatibility and running pre-upgrade checks, to performance testing and backup planning. You'll work with key tools like the Pre-Upgrade Information Tool, ORAchk and Oracle’s own upgrade utilities. Be equipped with the skills to reduce risk, avoid downtime and make your upgrade run smoothly.
Database creation with DBCA
Discover how to use the Database Configuration Assistant (DBCA), a key tool for creating Oracle databases. The course covers interactive and silent installation methods using response files, preparing you for both individual builds and repeatable, standardised deployments. You'll learn how to choose the right storage options, database type, character sets and design templates. Whether creating new databases or cloning existing environments, you’ll gain a flexible, repeatable process for database creation that can be applied effectively in operational settings.
What’s included
- 2 days of instructor-led training in a live virtual classroom
- Interactive hands-on live labs
- All relevant course materials
- Course completion certificate
Key facts
Ideal for
DBAs looking to enhance their ability to install and upgrade Oracle databases to 19c, whether you’re working with 12cR2, 18c or 19c environments
Prerequisites
You should have attended the Oracle Database 19c Administration, Oracle Database 18c Administration, or the Oracle Database 12cR2 Administration course, or have a good working knowledge of Oracle administration.
Learning experience
Our experienced trainers and interactive labs create a focused, practical environment – so you can put theory into practice from day one.
FAQs
Develop the skills to install and upgrade Oracle databases using a range of proven methods and tools. The course equips you to plan effectively, minimise risks, and deliver reliable, high-performing database environments that meet organisational needs.
What versions of Oracle are covered in the course?
The course references Oracle 12cR2, 18c and 19c, the versions most commonly used by organisations today. So, whether you’re dealing with older setups or preparing for the latest release, this course gives you the knowledge and techniques to manage installations and upgrades confidently.
Will I learn how to use the Oracle Database AutoUpgrade tool?
The course includes guidance on using the AutoUpgrade utility, covering how to prepare for an upgrade, run the tool in both interactive and silent modes, and manage post-upgrade tasks. You will also learn how AutoUpgrade can simplify complex migrations and reduce downtime.
What is Oracle Restart?
Oracle Restart is a feature that automatically manages and restarts key Oracle components, such as the database instance, listener, and other services, after a hardware or software failure. In this course, you’ll learn how to configure and use Oracle Restart to improve system resilience, particularly for standalone environments.
What our customers say
“The lecturer was amazing - so passionate and knowledgeable, which made the sessions really enjoyable and easy to follow. I learned a lot and felt supported throughout."
Kamila, Data Administrator - Retail / Hire
"Very well laid out and John does an amazing job of explaining things in detail.”
Operations Technical Service Analyst - Utilities
Why study with StayAhead
96% customer satisfaction
We combine experience and passion to deliver training that meets the highest standards
30+ years’ experience
Industry-leading specialists delivering high-impact IT training
Experiential instructor-led training
Courses are delivered by experienced instructors using hands-on, practical live labs