15% off eLearning,10% off virtual courses- use code: NSWOCT25AUS

95583db9-fea0-40a3-8e10-bdf7aeb29d1c

Oracle Database 18c Install & Upgrade

Select your learning method

Learn essential skills
Course overview

Build the capability to install Grid Infrastructure, configure Oracle databases, and manage upgrades from earlier versions, during this Oracle Database 18c Install & Upgrade course. It is also aligned with the official Oracle curriculum, helping you prepare for the Oracle Database Administration II: 1Z0-083 certification exam. 

Strengthen Oracle 18c environments with advanced installation and upgrade skills

Understand the processes involved in upgrading Oracle 18c environments, from deploying Grid Infrastructure to configuring databases and managing migrations during this two-day course. You’ll also explore essential tools, including Data Pump, DBCA, and Oracle Restart, that help you improve efficiency, minimise downtime, and maintain secure, high-performance database systems. 

Learning objectives
  • Describe multitenant architecture to improve database efficiency 
  • Install Grid Infrastructure for dedicated Oracle environments 
  • Implement Oracle Database software using interactive and silent modes 
  • Configure databases with DBCA in both interactive and silent modes 
  • Use Oracle Restart to manage and maintain components effectively 
  • Plan and execute database upgrades with DBUA or manual methods 
  • Perform post-upgrade tasks to enhance performance and stability 
  • Move and import data efficiently with Data Pump 

What you’ll learn

Develop the skills to install Oracle Database 18c Grid Infrastructure, design and configure databases, and manage upgrades from previous releases. These capabilities will help you improve system reliability, minimise downtime, support business growth, and ensure your database environments remain secure, efficient, and adaptable to change. 

Managing Oracle Restart for improved reliability

Discover how to use Oracle Restart to keep your database services running smoothly after planned or unplanned outages. You’ll add and manage components, control startup and shutdown sequences, and apply updates with minimal disruption, for ensuring system stability and maintain high availability in Oracle 18c environments. 

Mastering Silent mode installations with Response Files

Learn how to perform silent Oracle Database 18c installations using preconfigured response files for consistency across deployments. You’ll automate setup tasks, reduce manual errors, and speed up installation in multi-server environments, helping your organisation save time while ensuring standardised, reliable configurations. 

Executing post-upgrade optimisation tasks

Understand the essential steps that should be taken after upgrading to Oracle Database 18c to maximise performance and stability. You’ll migrate to unified auditing, adjust deprecated parameters, and validate functionality, ensuring your upgraded databases run efficiently, securely, and in line with best practices. 

Migrating data with Oracle Data Pump

Gain practical experience of moving data between Oracle databases using Data Pump export, import, and network link features. You’ll streamline database consolidation, enable cross-platform migrations, and minimise downtime, which is critical for keeping business operations running smoothly during large-scale database changes. 

What’s included
  • Two days of instructor-led training in a live virtual classroom  
  • Interactive hands-on live labs  
  • All relevant course materials 

Key facts

Ideal for

Database administrators and IT professionals installing or configuring Oracle 12cR2 or 18c, upgrading earlier versions, and ensuring systems remain stable, efficient, and high-performing. 

Prerequisites

Oracle database administration experience plus completion of 12cR2, 18c, or 19c Administration course, or equivalent skills. Basic Linux/UNIX knowledge is recommended but not essential. 

Learning experience

Our experienced trainers and interactive labs create a focused, practical environment – so you can put theory into practice from day one. 

FAQs

Our two-day course will teach you how to implement Oracle Database 18c by deploying Grid Infrastructure, creating and configuring databases, managing upgrades, and migrating data for maintaining secure, high-performance business systems. 

What is the Oracle Database 18c Install & Upgrade course?

The Oracle Database 18c Install & Upgrade course teaches database administrators to install Grid Infrastructure, configure and create databases, and upgrade from earlier releases. You’ll also gain skills in using tools like DBCA, Oracle Restart, and Data Pump to ensure efficient, reliable, and high-performance Oracle database environments. 

What are the prerequisites for the course?

You should have practical experience in Oracle database administration and have completed the 12cR2, 18c, or 19c Administration course, or possess equivalent skills. Basic knowledge of Linux/UNIX is recommended but not essential, as the course is run on a Linux operating system. 

Does the course cover database upgrades from earlier versions?

Yes. The course includes planning, preparing, and performing upgrades to Oracle Database 18c from earlier versions. You’ll learn to use the Database Upgrade Assistant (DBUA) in interactive and silent modes, as well as manual upgrade methods, to suit different operational environments. 

Will I learn how to configure databases?

Absolutely. You’ll use the Database Configuration Assistant (DBCA) to create and configure databases in both interactive and silent modes. The course covers architecture selection, storage options, and character set configuration, enabling you to set up tailored, reliable databases for varied environments. 

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 

We're here to help
Speak to our learning experts

Not sure which course or study option is right for you? Get in touch with our team of advisors for personalised guidance and support throughout your learning journey.

Business transformation
Looking to develop your business or team?

Need to upskill your team? Our bespoke development solutions are designed to enhance team performance, retain talent, and drive organisational excellence. One of our development consultants would love to chat.

Quote request

Please complete the form to ensure your quote is accurate and we will contact you soon.

By submitting this form, you agree to ILX processing your data in line with our Privacy Policy. You can unsubscribe at any time by clicking the link in our emails or contacting us directly.

Page {{ step }} of 2

Back Next