Upgrade your journey: Migrate from 19c non-CDB onpremises to Oracle’s AI-powered 23ai CDB on OCI

ZDM 21.5 introduces physical migration with an in-flight upgrade, enabling seamless transitions for Oracle Databases. This feature supports the migration of 11.2.0.4 and 12c databases to Oracle Database 19c, as well as migrations from 19c source databases to Oracle Database 23c AI.

This document outlines how ZDM facilitates the migration and conversion of a source non-CDB 19c database into a pluggable database (PDB) while performing an upgrade at the target level. ZDM performs an initial migration using a temporary non-CDB target database for customers to migrate and upgrade a non-CDB database. Upon completing this initial phase, ZDM leverages AutoUpgrade to convert to multitenant and upgrade the database to the desired version.

This guide is specifically tailored for migrating on-premises non-CDB databases running version 19c from a Linux platform to the Oracle Base Database System 23c AI CDB.

?Following are the properties and details of Source and Target environments.?

Source and Target Database Requirements

1.?????? Source DB should be archive log mode.

2.?????? If the source database is on 12c Release 2 and later, TDE needs to be enabled. Please ensure WALLET_TYPE is set to AUTOLOGIN or PASSWORD.

3.?????? The parameter DB_UNIQUE_NAME must be different on both the source database and the target database.

4.?????? Target DB should be created before the migration.

5.?????? Provision an ORACLE HOME at target server same as source DB HOME version.

ZDM Server Preparation and Installation

Provision a dedicated compute host for the ZDM software installation. The host where the ZDM software is installed is referred to as the ZDM Service Host. The following prerequisites must be met on the host:

• Oracle Linux 8
• 100 GB of free storage space.
• No Oracle Grid Infrastructure running on it.
• Possible to connect to source and target database (servers).

The ZDM software can be:

• Installed manually on-premises.
• Installed manually on OCI compute

1.?????? Provision a compute instance on OCI with Oracle Linux 8 image and boot volume size of 200GB.?

2.?????? Connect to the compute instance through putty.

3.?????? Extend the file system to make the 200 GB available. As root user

4.?????? Create a new group, user, and the needed directories. As root user

5.?????? Install the required software packages. As root user

6.?????? Download the ZDM software version 21c (zdm21.5.zip) and copy the zip file to the ZDM host to /home/zdmuser/zdminstall/ directory.

Change the owner of the zip file to zdmuser. As root user

7.?????? Install the ZDM software. As zdmuser

8.?????? Start ZDM and check the status. As zdmuser

9.?????? Create an SSH key pair for zdmuser. This will be used later to log in to the source and target database server via SSH. Keep the defaults

10.?? Create an Authentication Token for your OCI user, from the user’s details page,

Click on?Auth Tokens?and then on?Generate Token. Enter a?Description?and click on?Generate Token.?Copy?this token for your records as it will not be shown again.

11.??Install the OCICLI command line tool as zdmuser which will be used to access the OCI resources, e.g. copy Data Pump dump file into Object Storage.

OCI CLI installation requires USER OCID, TENANCY OCID, HOME REGION

Please use these values as per your cloud tenancy and keep the other parameter values as default.

12.?? Upload the API signing public key to OCI user in cloud tenancy from the ZDMHOST?

?From Cloud tenancy user’s page, click on API Keys and Add API Key. Choose Paste Public Key, paste the output from above command, and click Add.?

?13.?? Create a Standard Object storage bucket in the OCI Tenancy using CLI or OCI Console.?

14.?? Connectivity from ZDMHOST to Source & Target DB servers. Copy the SSH key from the ZDMHOST as ZDMUSER to the Source and Target as created in the Step-9.

15.?? Resolve the Hostnames of Source DB and Target DB to ZDMHOST by copying the hostname, IP & FQDN to /etc/hosts on ZDMHOST as root user

?16.?? Please open the ports 1521,22,443 on both source and target. For more details, please refer to Port requirements

?At the Target Server

?Create the ORACLE_HOME on the target DBCS instance with the same version as source.

Validate the DB HOME creation :

Preparing the Response File

1.?????? We will find a template for response file on ZDMHOST which contains a brief description of the parameters and values under $ZDM_HOME/rhp/zdm/template/.

2.?????? Copy the template response file to a different location for editing. Please refer the link to understand the usage of parameters Oracle Zero Downtime Migration 21.5 Documentation

3.?????? Please modify the parameters in the response as per the Source (on-Premise) and Target environment setup. Below is a sample response file shared with minimal parameters used to complete the migration with upgrade.

Evaluate the ZDM Configuration

Evaluate the ZDM configuration as below.

Modify the above parameters as per the Source and Target values. A sample evaluation command is given below

Check the status of the job as below

Perform the Actual Migration

Perform the actual migration using the below command. Modify the values as per the source and target environment