Database Migration Prerequisites

Prerequisites Required by the Source Database:

Source Database is discovered and visible in Enterprise Manager. For more information see: Discovery in Oracle Enterprise Manager Cloud Control Administrator's Guide.
Create a local directory with sufficient space to host the export dump file.
Write privilege to the directory where the export will be stored for the import database user.
Grant the DATAPUMP_EXP_FULL_DATABASE role to the export database user. This role grants the user performing the export additional privileges that aid Data Pump migrations:
- Perform Export operations outside the scope of their assigned schema.
- Monitor jobs that were initiated by another user.
- Export objects such as table space definitions that unprivileged users cannot reference.
Example of Datapump Export Full Database role grant:
```
SQL> GRANT DATAPUMP_EXP_FULL_DATABASE TO exp_user;
```

Prerequisites Required by the Destination Database

An Oracle Cloud Account is required for the destination Autonomous Database and storage of the uploaded dump files. For more information see: About Oracle Cloud Accounts in Oracle Cloud Getting Started with Oracle Cloud Applications.
Destination Database is discovered and visible in Enterprise Manager. For more information see: Discover Autonomous Databases in Oracle Enterprise Manager Cloud Control Administrator's Guide for Oracle Autonomous Databases.
Wallet file to connect to Autonomous Database (automated from Enterprise Manager). For more information see: Discover Autonomous Databases in Oracle Enterprise Manager Cloud Control Administrator's Guide for Oracle Autonomous Databases.
Configure cloud credentials in the Autonomous Database for data import from the Object Store. For more information see: CREATE_CREDENTIAL Procedure in Oracle Cloud Using Oracle Autonomous Data Warehouse on Shared Exadata Infrastructure.
Write privilege to the directory where the import will be stored for the import database user.
Grant DATAPUMP_IMP_FULL_DATABASE role to the import database user. This role grants the user performing the import additional privileges that aid Data Pump migrations:
- Perform Import operations outside the scope of their assigned schema.
- Monitor jobs that were initiated by another user.
- Import objects such as directory definitions that unprivileged users cannot reference.
Example of Datapump Import Full Database role grant:
```
SQL> GRANT DATAPUMP_IMP_FULL_DATABASE TO imp_user;
```

Prerequisites Required by Enterprise Manager:

Enterprise Manager automatically downloads the latest version of Instant Client, however some older Operating System versions may not be compatible and a manual download maybe required, if this is the case follow steps outlined in: Upload Migration Tools.
Source Database and Host credentials. Host credentials need to be supplied for any operation which needs to log into the host and are mandatory for any job. Database credentials are used to make database management easier. For more information on setting up credentials see: Setting Up Credentials.
VPN connectivity or an existing connectivity between on-premises data center and destination service.

Note:
Destination will be the OCI data center for Autonomous Databases (required for calls to APIS and Autonomous Database connections)

In Enterprise Manager assign the following privileges to each corresponding target:

Required Privilege:	Target to Apply Privilege to:
Connect to Target	Source and Destination Database
Execute Command	Source Database Host
Configure Target	Destination Database
Execute Command	Monitoring Agent host of Destination Database
Create New or Existing Views	Named Credential
Create Any Software Library Entity	Software Library Entity
View Any Software Library Entity	Software Library Entity
Create	Deployment Procedure and Job System

For more information on how to grant privileges see: About Deployment Procedures and Granting Roles and Privileges to Administrators.

Additional Prerequisite Information for REST and EM CLI:

If you are planning to migrate using REST, you will need to upload the migration tools as part of the prerequisites follow the steps outlined in: Prerequisites for REST API Database Migration.
If you are planning to migrate using EM CLI, you will need to upload the migration tools as part of the prerequisites, follow the steps outlined in: Prerequisites for EM CLI Database Migration.