Create an Oracle data source

You must configure data sources before you create a data migration project. To migrate data from or to an Oracle database, you must create the Oracle database as the source or destination data source. This topic describes how to create an Oracle database as a data source in OceanBase Migration Service (OMS).

Procedure

1. Log on to the OMS console.

2. In the left-side navigation pane, click Data Source Management .

3. On the Data Sources page, click New Data Source in the upper-right corner.

4. In the New Data Source panel, select Oracle for Data Source Type.

5. Specify the following parameters.

   Parameter	Description
   Data Source Identifier	The name of the data source. The name must be 1 to 32 characters in length and can contain Chinese characters, digits, and case-sensitive letters.
   Region	Select the region where the data source resides from the drop-down list. The region is the value that you set for the cm_region parameter when you deploy OMS. Notice This parameter is displayed only when multiple regions are available. Make sure that the mappings between the data source and the region are consistent. Otherwise, the migration and synchronization performance can be poor.
   Database Attributes	Valid values: Primary Database , Primary Database + Standby Database , and Standby Database . Select an attribute to configure the corresponding parameters. Note If you select Primary Database + Standby Database or Standby Database , you must specify the Active Data Guard (ADG) mode for the Oracle database. The ADG mode is specified for Oracle databases of a version later than 11g by default.
   Host IP Address	The IP address of the host where the database is located. You must specify the IP address of the physical machine that hosts the Relational Database Service (RDS). Do not enter the IP address of any middleware.
   Port	The port number of the IP address of the host where the database is located.
   Username	The name of the Oracle database user for data migration or synchronization. We recommend that you create a separate database user for the migration or synchronization task.
   Password	The password of the database user.
   Service Name	The service name of the Oracle database.
   Schema Name (optional)	The schema name of the Oracle database.
   Remarks (optional)	Additional information about the data source.

6. Click Test Connection to test the network connection between OMS and the source, and the validity of the username and password.

7. After the connection test succeeds, click OK.