topic Re: Connecting to Oracle RAC doesn't work in Talend Studio

Connecting to Oracle RAC doesn't work

Anonymous — Sat, 16 Nov 2024 14:24:17 GMT

I am trying to get Talend 2.3.1 to connect to an Oracle Real Application Cluster (RAC) database instance.
In tOracleConnection or while creating a new connection in Metadata, I get connection failure using both "Oracle SID" or "Oracle Service Name". A connection in Talend requires a host/server name and there are multiple hosts in a RAC implementation.
Our production database is a RAC, so none of my Dev jobs that require Oracle connection will work against Prod. Is there a way to solve this issue?
Thanks!

Re: Connecting to Oracle RAC doesn't work

Anonymous — Fri, 04 Apr 2008 00:17:03 GMT

Are you running a Perl or a Java project? (independantly of the project language, metadata database connection always uses the Java JDBC driver)

Re: Connecting to Oracle RAC doesn't work

Anonymous — Fri, 04 Apr 2008 01:12:55 GMT

Hi,
I am using Java and it uses JDBC as you said.
Thanks.

Re: Connecting to Oracle RAC doesn't work

Anonymous — Mon, 07 Apr 2008 19:15:23 GMT

Hi,
It works when I connect using Service Name option and specify one of the multiple hosts as Server. But that defeats the purpose of RAC. Should it be logged as a bug?
Appreciate any help.
Thanks!

Re: Connecting to Oracle RAC doesn't work

_AnonymousUser — Mon, 10 Nov 2008 18:20:24 GMT

Try connecting to the RAC instance.
See this link for more information
http://www.datadirect.com/developer/odbc/odbc_oracle_rac/connecting/index.ssp

Re: Connecting to Oracle RAC doesn't work

Anonymous — Fri, 19 Feb 2010 11:38:24 GMT

Hello all.
I've got the same problem. Talend TOS does not provide a way to enter a oracle connect string that contains all cluster nodes for failover.
The link provided by rkutty does not offer a solution to this.
Best regards,
Alexander.

Re: Connecting to Oracle RAC doesn't work

_AnonymousUser — Thu, 03 Feb 2011 14:14:47 GMT

TIS doesn't full support to Oracle RAC.
What we sould have :
Java Option : -Doracle.net.tns_admin=<path_to_tnsnames_directory>
JDBC URL : jdbc racle:thin:@<service_name> (i.e. jdbc racle:thin:@MyApplication)
ojbc14 >= Oracle 10.2.0.1
We shouldn't specify server informations (hostname, port, ...)

Re: Connecting to Oracle RAC doesn't work

_AnonymousUser — Thu, 03 Feb 2011 14:56:07 GMT

Java option is missing when we execute a job in TIS.
It works outside TIS (export as script)

Re: Connecting to Oracle RAC doesn't work

_AnonymousUser — Thu, 25 Aug 2011 16:09:43 GMT

Java option is missing when we execute a job in TIS.
It works outside TIS (export as script)

Set the property in java via System.setProperty("oracle.net.tns_admin","<TNS_ORA_PATH>") and then use the connection.