Prerequisites

  • DbVisualizer installed
  • Wallet zip file downloaded from the Oracle Analytics Cloud Autonomous Data Warehouse (OAC ADW) admin. 

Downloading and Preparing the JDBC Driver

In order to use the Wallet you will need some additional JAR files to be added for the Oracle Driver in DbVisualizer.

  1. Visit Oracle download page to get three Java packages (Oracle account required):
    oraclepki.jar, osdt_cert.jar, and osdt_core.jar 
  2. In DbVisualizer open Tools -> Driver Manager select the Oracle Thin driver entry in the left list
  3. In the Driver menu, select Duplicate Driver
  4. Rename the new Oracle (copy) entry to Oracle OAC (or whatever name you find good)
  5. Add the JAR files downloaded in step 1 for the driver entry.

Configure Connection Files

  1. Unzip and save the Wallet Zip to a safe path (e.g. C:\ADW):
    cwallet.sso, ewallet.p12, keystore.jks, ojdbc.properties, sqlnet.ora, tnsnames.ora, truststore.jks
  2. Edit DIRECTORY part in sqlnet.ora to match the wallet file directory:
    WALLET_LOCATION = (SOURCE = (METHOD = file) (METHOD_DATA = (DIRECTORY="C:\ADW")))SSL_SERVER_DN_MATCH=yes
  3. Edit system environment variable to set TNS_ADMIN = "C:\ADW" to tell DbVisualizer where to find tnsnames.ora file (the configuration file that defines the Oracle database address)
  4. Note: if your machine already has TNS_ADMIN set, check if that path already contains tnsnames.ora ("remote tnsnames.ora file"). If so:
    1. If your OAC ADW admin allows you to edit that file, copy the content of the tnsnames.ora file in your wallet file path ("local tnsnames.ora file") and append to the end of that remote file.
      Do not change your machine's TNS_ADMIN
    2. If you can't edit that remote file, copy its content and append it to the local file.
      Then proceed to set TNS_ADMIN = "C:\ADW"
  5. Repeat the process for every OAC ADW environment (prod, test, etc)

Configure the Connection in DbVisualizer

  1. Launch or relaunch DbVisualizer and create a new Connection using the Connection Wizard
  2. Select Database Driver = Oracle OAC (or what you named it to earlier) and Service = TNS
  3. You should be able to pick TNS Alias from a dropdown list that contains the OAC.
    If not, check Configure connection files above.
  4. Enter Database Userid and Database Password that your OAC ADW admin provided.
  5. Switch to the  Properties Tab and Driver Properties. Scroll to parameter oracle.net.wallet_location, enter "C:\ADW", and click Apply
  6. If using the file path alone does not work, use the following string instead:

    (SOURCE=(METHOD=file)(METHOD_DATA=(DIRECTORY="C:\ADW")))


You should now be all set. If not, check all steps and a few other things:

  1. You have updated to the newest version of DbVisualizer.
  2. Check if the environment variable ORACLE_HOME is defined. This is because the tnsnames.ora file could be found in two places: the path defined by TNS_ADMIN or as %ORACLE_HOME%\network\admin