Data Transmission Service:Periodic SQL collection

1. Log on to the Data Management (DMS) console V5.0.
2. In the top navigation bar, move the pointer over DTS. Choose Heterogeneous Database Migration(ADAM) > Migration Lab.
3. In the Periodic SQL Collection section, click Download.
4. On the Download Database Collector page, click Download in the Download Database Collector section.
5. Select a database collector version. In the dialog box that appears, read the agreement and click Agree.
   Note

   • The database collector must meet the following runtime environment requirements:
     • The host of the database collector is accessible to the source Oracle database. The database collector is not necessarily installed on the host of the source Oracle database.
     • The memory is larger than 6 GB and the disk space is larger than 50 GB.
   • When the source database schema is collected, the database collector automatically masks the sensitive data.
   • When the source database schema is collected, the database collector automatically monitors the load of the destination database. If the load exceeds a specific limit, the collection is automatically suspended. After the load decreases below the limit, the collection resumes.

• If the engine version of the source Oracle database is 10g, 11g, or 12c, create a local user in a non-CDB architecture.

  -- Create an account named eoa_user and set the password to eoaPASSW0RD.
  create user eoa_user identified by "eoaPASSW0RD" default tablespace users;
  -- Grant query permissions.
  grant connect,resource,select_catalog_role,select any dictionary to eoa_user;
  -- Grant the DBMS_LOGMNR permission. 
  -- If the engine version of the source Oracle database is 10g, execute the following statement first:
  CREATE OR REPLACE PUBLIC SYNONYM dbms_logmnr FOR sys.dbms_logmnr;
  grant execute on DBMS_LOGMNR to eoa_user;
  -- Grant the DBMS_METADATA permission.
  grant execute on dbms_metadata to eoa_user;
  -- Grant permissions to query transactions.
  grant select any transaction to eoa_user;
  -- Grant permissions to analyze tables.
  grant analyze any to eoa_user;
  -- Grant permissions to generate random numbers.
  grant execute on dbms_random to eoa_user;

• If the engine version of the source Oracle database is 12c, connect to an Oracle 12c container database (CDB) to create a common user.

  create user c##eoa_user identified by "eoaPASSW0RD" default tablespace users;
  grant connect,resource,select_catalog_role,select any dictionary to c##eoa_user container=all;
  grant execute on DBMS_LOGMNR to c##eoa_user container=all;
  grant execute on dbms_metadata to c##eoa_user container=all;
  grant select any table to c##eoa_user container=all;
  grant select any transaction to c##eoa_user container=all;
  grant analyze any to c##eoa_user container=all;
  grant execute on dbms_random to c##eoa_user container=all;
  alter user c##eoa_user set container_data=all container=current;

• If the engine version of the source Oracle database is 10g or 11g, run one of the following commands:

  sh collect_10g_cycle.sh -h <ip> -u <username> -p <password> -d <service_name> -c <cron>

  sh collect_11g_cycle.sh -h <ip> -u <username> -p <password> -d <service_name> -c <cron>

  
• If the engine version of the source Oracle database is 12c, run the following command:

  sh collect_12c_cycle.sh -h <ip> -u <username> -p <password> -d <service_name> -s <sid> -c <cron>

  

Periodic collection works at an interval specified by a cron expression. The following table describes some examples of common cron expressions. You can stop collection by terminating the collection process at any time.