This post was originally published on this site

mv2oci is a tool which helps to migrate on-premise data to the Oracle Cloud Infrastructure based on Oracle Data Pump and works as a data load tool. The local Data Pump export is transferred and imported to/on the target cloud server automatically. There is no use of Oracle Cloud Object Storage, the dump files are transferred with rsync or scp to the target database node. This is the different behavior to mv2adb – see my blogpost here – which uses the Object Storage. As an option, the data can be transferred via Database Link (mv2oci Parameter –netlink).

All you need to know about mv2oci is written in the My Oracle Support Note (OCI) MV2OCI: move data to Oracle Cloud Database in “one-click” (Doc ID 2514026.1).  The newest version of the rpm package can be downloaded there. The package has to be installed on the source server.

Prerequisites

  • SQL*Net connection between the two databases
  • A Java executable – in my case I have installed jre (yum install jre)
  • Verify if the firewall to the VCN Subnet is open for Port 1521 – Port 22 is open as per default
  • Password of database user SYSTEM

The Use Case

Let’s move the database schema SOE from my on-premise Oracle Linux Server into the cloud step-by-step. An Oracle Cloud Infrastructure database instance is already up and running, the target tablespace is created. The data centers are connect by VPN.

 

Database Information

Source Target
CDB Name CDB118 CDB118
PDB Name pdb11801 pdboci
Hostname heckenweg srv-cdb118
IP Address 192.168.1.184 172.16.0.8
PDB Service Name pdb11801.kestenholz.net pdboci.subnetvcnmohnwe.vcnmohnwegvpn.oraclevcn.com

1. Package Installation

Download and transfer the package to the on-premise server, for example in directory /tmp. As user root, install the package.

# rpm -ihv mv2oci-2.0.2-3.el7.x86_64.rpm
warning: mv2oci-2.0.2-3.el7.x86_64.rpm: Header V4 RSA/SHA1 Signature, key ID 939112d6: NOKEY
Verifying... ################################# [100%]
Preparing... ################################# [100%]
Updating / installing...
1:mv2oci-2.0.2-3 ################################# [100%]

mv2oci-2.0.2.3 binary has been installed on /opt/mv2oci succesfully!

Verify that the SSH private key which is used for the connection to the Oracle Cloud Infrastructure server is available and the connection is working. Here is the OCI SSH key available in the $HOME/.ssh.

$ ssh -i $HOME/.ssh/id_rsa_oci_29012020 opc@172.16.0.8
Last login: Fri Oct 30 05:39:27 2020 from 192.168.1.235
[opc@srv-cdb118 ~]$

2. Encrypt the SYSTEM passwords for both databases – mv2oci encpass

# ./mv2oci.bin encpass

Please enter the password :
Please re-enter the password :
79F510449D6D43B028EB2E5FCC7CC71A336F363F123456789ABCDEFGHIJKLMNO

3. Configuration File

A template of the configuration file is located in /opt/mv2oci/oci. I used the following parameters – other parameters like ICHOME for Instance Client configuration are well described.

Source DB Parameters

Parameter Value
DB_CONSTRING //heckenweg/pdb11801.kestenholz.net
SYSTEM_DB_PASSWORD Encrypted SYSTEM password
SCHEMAS SOE
DUMP_FILES /tmp/exp_soe_18102020_01.dmp, /tmp/exp_soe_18102020_02.dmp
OHOME /u01/app/oracle/product/19.0.0/dbhome_1

Expdp/Impdp Parameters

Parameter Value
Dump Name exp_soe_18102020.dmp
DUMP_PATH /tmp
PARALLEL 2 – creates two Dumpfiles called exp_soe_18102020_01.dmp and exp_soe_18102020_02.dmp

OCI Parameters

Parameter Value
OC_HOST 172.16.0.8
OC_SSHKEY /home/oracle/.ssh/id_rsa_oci_29012020
OC_DB_CONSTRING //172.16.0.8/pdboci.subnetvcnmohnwe.vcnmohnwegvpn.oraclevcn.com
OC_DB_PASSWORD Encrypted SYSTEM password
OC_DUMP_LOC /tmp

 

