Section | Parameter | Description |
N/A | Task Name | The name of the task. DTS automatically assigns a name to the task. We recommend that you specify a descriptive name that makes it easy to identify the task. You do not need to specify a unique task name. |
Source Database | Database Type | The type of the source database. Select Oracle. |
Access Method | The access method of the source database. In this example, Public IP Address is selected. Note If you select another access method, you must set up the environment that is required for the self-managed Oracle database. For more information, see Preparation overview. |
Instance Region | The region in which the source self-managed Oracle database resides. |
Hostname or IP address | The endpoint that is used to connect to the source self-managed Oracle database. |
Port Number | The service port number of the source self-managed Oracle database. Default value: 1521. Note In this example, the service port of the self-managed Oracle database must be accessible over the Internet. |
Oracle Type | The architecture of the source self-managed Oracle database. If you select Non-RAC Instance, you must configure the SID parameter. If you select RAC or PDB Instance, you must configure the Service Name parameter.
In this example, Non-RAC Instance is selected. |
Database Account | The account of the source self-managed Oracle database. For information about the permissions that are required for the account, see the Before you begin section of this topic. |
Database Password | The password of the database account. |
Destination Database | Database Type | The type of the destination database. Select PolarDB (Compatible with Oracle). |
Access Method | The access method of the destination database. Select Public IP Address. |
Instance Region | The region in which the destination PolarDB for PostgreSQL (Compatible with Oracle) cluster is deployed. |
Data Sources | Single Data Source: If you select this option, you must configure the Domain Name or IP Address and Port Number parameters of the primary node in the destination PolarDB for PostgreSQL (Compatible with Oracle) cluster. Multiple Data Sources: If you select this option, you must specify the IP addresses and port numbers of multiple nodes, including the primary node, in the destination PolarDB for PostgreSQL (Compatible with Oracle) cluster in the IP:Port of Data Sources field. Note If you select Multiple Data Sources and configure the IP:Port of Data Sources parameter, DTS can automatically switch to a new primary node in the PolarDB for PostgreSQL (Compatible with Oracle) cluster during primary/secondary switchover. This is suitable for scenarios such as disaster recovery.
In this example, Single Data Source is selected. |
Domain Name or IP Address | The endpoint of the primary node in the destination PolarDB for PostgreSQL (Compatible with Oracle) cluster. Note You can run the ping command on your computer to obtain the IP address that is used to access the destination PolarDB for PostgreSQL (Compatible with Oracle) cluster. |
Port Number | The service port number of the destination database. Default value: 1521. |
IP:Port of Data Sources | The IP addresses and port numbers of multiple nodes, including the primary node, in the destination PolarDB for PostgreSQL (Compatible with Oracle) cluster. Separate multiple IP:Port with commas (,). |
Database Name | The name of the database in the destination PolarDB for PostgreSQL (Compatible with Oracle) cluster to which you want to migrate data. |
Database Account | The database account of the destination PolarDB for PostgreSQL (Compatible with Oracle) cluster. For information about the permissions that are required for the account, see the Before you begin section of this topic. |
Database Password | The password of the database account. |