use TNS alias during connection to Oracle

[AKhomenko1632149336]

Hello.

We have Oracle database in Data Guard configuration

We have created a Disaster Recovery TNS alias that supports automatic connect for switchover or failover.

TNS alias looks like:

DG_PROD =

 (DESCRIPTION =

  (ADDRESS_LIST =

   (LOAD_BALANCE = OFF)

   (FAILOVER = ON)

   (ENABLE = BROKEN)

   (ADDRESS = (PROTOCOL = TCP) (HOST = <hostname_1>) (PORT = 1521))

   (ADDRESS = (PROTOCOL = TCP) (HOST = <hostname_2>) (PORT = 1521))

  )

  (CONNECT_DATA =

   (SERVICE_NAME = dg_sor)

   (FAILOVER_MODE =

    (TYPE = SESSION)

    (METHOD = BASIC)

    (RETRIES = 180)

    (DELAY = 5)

   )

  )

 )

This alias works great when connected using SQLPLUS.

We have also performed connectivity checks for applications using jdbc.

We wanted to use this TNS alias when connecting Talend to Oracle

When connecting Talend to Oracle using the usual TNS alias, everything goes fine, but if we change it to DG_PROD, an IO error occurs

Can you help solve this problem?

Talend version: 7.3

Oracle DB Version: 11.2.0.4

Oracle Client Version: 11.2.0.4

[ppatel]

Hello,

Can you please let us know what is the error you are getting while making a connection in the Talend?

In Talend studio metadata while creating a DB connection which option are you selecting? Oracle Custom, Oracle OCI, Oracle with SID, Oracle with Service Name?

While creating a connection outside of Talend what option are you selecting? Oracle with SID, Oracle with Service Name?

Regards,

Pooja Patel