When Trying to Connect to ADW from Marketplace Install of EDQ Received the Following Error "Error connecting to server (Code: 21,000)" (Doc ID 2799572.1)

Last updated on MARCH 14, 2023

Applies to:

Symptoms

Receiving the following error when testing an Oracle Enterprise Data Quality (EDQ) on Marketplace (MP) connection to an Oracle Autonomous Database (ADW or ATP) on Marketplace datastore with uploaded wallet after changing from public to private IP.

The issue can be reproduced with the following steps:
Add a Data Store in Director to connect to the Autonomous Database
  a. Log into Director from the EDQ Launchpad
  b. Either in a new project, or within an existing project, right-click on Data Stores, and select New Data Store…
  c. Under Data is accessed from, select Server
  d. Under Category, select Database
  e. Under Type, select Oracle Autonomous Database (ADW or ATP) with uploaded wallet
  f. Click Next
  g. Enter the Service Name of your ADW or ATP instance, and the name of your subfolder in the EDQ landing area of your tnsnames.ora and cwallet.sso files
            Note: If you did not create a subfolder and uploaded the files directly to the landing area you can leave this folder blank.
  h. Enter a valid User name and Password for the ADW or ATP instance.
  i. Enter a Schema, or leave this blank if you wish to use the default schema for the user
  j. Click on the Test… button and observe error

Changes

Shifted from a Public access connection to a Private access connect. 

Cause