use TNS alias during connection to Oracle

AKhomenko1632149336 — Fri, 15 Nov 2024 23:32:40 GMT

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

Re: use TNS alias during connection to Oracle

ppatel — Sun, 07 Aug 2022 06:13:09 GMT

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

topic Re: use TNS alias during connection to Oracle in Talend Studio

use TNS alias during connection to Oracle

Re: use TNS alias during connection to Oracle