Data Transmission Service:Collect database information

Prerequisites

Before you begin, make sure you have:

• Access to the Data Management (DMS) 5.0 console

• A database profile for the source database (see Manage database profiles)

Set up the collection account

Log in to the source Oracle database and run the following SQL statements to create a dedicated collection account.

Oracle 10g, 11g, or 12c (non-CDB mode — local user)

create user eoa_user identified by eoaPASSW0RD default tablespace users;
grant connect,select_catalog_role to eoa_user;

Oracle 12c (CDB mode — common user)

Connect to the CDB, then run:

create user c##eoa_user identified by "eoaPASSW0RD" default tablespace users;
grant connect,select_catalog_role to c##eoa_user container=all;
alter user c##eoa_user set container_data=all container=current;

Create and run a collection task

1. Log on to the Data Management (DMS) 5.0 console.

2. In the top menu bar, choose Data + AI > Heterogeneous Database Migration (ADAM) > Database Evaluation.

3. On the Database Information Collection tab, click Online Database Collection.

4. Click Create Collection Task.

5. Configure the collection account as described in Set up the collection account, then click Next.

6. In the Create Collection Task panel, configure the following parameters.

   Parameter	Description
   Collection Task Name	Enter a name for the collection task.
   Source Database Type	Only ORACLE is supported.
   Source Database Profile	Select the profile for the source database.
   List Of Schemas To Include	Specify the schemas to collect. Separate multiple names with commas (,).
   List Of Schemas To Exclude	Specify the schemas to exclude. Separate multiple names with commas (,).
   Collect SQL Statements	Select whether to include SQL statements in the collection.

7. Click Test Connectivity. If the connection succeeds, click Start Collection.

8. After the task completes, select the task and click Next: Create Profile to generate a database profile.

Prerequisites

Before you begin, make sure you have:

• A separate device that meets the minimum requirements listed in Collector device requirements

• SYSDBA-level access to the source Oracle database to create a collection account

Collector device requirements

Run the ADAM Database Collector on a separate device — not on the same machine as the source database. The device must meet the following requirements:

Download the collector

1. Log on to the Data Management (DMS) 5.0 console.

2. In the top menu bar, choose Data + AI > Heterogeneous Database Migration (ADAM) > Database Evaluation.

3. On the Database Information Collection tab, click Download Collector.

4. Download the ADAM client version that matches the operating system of your collector device, then decompress the package.

Set up the collection account

If you already have an account with the required permissions, skip this step.

Log in to the source Oracle database using an account with SYSDBA permissions and run the following SQL statements.

Oracle 10g, 11g, or 12c (non-CDB mode — local user)

create user eoa_user identified by eoaPASSW0RD default tablespace users;
grant connect,select_catalog_role to eoa_user;

Oracle 12c (CDB mode — common user)

Connect to the CDB, then run:

create user c##eoa_user identified by "eoaPASSW0RD" default tablespace users;
grant connect,select_catalog_role to c##eoa_user container=all;
alter user c##eoa_user set container_data=all container=current;

Run the collector

1. On the collector device, run the collection command for your Oracle version.

   Use the .bat script on Windows and the .sh script on Linux.

   • Oracle 10g

     collect_10g[.sh|.bat] -h -u -p -d <service_name>

   • Oracle 11g R1

     collect_11gR1[.sh|.bat] -h -u -p -d <service_name>

   • Oracle 11g R2

     collect_11gR2[.sh|.bat] -h -u -p -d <service_name>

   • Oracle 12c, 18c, or 19c

     collect_12c[.sh|.bat] -h <host> -u <username> -p <password> -P <port> -d <service_name> -s <sid>

     To collect from a specific pluggable database (PDB) in Oracle 12c, use the collect_12c script. The operation is similar to collecting from Oracle 11g.

   Parameter	Description	Example
   -h	Hostname or IP address of the source database	192.168.1.100
   -u	Username for the collection account	eoa_user
   -p	Password for the collection account	eoaPASSW0RD
   -P	Port of the source database	1521
   -d	Service name of the source database. For Oracle 12c, use the service name of the target PDB.	orcl
   -s	SID (instance name) of the source database	orcl

2. After the collection completes, the system generates a data packet and prints the output path. The output looks similar to:

   [***] ******************************************************************
   [***] * Collect Successfully!
   [***] *
   [***] * Complete the file packaging, the package result path is:
   [***] * ~rainmeter/out/data.zip
   [***] ******************************************************************

Clean up the collection account (optional)

After migration, drop the temporary collection account to remove unnecessary access.

Connect to the database using an account with SYSDBA permissions and run the appropriate statement:

• Oracle 10g, 11g, 12c, 18c, or 19c (non-CDB mode)

  drop user eoa_user cascade;

• Oracle 12c, 18c, or 19c (CDB mode)

  drop user c##eoa_user cascade;