My Oracle Support Banner

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

Last updated on OCTOBER 04, 2021

Applies to:

Autonomous Transaction Processing - Version NA and later
Autonomous Database Dedicated - Version NA and later
Autonomous Database on Shared Infrastructure - Version N/A and later
Autonomous Data Warehouse - Dedicated Infrastructure - Version N/A and later
Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


 Determine the suitability of migrating an Oracle database instance to one of Oracle's Cloud offerings.


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
 Cloud Premigration Advisor Tool (CPAT)
 Downloading and Extracting CPAT from the Zip File
 Basic Usage Notes and Requirements
 Invoking CPAT
 Required and Optional Environment Variables
 Required Command Line Switches
 Optional Command Line Switches
 Required Privileges
 Advanced Usage Notes
 Target Cloud Values
 Migration Methods
 Connection Strings
 Scope of CPAT Checks
 Full vs Schema "Mode"
 FULL mode
 SCHEMA mode
 Controlling CPAT's Mode
 Additional Mode Notes
 Fetching Target Instance Properties for use in Source Instance Analysis
 Interpreting CPAT Report Data
 Why are Checks sometimes marked as "skipped"
 Checking for a Updated Version of CPAT
 Updating CPAT in a Zero Downtime Migration Home
 Using CPAT with Other Tooling or Scripted Processes
 CPAT Shell Script Exit Codes
 Security Notes

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