ORA: Cannot create PoolableConnectionFactory (IO Error: The Network Adapter could not establish the connection)

Products

• CA Identity Manager

Issue/Introduction

When the customer is trying to create an Oracle Endpoint, the following error displays in the View Submitted Task:

CreateOracleServerEndpoint: Oracle Endpoint '<oracle-endpoint>' creation failed: Connector Server Add failed: code 52 (UNAVAILABLE): failed to add entry eTORADirectoryName=<oracle-endpoint>,eTNamespaceName=Oracle Server,dc=im,dc=eta: JCS@   hostname: ORA: Cannot create PoolableConnectionFactory (IO Error: The Network Adapter could not establish the connection) (ldaps://hostname:20411),

Environment

Release : 14.3

Cause

The customer is using the following URL while creating the Oracle Endpoint which is not a properly configured URL:
jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=host1 IP address)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=host2 IP address)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=host3 IP address)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=myservicename)))

Resolution

The Oracle Endpoint is created successfully after performing the following changes:

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=FQDN)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=myservicename)))

and configured on ../etc/host on CCS and JCS server:

host1 IP address FQDN
host2 IP address FQDN
host3 IP address FQDN