FDM Configure ORACLETNS connection fails with IO ERROR: COULD NOT RESOLVE THE CONNECT IDENTIFIER

book

Article ID: 209973

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction


When trying to configure a connection in FDM using ORACLETNS, this fails with: 
IO ERROR: COULD NOT RESOLVE THE CONNECT IDENTIFIER
"ORCL_JV_LISTEN"
URL:JDBC:ORACLE:THIN:@ORCL_JV_LISTEN

Environment

Release : 4.9.1

Component : CA Test Data Manager - Fast Data Masker

Resolution

Configuring the Net Service Name in the file tnsnames.ora resolved the issue.

Example tnsnames.ora in C:\app\orcl\product\12.1.0\client_network\admin:
 
# tnsnames.ora Network Configuration File: C:\app\orcl\product\12.1.0\client_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

ORCL_JV_LISTEN =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.xxx.yyy)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = ORCL)
    )
  )

Additional Information

https://www.oradev.com/ORA-12154_resolve_connect_identifier.jsp