My Oracle Support Banner

Cloud Premigration Advisor Tool (CPAT) Analyzes Databases for Suitability of Cloud Migration (Doc ID 2758371.1)

Last updated on JUNE 26, 2024

Applies to:

Oracle Autonomous Database - Shared - Version N/A and later
Oracle Autonomous Database - Dedicated - Version N/A and later
Autonomous Transaction Processing - Version NA and later
Autonomous Database Dedicated - Version NA and later
Autonomous Database Serverless - Version N/A and later
Information in this document applies to any platform.

Goal

The Cloud Premigration Advisor Tool (CPAT) helps you evaluate an existing Oracle database for compatibility with Autonomous Database (ADB.) Using CPAT before migrating to ADB makes assessing your source database easier and faster!  CPAT removes much of the legwork of identifying potential user actions, prioritizing their importance, and suggesting resolutions. Oracle recommends using CPAT to accelerate your migration to Oracle Cloud.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
 Cloud Premigration Advisor Tool (CPAT)
 Downloading and Extracting CPAT from the Zip File
 Supported Database Versions
 Recent Changes to CPAT
 Basic Usage Notes and Requirements
 Running CPAT
 Required and Optional Environment Variables
 Required Command Line Switches
 Required Privileges
 Best Practices using Optional Command Line Switches
 Fetch Target Instance Properties for Use in Source Instance Analysis
 Limit the Analysis Done by CPAT Appropriately
 Generate the JSON Report Even if You Do Not Need It and Always Save the Log File
 Command Options that Help with Generating "What If" Scenarios
 Limiting the Amount of Data in Reports
 Additional Usage Notes
 Target Cloud Values
 Automatic Detection of Target Cloud
 Migration Methods
 Connection Strings
 Analyzing Multiple PDBs in a CDB
 Generating "Fixups" for Checks That Do Not Pass
 Scope of CPAT Checks
 Full vs Schema "Mode"
 FULL mode
 SCHEMA mode
 Controlling CPAT's Mode
 Additional Mode Notes
 Interpreting CPAT Report Data
 Relevant Objects Included for Checks in CPAT Reports
 Why are Checks sometimes marked as "skipped"
 Checking for a Updated Version of CPAT
 CPAT Integration with Other Oracle Products
 Updating CPAT in a Zero Downtime Migration Home
 Using CPAT with Other Tooling or Scripted Processes
 CPAT Shell Script Exit Codes
 Security Notes
 Summary
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.