Create an Oracle data source

Security risk reminder

When you use OceanBase Data Transmission Service, you can add its public IP address CIDR blocks automatically or manually. This action may introduce security risks. Using this product, you acknowledge and accept these potential risks. You must take basic security measures, such as using strong passwords, restricting open ports for each CIDR block, using authentication for internal API communication, and regularly reviewing and restricting unnecessary IP address CIDR blocks.

OceanBase Data Transmission Service adjusts automatically added whitelists or security groups by adding or removing entries based on business requirements and security risks. Do not use the IP address CIDR blocks in these whitelists or security groups for purposes other than OceanBase Data Transmission Service. Issues that arise from using these CIDR blocks for other purposes are not covered by the OceanBase Data Transmission Service Service-Level Agreement (SLA). For more information about adding whitelists or security groups for OceanBase Data Transmission Service, see the Add a whitelist document.

Procedure

1. Log on to the OceanBase Management Console .

2. In the navigation pane on the left, click Data Transmission > Data Source Management.

3. On the Data Source List page, click Create Data Source in the upper-right corner.

   

4. In the Create Data Source dialog box, set Data Source Type to Oracle.

5. Configure the parameters. The corresponding form is automatically displayed below when you select a different Instance Type from the Instance Type drop-down list.

   

   Instance Type	Parameter	Description
   Self-managed database in a VPC	VPC	Select the destination VPC from the VPC drop-down list. You can also use fuzzy search.
   	Cross-Alibaba Cloud account	Data Transmission Service lets you configure data migration or data synchronization tasks for instances under different Alibaba Cloud accounts. This enables cross-account data migration or synchronization. Select this option as needed. If you select it, enter the other Alibaba Cloud account. If you do not have permission for the account, request authorization first. For more information, see Request cross-account authorization.
   Common parameters Self-managed database instances with a public IP address include all common parameters.	Data source name	Use a combination of letters and digits. The name cannot contain spaces and must be 32 characters or less.
   	Host IP	The IP address of the database host.
   	Port	The port number of the database host IP address.
   	Service Name	The service name of the Oracle database.
   	Username	The username of the Oracle database account for data migration or synchronization. Create a separate database user for the migration or synchronization task.
   	Password	The password of the database user.
   	Notes	Notes about the data source.

6. Click Test Connection to verify the network connectivity between Data Transmission Service and the data source and to validate the username and password.

7. After the connection test is successful, click OK.