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