1. Migrate data from on-premises to an autonomous database in the cloud using MV2ADB
  2. Install the Software

Install the Software

Download and install the required software, tools, and client credentials.

Install Oracle Instant Client Basic, SQL, and Tools Packages

Download and install the latest version of Oracle Instant Client packages for your operating system.

Oracle Instant Client is a lightweight repackaging of Oracle Database libraries, tools and header files that are used to create and run applications that connect to a remote or local Oracle Database. The Instant Client libraries provide the necessary network connectivity, as well as basic and high end data features, to make full use of Oracle Database.

The following packages are required:

  • Basic Package: All files required to run OCI, OCCI, and JDBC-OCI applications
  • SQL*Plus Package: The SQL*Plus command line tool for SQL and PL/SQL queries
  • Tools Package: Includes Data Pump, SQL*Loader and Workload Replay Client
  1. Go to the Instant Client Downloads page.
  2. Select the operating system. For example, Linux x86-64.
  3. Download the following packages: Basic Package (ZIP) file, SQL*Plus Package, and Tools Package.
  4. Install the packages following the instructions on the download page.

Install and Configure the oci-cli Client

Install and configure command-line interface for Oracle Cloud Infrastructure, oci-cli, on the on-premises database host.

The installer script automatically installs the CLI and its dependencies, Python and virtualenv. Use the installer script and the setup command, as described in the readme file, to quickly and efficiently install the software. The readme file contains a link to the installation guide for detailed installation instructions, options, and troubleshooting.

  1. Download the oci-cli client from GitHub.
  2. Review the installation requirements before installing the software.
  3. Use the installer script and the setup command, as described in the readme file, to install and configure the command-line interface on your on-premises database host.
  4. Test the command-line interface to verify that it is working properly.

Install MV2ADB

Use the RPM (RedHat Package Manager) command to install or update MV2ADB.

Before you begin, ensure that you have installed the latest version of Oracle Instant Client Basic and Tools Packages. Oracle Instant Client libraries provide the necessary network connectivity and data features and enable applications to connect to a local or remote Oracle Database for deployment.

  1. Log into My Oracle Support.
  2. Download the latest mv2adb package.
  3. Install mv2adb with RPM.
    X represents the version number. 
    # rpm -i mv2adb-2.0.1-X.noarch.rpm

    An mv2adb directory is created under the /opt directory.

  4. Verify that the directories and files are in the /opt/mv2adb directory.
    # tree /opt/mv2adb/
/opt/mv2adb/
├── conf
|   └── DBNAME.mv2atp.cfg
├── lib
|   ├── MV2ADB_LoggingAndTracing.pm
|   ├── MV2ADB_passwd.jar
|   ├── MV2ADB_PFile.pm
|   ├── MV2ADB_Queries.pm
|   └── MV2ADB_Utils.pm
└── mv2adb
└── utils
    └── install_adb_advisor.sql

3 directories, 8 files
  5. (Optional) Update a previously installed version.
    X represents the version number. 
    # rpm -Uvh mv2adb-2.0.1-X.noarch.rpm

Download the Client Credentials

Download the Oracle Autonomous Database Cloud Client Credentials (Wallet) from the Autonomous Data Warehouse Service Console and store the wallet in TNS_ADMIN on the on-premises database host.

When you download client credentials from the Console, the credentials are stored in an database-specific wallet (Instance Wallet) and are for a single database.

The wallet zip file includes the following:

  • tnsnames.ora and sqlnet.ora: Network configuration files storing connect descriptors and SQL*Net client side configuration.

  • cwallet.sso and ewallet.p12: Auto-open SSO wallet and PKCS12 file. PKCS12 file is protected by the wallet password provided in the UI.

  • keystore.jks and truststore.jks: Java keystore and truststore files. They are protected by the wallet password provided while downloading the wallet.

  • ojdbc.properties: Contains the wallet related connection property required for JDBC connection. This should be in the same path as tnsnames.ora.

  1. From the Autonomous Data Warehouse Service Console, click Administration.
  2. Click Download Client Credentials (Wallet).
  3. Enter a password for the wallet.
    The password must be at least 8 characters long and must include at least 1 letter and either 1 numeric character or 1 special character. This password protects the downloaded Client Credentials wallet.
  4. Click Download. Save the client security credentials zip file in the TNS_ADMIN on the on-premises database host.
    Protect this file to prevent unauthorized database access. Wallet files, along with the Database user ID and password, provide access to data.