Preparing for the Migration

Permissions

• The permission check for the source database must be passed. Table 1 lists the permissions that need to be checked when the source database type is Oracle.

  Table 1 Required checks

  Check Item	Description	Mandatory
  DBMS_METADATA	Permission to retrieve metadata from the Oracle database dictionary. This permission is used to obtain the DDL of schema objects. Granting the DBA permission: Create a user. CREATE USER user IDENTIFIED BY password; Grant the login permission to the user. GRANT CONNECT TO user; Grant the DBA permission to the user. GRANT DBA TO user;	Yes
  Dynamic View	Permission to access various dynamic performance views. This permission is used to obtain basic database information. DBA permission needs to be granted.	Yes
  Schema Objects	Permission to check schema objects to be evaluated. At least one object needs to be evaluated.	Yes
  DBA	DBA permission required for subsequent operations.	No If Check Result is Alarm, some objects could not be collected because of permissions, but the evaluation project can still be created successfully.

• When connecting to the target database, you must have the permissions needed to create, delete, and modify databases objects, such as schemas, tables, programs, indexes, users, functions, and views.

  For details, see Viewing the Permission Check Report.

• You have the permissions needed to create an evaluation project. For details, see Permission Management.

Network Settings

• Network settings for the source database:

  Currently, Oracle databases can be migrated to Huawei Cloud GaussDB only through a public network, which is more convenient and cost-effective.

  You need to enable public accessibility for your on-premises Oracle database.

• Network settings for the target database:

  If the source database attempts to access the target database through a public network, you do not need to configure GaussDB.

Security Rules

• Security rules for the source database:

  You need to add the UGO EIP to the network whitelist of Oracle to enable the source database to communicate with Huawei Cloud GaussDB. Before configuring the network whitelist, you need to obtain the UGO EIP.

  Log in to the UGO console and choose Schema Migration > DB Evaluation and click Create Project. On the Basic Details tab page, obtain the UGO EIP.

  

• Security rules for the target database:

  By default, the target database and UGO are in the same VPC and can communicate with each other. No further configuration is required.

The IP address whitelist is used for migration and can be deleted after the migration is complete.

Other

• You are advised to use a database in a non-production environment.
• You have obtained the IP address, port number, username, and password of the Oracle database to be migrated.
• System databases are maintained by the database itself and no creations can be performed on them.
• The target database to be connected is normal and has no arrears or suspension.