Getting Started with Oracle Cloud Infrastructure Database Migration
Before you can start using Oracle Cloud Infrastructure Database Migration service and before migrating your databases, you must perform the following preparatory tasks:
- Create Database Migration policies in your tenancy.
- Create any dependent objects needed for the migration.
- Configure the source and target databases as required.
Before You Begin
Before you begin working with Oracle Cloud Infrastructure Database Migration, you must have an Oracle Cloud Infrastructure account with administrator privileges.
See Add a User with Oracle Cloud Administrator Permissions for details.
Creating Resources
Use the following instructions to create the resources that Oracle Cloud Infrastructure Database Migration operations depend on.
Configuring Policies
Oracle recommends using the first group of policies To let users manage connections, migrations, jobs, and networks as it has the required policies to go end to end.
Create a Compartment
If you don't already have a compartment, create a compartment in your tenancy.
For more information, see Working with Compartments.
Create a Virtual Cloud Network
Create a Virtual Cloud Network (VCN) with at least one subnet in the compartment.
The subnet must be regional, spanning all availability domains.
For more information, see VCNs and Subnets.
If you don't see your subnet listed, go back and check that it was created as a regional subnet. By default, the VCN wizard creates regional subnets.
Create or reuse an existing Database Migration user or a dynamic group
Create a user group to manage database connections, migrations, and jobs, and then add users in charge of database migrations to the group.
Take note of the group name. You will create policies for the group in Creating Resource Policies. For more information, see Managing Groups.
Create an OCI API Key Pair
Create an OCI API key pair if you intend to directly use the REST API, OCI Software Development Kits and Command Line Interface, or if you are installing the Database Migration agent.
Follow the instructions in Required Keys and OCIDs.
Select a Data Transfer Medium
- Data Pump via database link
- Data Pump via object storage
- Data Pump via file storage
See Creating a Bucket for details.
Make sure that the file system used for the Data Pump export directory has sufficient space to store Data Pump dump files.
Select or Create a Vault
Create a Vault and Create a Secret in a Vault.
Alternatively, select a vault when creating database connections. Create a key in the Master Encryption Keys to use with Database Migration. Optionally, you can create vault during database migrations.
Giving Permissions to Database Migration Users
Use IAM policies to grant certain capabilities to the Oracle Cloud Infrastructure Database Migration user group.
Previously, in Creating Resources you created a user group for Oracle Cloud Infrastructure Database Migration. Now you will configure group permissions so that members can manage Database Migration resources.
Configuring SUDO Access
You may need to grant certain users authority to perform operations using
sudo
on the source database servers.
To configure sudo
access for source database
servers:
If the source database server is accessed through SSH, then configure
sudo
operations to run without prompting for a password for the
database installed user and the root
user.
For example, if database installed user is oracle
, then
run sudo su - oracle
.
Note that the opc
user is a standard Oracle cloud user
that is used to access database servers, but you can use any privileged user that
has sudo
privileges.
For the root
user run sudo su -
.
Also, note that because the target database server is on the cloud only
any sudo
operations are configured already.
Accessing the Database Migration Service
You can access Oracle Cloud Infrastructure Database Migration using the Oracle Cloud Interface Console (a browser based interface), REST APIs, or Oracle Cloud Infrastructure Software Development Kits and Command Line Interface.
To access Database Migration using the Console:
-
Use a supported browser to access the Console.
See Signing In to the Console for details.
-
Enter your cloud tenant, user name, and password, when prompted.
-
Click Sign in.
-
In the upper-right corner of the window, select a region that offers the Database Migration service enabled; for example, US East (Ashburn).
Database Migration resources, such as database registrations, migrations, agents, and jobs, are region-specific. Therefore, you want to make sure that you select Database Migration in the region that contains the resources that you need.
-
From the navigation menu, select Database Migration.
The Migrations page for the Database Migration service is displayed.
Using Database Migration APIs
OCI Database Migration service APIs are documented at https://docs.oracle.com/iaas/api/#/en/database-migration/20210929/.
See REST APIs and Software Development Kits and Command Line Interface for more information about using REST APIs and the OCI Software Development Kits and Command Line Interface.