My Oracle Support Banner

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

Last updated on AUGUST 20, 2021

Applies to:

Oracle Enterprise Data Quality on Marketplace - Version 2.0 and later
Oracle Enterprise Data Quality - Version 12.2.1.4.1 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.