4. Export Data – mv2oci expdp

# ./mv2oci.bin expdp --conf conf/CDB118.mv2oci.cfg

INFO: 2020-10-30 06:32:51: Please check the logfile '/opt/mv2oci/out/log/mv2oci_314519.log' for more details

│▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒│
mv2oci - Move data to Oracle Cloud Infrastructure (OCI)
Version: 2.0.2-3
Copyright (c) 1982-2019 Oracle and/or its affiliates.
--------------------------------------------------------
Author: Ruggero Citton <ruggero.citton@oracle.com>
RAC Pack, Cloud Innovation and Solution Engineering Team
│▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒│

INFO: 2020-10-30 06:32:51: Reading configuration file 'conf/CDB118.mv2oci.cfg'
INFO: 2020-10-30 06:32:51: Using Oracle Home '/u01/app/oracle/product/19.0.0/dbhome_1/'
INFO: 2020-10-30 06:32:51: Getting source DB version
INFO: 2020-10-30 06:32:52: Checking schemas on source database '//heckenweg/pdb11801.kestenholz.net'
INFO: 2020-10-30 06:32:53: Creating expdp directory 'MV2OCI_DP_DIR' for path '/tmp'
INFO: 2020-10-30 06:32:54: Getting latest SCN
INFO: 2020-10-30 06:32:55: Expdp parallelism set by parameter '2'
INFO: 2020-10-30 06:32:55: Executing Expdp as jobname 'MV2OCI_JOB'
INFO: 2020-10-30 06:32:55: Expdp log location available at the end of the process is '/opt/mv2oci/out/log/mv2oci_expdp_314519.log'

