Invalid database connection error when dSeries installed with Oracle Autonomous DB

Products

• ESP dSeries Workload Automation

Issue/Introduction

Users may see following errors when installing DE with Oracle Autonomous Database.

Invalid Database Connection Information
---------------------------------------
DB Connection Info: Unable to Establish Database Connection.IO Error:
Connection reset by peer, Authentication lapse 0 ms.
  ->1- Back to database configuration
    2- Exit Installation

Environment

ESP dSeries / Workload Automation DE: 12.3 or above

DB: Oracle Autonomous 

Cause

Use custom JDBC URL.

Resolution

Consult DBA and use custom JDBC URL for DE installer to connect to the Oracle DB.  The custom URL can be obtained from tnsnames.ora file.

E.g.

jdbc:oracle:thin:@(description= (retry_count=20)(retry_delay=3)(address=(protocol=tcps)(port=1521)(host=db.example.com))(connect_data=(service_name=examplehost.adb.oraclecloud.com))(security=(ssl_server_dn_match=no)))

The above is an example for Database hosted on Oracle Cloud.