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.
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
- Go to the Instant Client Downloads page.
- Select the operating system. For example, Linux x86-64.
- Download the following packages: Basic Package (ZIP) file, SQL*Plus Package, and Tools Package.
- 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
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
- Download the
oci-cliclient from GitHub.
- Review the installation requirements before installing the software.
- Use the installer script and the setup command, as described in the
readmefile, to install and configure the command-line interface on your on-premises database host.
- Test the command-line interface to verify that it is working properly.
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.
- Log into My Oracle Support.
- Download the latest
mv2adbwith RPM.X represents the version number.
# rpm -i mv2adb-2.0.1-X.noarch.rpm
mv2adbdirectory is created under the
- Verify that the directories and files are in the
# 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
- (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:
sqlnet.ora: Network configuration files storing connect descriptors and SQL*Net client side configuration.
ewallet.p12: Auto-open SSO wallet and PKCS12 file. PKCS12 file is protected by the wallet password provided in the UI.
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
- From the Autonomous Data Warehouse Service Console, click Administration.
- Click Download Client Credentials (Wallet).
- 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.
- 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.