One Star

Connecting to Oracle RAC doesn't work

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!
8 REPLIES
Employee

Re: Connecting to Oracle RAC doesn't work

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

Re: Connecting to Oracle RAC doesn't work

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

Re: Connecting to Oracle RAC doesn't work

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!
One Star

Re: Connecting to Oracle RAC doesn't work

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

Re: Connecting to Oracle RAC doesn't work

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.
One Star

Re: Connecting to Oracle RAC doesn't work

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

Re: Connecting to Oracle RAC doesn't work

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

Re: Connecting to Oracle RAC doesn't work

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.