Database Upgrades and Migrations

Hands-free upgrades

Use the Quickstart to plan the upgrade. Upgrade from 11.2.0.4 and higher with the AutoUpgrade utility using one command and one configuration file, after installing the new binaries and configuring the new release Oracle home(s).

• Database Upgrade Quick Start Guide (PDF)
• Upgrade and Migrate Oracle AI Database (PDF)
• Download the AutoUpgrade utility
• Download the AutoUpgrade JSON Checksum
• Please see My Oracle Support (Doc ID 2485457.1) for release notes.
• Learn more about Oracle AI Database upgrades
• Database Server Upgrade/Downgrade Compatibility Matrix

Cloud Migration Advisor

The Oracle Cloud Migration Advisor (CMA) is the best tool for advising you about your migration to Oracle Autonomous AI Database, Oracle Exadata Cloud at Customer, Oracle Exadata Cloud Service, and other Oracle Cloud Infrastructure (OCI) Database services—and more.

CMA collects database metadata details about your current Oracle database environment, including patch levels. (No business data or customer information is collected.) CMA uses this database metadata to provide detailed technical advice about possible migration targets and methods.

Choose and download the most appropriate metadata collection method for your situation:

• Cloud Pre-Migration Advisor Tool (CPAT) (Use Oracle SQLcl MIGRATEADVISOR Command, see Jeff Smith's blog post — or if you can't use SQLcl, Download CPAT from My Oracle Support Note 2758371.1 — Documentation (PDF))
• SQL CSV script (Download — Documentation (PDF))
• Oracle Enterprise Manager script (Download — Documentation (PDF))
• Spreadsheet (Download — Documentation (PDF))

The documentation for each method describes how to collect the metadata and share it with your Oracle advisor.

Move to Autonomous AI Database

1. Estate Explorer

Identify and map potential targets for the migration to Oracle ADB.

• Learn more about Estate Explorer

2. Cloud Pre-Migration Advisor Tool (CPAT)

CPAT analyzes your source Oracle database metadata for compatibility with your intended Oracle Autonomous AI Database target and migration method. It suggests a course of action to resolve each potential incompatibility it finds in the source.

• Learn more about CPAT

3. Cloud Migration Advisor (CMA)

CMA analyzes the CPAT report from your source database and provides detailed technical advice about likely migration targets and methods.

• Learn more about CMA

The tool gives you technical advice on the various migration options:

• Database Migration Service (DMS)
• Zero Downtime Migration (ZDM)
• Oracle Autonomous DB Migration Automation
(In beta status currently, contact us).

Move data and metadata among Oracle databases and Oracle Cloud

Consider Data Pump best practices for high-speed, parallel export and import of data and metadata. Migrate faster and easier with Data Pump Full Transportable Export and Import. Adhere to Oracle Cloud migration best practices.

• Best Practices for Oracle Data Pump (PDF)
• What's New in Oracle Data Pump (PDF)
• Oracle Data Pump: Full Transportable Export/Import (PDF)
• The Latest Version of the Cloud Pre-Migration Advisor (CPAT)

• Oracle AI Database utilities guide
• Move to Oracle Cloud
• Load data into Oracle Autonomous AI Transaction Processing (ATP)
• Load data into Oracle Autonomous AI Lakehouse
• Oracle Zero Downtime Migration home page
• Migrate with SQL Developer
• Oracle Enterprise Manager Database Migration Workbench
• OCI Database Migration

Fast external data ingest

Perform high-speed data filtering and loading from external files into Oracle database tables using Oracle SQL*Loader Express Mode Loading. Access data in external sources as External Tables from SQL, PL/SQL and embedded SQL.

• SQL*Loader in Oracle AI Database technical brief (PDF)

Hands-On Lab Training

Hitchhiker's Guide for Upgrading to Oracle AI Database
Practice, explore, and learn about database upgrade and migration to Oracle AI Database with end-to-end application performance testing. Unplug/plug and migrate to Oracle Multitenant. Use the most helpful performance tuning features, including SQL Plan Management, SQL Tuning Advisor, SQL Performance Analyzer, and more. Discover useful performance features and best practices.

Datapatch: Patch Me if You Can
If you patch your Oracle AI Database in-place, in the existing Oracle Home, you should check out this lab. Discover the differences between in-place and out-of-place patching and try it for yourself. See what needs to be rolled back and how datapatch works.

Data Pump: Cross-Platform Migration
Data Pump full transportable export/import (FTEX) combines the speed of transportable tablespaces (xTTS) with a much easier process for transporting metadata and data from an installed database. It provides a fast migration with the flexibility to change endianness, data layout, character set, encryption, and compression. Try it out and learn how to migrate your database with the PERL V4 scripts.