Connecting to Oracle RAC doesn't work

[Anonymous]

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!

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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!

[_AnonymousUser]

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

[Anonymous]

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.

[_AnonymousUser]

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, ...)

[_AnonymousUser]

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

[_AnonymousUser]

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.