FLASHBACK automatically enabled to preserve database integrity.
Starting "SYSTEM"."MV2OCI_JOB": system/********@//heckenweg/pdb11801.kestenholz.net SILENT=BANNER JOB_NAME=MV2OCI_JOB SCHEMAS=SOE VERSION=19.0.0 DIRECTORY=MV2OCI_DP_DIR DUMPFILE=exp_soe_18102020_%u.dmp PARALLEL=2 REUSE_DUMPFILES=y LOGFILE=mv2oci_expdp_314519.log FILESIZE=4G FLASHBACK_SCN=6980091
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/FUNCTIONAL_INDEX/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/STATISTICS/MARKER
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC
Processing object type SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/INDEX/FUNCTIONAL_INDEX/INDEX
Processing object type SCHEMA_EXPORT/VIEW/VIEW
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
. . exported "SOE"."ORDERS" 129.1 MB 1429790 rows
. . exported "SOE"."ORDER_ITEMS" 380.1 MB 7138088 rows
. . exported "SOE"."CUSTOMERS" 108.1 MB 1000000 rows
. . exported "SOE"."ADDRESSES" 110.0 MB 1500000 rows
. . exported "SOE"."CARD_DETAILS" 63.87 MB 1500000 rows
. . exported "SOE"."LOGON" 51.24 MB 2382984 rows
. . exported "SOE"."PRODUCT_DESCRIPTIONS" 220.8 KB 1000 rows
. . exported "SOE"."PRODUCT_INFORMATION" 188.6 KB 1000 rows
. . exported "SOE"."WAREHOUSES" 35.42 KB 1000 rows
. . exported "SOE"."ORDERENTRY_METADATA" 5.609 KB 4 rows
. . exported "SOE"."INVENTORIES" 15.27 MB 901957 rows
Master table "SYSTEM"."MV2OCI_JOB" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.MV2OCI_JOB is:
/tmp/exp_soe_18102020_01.dmp
/tmp/exp_soe_18102020_02.dmp
Job "SYSTEM"."MV2OCI_JOB" successfully completed at 00:00

INFO: 2020-10-30 06:33:20: Following expdp dump has been created:
DUMP_FILES=/tmp/exp_soe_18102020_01.dmp,/tmp/exp_soe_18102020_02.dmp
SUCCESS: 2020-10-30 06:33:20: Expdp executed successfully

Dump files created in /tmp.

# ls -la /tmp/*.dmp
-rw-r-----. 1 oracle oinstall 569135104 Oct 30 06:33 /tmp/exp_soe_18102020_01.dmp
-rw-r-----. 1 oracle oinstall 331845632 Oct 30 06:33 /tmp/exp_soe_18102020_02.dmp

5. Transfer Data – mv2oci putdump

# ./mv2oci.bin putdump --conf conf/CDB118.mv2oci.cfg
INFO: 2020-10-30 06:42:41: Please check the logfile '/opt/mv2oci/out/log/mv2oci_319424.log' for more details

│▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒│
mv2oci - Move data to Oracle Cloud Infrastructure (OCI)
Version: 2.0.2-3
Copyright (c) 1982-2019 Oracle and/or its affiliates.
--------------------------------------------------------
Author: Ruggero Citton <ruggero.citton@oracle.com>
RAC Pack, Cloud Innovation and Solution Engineering Team
│▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒│

INFO: 2020-10-30 06:42:41: Reading configuration file 'conf/CDB118.mv2oci.cfg'
INFO: 2020-10-30 06:42:41: Checking OCHost '172.16.0.8' connectivity
INFO: 2020-10-30 06:42:42: Determining if using rsync or scp to transfer dump files
INFO: 2020-10-30 06:42:42: Using 'rsync' to transfer dump files
INFO: 2020-10-30 06:42:42: Making required dump dir '/tmp' on remote '172.16.0.8'
INFO: 2020-10-30 06:42:42: Uploading dump files over '172.16.0.8' using 'rsync'
INFO: 2020-10-30 06:42:42: Copying /tmp/exp_soe_18102020_01.dmp....
INFO: 2020-10-30 06:42:42: Copying /tmp/exp_soe_18102020_02.dmp....
SUCCESS: 2020-10-30 06:43:06: Dump file ' /tmp/exp_soe_18102020_02.dmp' uploaded successfully
SUCCESS: 2020-10-30 06:43:24: Dump file '/tmp/exp_soe_18102020_01.dmp' uploaded successfully
INFO: 2020-10-30 06:43:24: Setting required permission for dump dir '/tmp' on remote '172.16.0.8'
SUCCESS: 2020-10-30 06:43:28: Dump files uploaded over '172.16.0.8' successfully

Files are available now on target server.

$ ls -la /tmp/*.dmp
-rw-rw-rw- 1 oracle oinstall 569135104 Oct 30 05:43 /tmp/exp_soe_18102020_01.dmp
-rw-rw-rw- 1 oracle oinstall 331845632 Oct 30 05:43 /tmp/exp_soe_18102020_02.dmp

6. Import Data

Tablespace SOEDATA exists on target server, otherwise you can use to the EXTRA_IMPDP parameters in the mv2oci configuration file to do a remapping etc.

# ./mv2oci.bin impdp --conf conf/CDB118.mv2oci.cfg
INFO: 2020-10-30 06:49:33: Please check the logfile '/opt/mv2oci/out/log/mv2oci_322277.log' for more details

│▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒│
mv2oci - Move data to Oracle Cloud Infrastructure (OCI)
Version: 2.0.2-3
Copyright (c) 1982-2019 Oracle and/or its affiliates.
--------------------------------------------------------
Author: Ruggero Citton <ruggero.citton@oracle.com>
RAC Pack, Cloud Innovation and Solution Engineering Team
│▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒│

INFO: 2020-10-30 06:49:33: Reading configuration file 'conf/CDB118.mv2oci.cfg'
INFO: 2020-10-30 06:49:33: Using Oracle Home '/u01/app/oracle/product/19.0.0/dbhome_1/'
INFO: 2020-10-30 06:49:33: Expdp parallelism set by parameter '2'
INFO: 2020-10-30 06:49:33: Creating impdp directory 'MV2OCI_DP_DIR' for path '/tmp' on '172.16.0.8'
INFO: 2020-10-30 06:49:34: Executing import datapump as jobname 'MV2OCI_JOB'
INFO: 2020-10-30 06:49:34: Impdp log location available at the end of the process is '/opt/mv2oci/out/log/mv2oci_impdp_322277.log'
Master table "SYSTEM"."MV2OCI_JOB" successfully loaded/unloaded
Starting "SYSTEM"."MV2OCI_JOB": system/********@//172.16.0.8/pdboci.subnetvcnmohnwe.vcnmohnwegvpn.oraclevcn.com SILENT=BANNER JOB_NAME=MV2OCI_JOB DIRECTORY=MV2OCI_DP_DIR DUMPFILE=exp_soe_18102020_01.dmp,exp_soe_18102020_02.dmp LOGFILE=mv2oci_impdp_322277.log PARALLEL=2
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "SOE"."ORDERS" 129.1 MB 1429790 rows
. . imported "SOE"."CUSTOMERS" 108.1 MB 1000000 rows
. . imported "SOE"."ADDRESSES" 110.0 MB 1500000 rows
. . imported "SOE"."ORDER_ITEMS" 380.1 MB 7138088 rows
. . imported "SOE"."CARD_DETAILS" 63.87 MB 1500000 rows
. . imported "SOE"."LOGON" 51.24 MB 2382984 rows
. . imported "SOE"."PRODUCT_DESCRIPTIONS" 220.8 KB 1000 rows
. . imported "SOE"."PRODUCT_INFORMATION" 188.6 KB 1000 rows
. . imported "SOE"."WAREHOUSES" 35.42 KB 1000 rows
. . imported "SOE"."ORDERENTRY_METADATA" 5.609 KB 4 rows
. . imported "SOE"."INVENTORIES" 15.27 MB 901957 rows
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC
Processing object type SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC
Processing object type SCHEMA_EXPORT/VIEW/VIEW
Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/INDEX/FUNCTIONAL_INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/FUNCTIONAL_INDEX/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/STATISTICS/MARKER
ORA-39082: Object type PACKAGE BODY:"SOE"."ORDERENTRY" created with compilation warnings

Job "SYSTEM"."MV2OCI_JOB" completed with 1 error(s) at 00:00

ERROR: 2020-10-30 06:51:14: Executing impdp on remote '//172.16.0.8/pdboci.subnetvcnmohnwe.vcnmohnwegvpn.oraclevcn.com'

Analysis of the error in the SQL*Developer – there is a missing execution permission on package DBMS_LOCK.

This is an easy thing:

SQL> GRANT EXECUTE ON dbms_lock TO SOE;

Grant succeeded.

7. Reporting – mv2oci report

The report compares the objects on source and target database.

# ./mv2oci.bin report --conf conf/CDB118.mv2oci.cfg
INFO: 2020-10-30 07:00:13: Please check the logfile '/opt/mv2oci/out/log/mv2oci_327866.log' for more details

│▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒│
mv2oci - Move data to Oracle Cloud Infrastructure (OCI)
Version: 2.0.2-3
Copyright (c) 1982-2019 Oracle and/or its affiliates.
--------------------------------------------------------
Author: Ruggero Citton <ruggero.citton@oracle.com>
RAC Pack, Cloud Innovation and Solution Engineering Team
│▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒│

INFO: 2020-10-30 07:00:13: Reading configuration file 'conf/CDB118.mv2oci.cfg'
INFO: 2020-10-30 07:00:14: using Oracle Home '/u01/app/oracle/product/19.0.0/dbhome_1/'
INFO: 2020-10-30 07:00:14: Getting Obj report for '//heckenweg/pdb11801.kestenholz.net'

0
Database Objects REPORT for //heckenweg/pdb11801.kestenholz.net

 SOE       |INDEX       |        27
 SOE       |PACKAGE     |         1
 SOE       |TABLE       |        11
 SOE       |VIEW        |         2
 SOE       |SEQUENCE    |         5
 SOE       |PACKAGE BODY|         1
           |            |----------
 sum       |            |        47

INFO: 2020-10-30 07:00:15: Getting Segments report for '//heckenweg/pdb11801.kestenholz.net'

0
         Database Segments REPORT for //heckenweg/pdb11801.kestenholz.net

 SOE       |PRD_DESC_PK                   |INDEX          |      .125
 SOE       |WHS_LOCATION_IX               |INDEX          |     .0625
 SOE       |ORD_CUSTOMER_IX               |INDEX          |   27.1875
 SOE       |INVENTORIES                   |TABLE          |       176
 SOE       |ORD_WAREHOUSE_IX              |INDEX          |   30.1875
 SOE       |INVENTORY_PK                  |INDEX          |        18
 SOE       |CARD_DETAILS                  |TABLE          |        80
 SOE       |ORDERS                        |TABLE          |       160
 SOE       |CUSTOMERS_PK                  |INDEX          |    18.625
 SOE       |PROD_SUPPLIER_IX              |INDEX          |      .125
 SOE       |PRODUCT_INFORMATION           |TABLE          |       .25
 SOE       |ORDER_ITEMS_PK                |INDEX          |     146.5
 SOE       |ORDER_PK                      |INDEX          |   25.9375
 SOE       |ORD_ORDER_DATE_IX             |INDEX          |    31.875
 SOE       |INV_WAREHOUSE_IX              |INDEX          |   16.6875
 SOE       |ORDERENTRY_METADATA           |TABLE          |     .0625
 SOE       |CARD_DETAILS_PK               |INDEX          |   27.1875
 SOE       |ORD_SALES_REP_IX              |INDEX          |   25.5625
 SOE       |PROD_CATEGORY_IX              |INDEX          |     .0625
 SOE       |CUST_ACCOUNT_MANAGER_IX       |INDEX          |    18.625
 SOE       |CUSTOMERS                     |TABLE          |       136
 SOE       |ADDRESSES                     |TABLE          |       136
 SOE       |ORDER_ITEMS                   |TABLE          |       464
 SOE       |PRODUCT_INFORMATION_PK        |INDEX          |     .0625
 SOE       |ADDRESS_CUST_IX               |INDEX          |   28.4375
 SOE       |ITEM_PRODUCT_IX               |INDEX          |  120.5625
 SOE       |LOGON                         |TABLE          |        64
 SOE       |PRODUCT_DESCRIPTIONS          |TABLE          |     .3125
 SOE       |ADDRESS_PK                    |INDEX          |    27.125
 SOE       |WAREHOUSES_PK                 |INDEX          |     .0625
 SOE       |PROD_NAME_IX                  |INDEX          |      .125
 SOE       |CARDDETAILS_CUST_IX           |INDEX          |   28.4375
 SOE       |WAREHOUSES                    |TABLE          |     .0625
 SOE       |ITEM_ORDER_IX                 |INDEX          |   130.875
 SOE       |INV_PRODUCT_IX                |INDEX          |     16.75
 SOE       |CUST_DOB_IX                   |INDEX          |   23.1875
 SOE       |CUST_EMAIL_IX                 |INDEX          |     41.25
 SOE       |CUST_FUNC_LOWER_NAME_IX       |INDEX          |   29.0625
           |                              |               |----------
 sum       |                              |               |  2049.375

INFO: 2020-10-30 07:00:16: Getting Obj report for '//172.16.0.8/pdboci.subnetvcnmohnwe.vcnmohnwegvpn.oraclevcn.com'

0
 Database Objects REPORT for //172.16.0.8/pdboci.subnetvcnmohnwe.vcnmohnwegvpn.or

 SOE       |INDEX       |        27
 SOE       |PACKAGE     |         1
 SOE       |SEQUENCE    |         5
 SOE       |TABLE       |        11
 SOE       |VIEW        |         2
 SOE       |PACKAGE BODY|         1
           |            |----------
 sum       |            |        47


INFO: 2020-10-30 07:00:17: Getting Segments report for '//172.16.0.8/pdboci.subnetvcnmohnwe.vcnmohnwegvpn.oraclevcn.com'

0
 Database Segments REPORT for //172.16.0.8/pdboci.subnetvcnmohnwe.vcnmohnwegvpn.o

 SOE       |WHS_LOCATION_IX               |INDEX          |     .0625
 SOE       |PRD_DESC_PK                   |INDEX          |     .0625
 SOE       |ORD_CUSTOMER_IX               |INDEX          |        26
 SOE       |INVENTORIES                   |TABLE          |       176
 SOE       |ORD_WAREHOUSE_IX              |INDEX          |        29
 SOE       |INVENTORY_PK                  |INDEX          |        18
 SOE       |ORDERS                        |TABLE          |       160
 SOE       |CARD_DETAILS                  |TABLE          |        80
 SOE       |PROD_SUPPLIER_IX              |INDEX          |     .0625
 SOE       |CUSTOMERS_PK                  |INDEX          |        17
 SOE       |PRODUCT_INFORMATION           |TABLE          |       .25
 SOE       |ORDER_ITEMS_PK                |INDEX          |       144
 SOE       |ORDER_PK                      |INDEX          |        25
 SOE       |ORD_ORDER_DATE_IX             |INDEX          |        31
 SOE       |INV_WAREHOUSE_IX              |INDEX          |        15
 SOE       |ORDERENTRY_METADATA           |TABLE          |     .0625
 SOE       |PROD_CATEGORY_IX              |INDEX          |     .0625
 SOE       |ORD_SALES_REP_IX              |INDEX          |        24
 SOE       |CUST_ACCOUNT_MANAGER_IX       |INDEX          |        17
 SOE       |CARD_DETAILS_PK               |INDEX          |        26
 SOE       |ADDRESSES                     |TABLE          |       136
 SOE       |CUSTOMERS                     |TABLE          |       136
 SOE       |ORDER_ITEMS                   |TABLE          |       464
 SOE       |ADDRESS_CUST_IX               |INDEX          |        27
 SOE       |ITEM_PRODUCT_IX               |INDEX          |       120
 SOE       |PRODUCT_INFORMATION_PK        |INDEX          |     .0625
 SOE       |PRODUCT_DESCRIPTIONS          |TABLE          |     .3125
 SOE       |LOGON                         |TABLE          |        64
 SOE       |WAREHOUSES_PK                 |INDEX          |     .0625
 SOE       |ADDRESS_PK                    |INDEX          |        26
 SOE       |PROD_NAME_IX                  |INDEX          |      .125
 SOE       |CARDDETAILS_CUST_IX           |INDEX          |        27
 SOE       |WAREHOUSES                    |TABLE          |     .0625
 SOE       |ITEM_ORDER_IX                 |INDEX          |       136
 SOE       |CUST_DOB_IX                   |INDEX          |        22
 SOE       |CUST_EMAIL_IX                 |INDEX          |        40
 SOE       |INV_PRODUCT_IX                |INDEX          |        15
 SOE       |CUST_FUNC_LOWER_NAME_IX       |INDEX          |        28
           |                              |               |----------
 sum       |                              |               | 2030.1875

8.  All in One – mvoci auto

We did the steps one-by-one, by using the parameter auto, the steps above are done automatically (except reporting).

# ./mv2oci.bin auto --conf conf/CDB118.mv2oci.cfg

9. Logfiles

Logfiles tom the mv2oci actions are located in:

mv2oci /opt/mv2oci/out/log
Data Pump Directory in parameter DUMP_PATH

Summary

mv2oci is another great tool to support the movement to Oracle Cloud Infrastructure. Easy to configure, easy to use. #ilike