Note:

• This tutorial requires access to Oracle Cloud. To sign up for a free account, see Get started with Oracle Cloud Infrastructure Free Tier.
• It uses example values for Oracle Cloud Infrastructure credentials, tenancy, and compartments. When completing your lab, substitute these values with ones specific to your cloud environment.

Upgrade Oracle Database Cloud Service Database and Database System

Introduction

When you upgrade an existing Oracle Database environment (including installed components and associated applications) into a new release Oracle Database environment, the data dictionary for the database is upgraded.

There are different ways to upgrade to the latest release 19c of Oracle Database and Oracle provides multiple methods to upgrade on-premises and Oracle Cloud Infrastructure (OCI) environment.

• Database Upgrade Assistant (DBUA)
• Manual Upgrade
• Transportable Tablespaces
• Data Pump export/import
• Oracle Streams
• Oracle GoldenGate

We will use the OCI Console to upgrade Oracle Database Cloud Service database and database system (DB system).

Objectives

• Upgrade Oracle Database Cloud Service database and database system.

Prerequisites

• Oracle recommends to create manual backup of the database before upgrade.

Considerations

• The upgrade process will incur downtime on database systems, so this should be planned accordingly.

• As of today, while private IP addresses and hostnames are kept, the ephemeral public IP addresses will change.

• Avoid the launch of new virtual machine database systems within the same subnet during the upgrade process. There is a short time interval when private IP addresses and hostnames are freed, and it will block the upgrade process if another virtual machine database system uses the same IP address or hostname.

Upgrade using the OCI Console

1. The OCI Console has been redesigned to use a single execution page for updates and upgrades. Go to the Bare Metal, VM, and Exadata service home page, navigate to DB Systems, DB System details and click View in the newly displayed version information section.

   

   

   On the update screen, you will find database and database system updates and upgrades.

   

2. So, let’s first upgrade the database and database system to 19c and Oracle Linux version 8 (OL8). Select Run precheck to ensure there are no common errors detected and then “APPLY” to upgrade the database and virtual machine database system to 19c and OL8.

   

   Once “Run precheck” is completed successfully, we will go for an upgrade.

   

3. Keep a manual backup of this database and click Upgrade.

   

   

   

4. The database is upgraded from 12.1 to 19.21 successfully. Now, click View in the newly displayed version information section to upgrade a database system. We can see the database version details in general information in the version section.

   

   We can see the upgrade availability for the database system showing “Oracle Linux Server release 8 (OL8)”.

   

   

5. Click Run precheck to perform a precheck on the database system before the upgrade.

   

   Here, we can see the precheck in progress for the OS component with version OL8.

   

   The “precheck” has been completed successfully.

   

6. We need to have downtime for this database system while the OS is upgraded. Click Upgrade DB system to start the upgrade process. A Rollback option becomes available in the Update History if the upgrade is not successful.

   

   Now, we can see the database system and database both have been upgraded.

   

Related Links

• In-Place Upgrade for Database Cloud Service VM Database Systems

Acknowledgments

• Author - Aditya Kumar Srivastawa (Principal Cloud Architect)

More Learning Resources

Explore other labs on docs.oracle.com/learn or access more free learning content on the Oracle Learning YouTube channel. Additionally, visit education.oracle.com/learning-explorer to become an Oracle Learning Explorer.

For product documentation, visit Oracle Help Center.

---

Title and Copyright Information

Upgrade Oracle Database Cloud Service Database and Database System

F91864-01

January 2024

Copyright © 2024, Oracle and/or its affiliates.