1. Essbase Stack Deployment on Oracle Cloud Infrastructure
  2. Back Up and Restore Essbase
  3. Back Up and Restore an Essbase Instance
  4. Install and Configure Oracle Instant Client and Tools

Install and Configure Oracle Instant Client and Tools

To back up the schema and block volumes you will need to use Oracle Database Instant Client and Oracle Data Pump to export the schemas related to a specific Essbase instance.

Note:

You cannot connect to the server hosting your database in the cloud. Oracle Instant Client is a convenient tool for establishing local conections to cloud database instances.
  1. Download an Oracle Instant Client version compatible with your Autonomous Transaction Processing database version. See Oracle Instant Client Downloads.
    • Choose a basic package.
    • Be sure to download and install the corresponding Visual Studio redistributable.
    • Choose the Tools Package, which includes Data Pump.
    • Optionally, you can download SQL*Plus Package, but SQL developer will work as well.
    • See the installation instructions on the platform install download page for the installation steps required after you download Oracle Instant Client and the Tools Package.
  2. The installation instructions for Oracle Instant Client are at the bottom of the platform installation download page.
  3. Connect your Instant Client to your Autonomous Transaction Processing database.