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 DDL statements 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 to create, delete, and modify databases objects, such as schemas, tables, programs, indexes, users, functions, and views.
• You need to obtain permissions to create an evaluation project. For details, see Permission Management.

Network Settings

UGO can collect data from a source database over a public network or VPC endpoint. In this practice, Public network is used as an example.

• Select Public network for the source Oracle database.
• No additional network settings are required for the target GaussDB database.

Security Rules

• EIP of a UGO instance:

  Log in to the UGO console. Choose Schema Migration > DB Evaluation and click Create Project. On the Basic Details tab page, you can see the EIP.

  

• Security rules for the source database:

  If the network trustlist is enabled for the source Oracle database. You need to add the EIP of the UGO instance to sqlnet.ora.

• Security rules for the target database:

  If the network trustlist is disabled for the target GaussDB database. No additional configurations are required.

The preceding database trustlist is used only for UGO-based collection and migration. After the collection and migration, you can delete the EIP from the trustlist.

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 system. An object cannot be created on the system databases, so they are not recommended for object migration.
• The target database to be connected is normal and has no arrears or suspension.