One Star

TOS 5.1 & 5.6 Oracle Dataguard Conenction

Hi, i'm using TOS 5.1 & 5.6; my application must connect Oracle Dataguard with a connection like : 
jdbcSmiley Surprisedracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=my_host)(PORT=1532))(ADDRESS=(PROTOCOL=TCP)(HOST=my_host)(PORT=1532)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=my_s_name)))
But it doesn't work; It works with a standard connection String like jdbcSmiley Surprisedracle:thin:@//my_host:1532/service_name
I found this old Jira : 

Does someone have any solution to avoid this bug and use Dataguard Oracle ?
Is this jira resolved in TOS 5.x ? It was a jira for TOS 4.x ?
Thanks in advance for your help.
Fred
9 REPLIES
One Star

Re: TOS 5.1 & 5.6 Oracle Dataguard Conenction

Moderator

Re: TOS 5.1 & 5.6 Oracle Dataguard Conenction

Hi Fred,
Can you use Generic JDBC Metadata wizard and JDBC components with Oracle driver to work with Dataguard? So far, talend don't support for Data Guard connectivity. Please vote for this jira issue.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: TOS 5.1 & 5.6 Oracle Dataguard Conenction

Hi, Thanx for your reply, 
I'm using jdbc component to connect databases and to query too. Connection params (url, driver, etc) came from a configuration file.
Cause I don't know in advance if it'll be an oracle or a postgresql DB, i had to use Jdbc component. 
Which test do you want me to do ? 
Moderator

Re: TOS 5.1 & 5.6 Oracle Dataguard Conenction

Hi fbourelly,
Thanks for your feedback. So you can use  Jdbc component to connect oracle dataguard successfully? Feel free to vote for this jira issue.

Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: TOS 5.1 & 5.6 Oracle Dataguard Conenction

Hi, 
i already tried to use the dataguard connection String in the jdbc Component without success. This is why i came here to ask for help Smiley Happy
Moderator

Re: TOS 5.1 & 5.6 Oracle Dataguard Conenction

Hi,
What's the error information you are facing when you use Generic JDBC Metadata wizard + JDBC components with Oracle driver to work with Dataguard?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: TOS 5.1 & 5.6 Oracle Dataguard Conenction

Error : 
2015-06-22 14:52:52,486 ERROR - Admin job failed
Exception in component tJDBCConnection_5
java.sql.SQLRecoverableException: Erreur d'E/S: Unknown host specified
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:458)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:546)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:236)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at etl.admin_0_1.Admin.tJDBCConnection_5Process(Admin.java:4298)
at etl.admin_0_1.Admin.tJDBCRollback_1Process(Admin.java:4236)
at etl.admin_0_1.Admin.tLog4J_7Process(Admin.java:4150)
at etl.admin_0_1.Admin.tJava_7Process(Admin.java:4034)
at etl.admin_0_1.Admin.tPostjob_1Process(Admin.java:3951)
at etl.admin_0_1.Admin.runJobInTOS(Admin.java:17689)
at etl.admin_0_1.Admin.main(Admin.java:17172)
Caused by: oracle.net.ns.NetException: Unknown host specified
at oracle.net.resolver.HostnameNamingAdapter.resolve(HostnameNamingAdapter.java:191)
at oracle.net.resolver.NameResolver.resolveName(NameResolver.java:133)
at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:416)
at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:687)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:247)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1102)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:320)
... 13 more
Moderator

Re: TOS 5.1 & 5.6 Oracle Dataguard Conenction

Hi fbourelly,
Can you connect to your Dataguard successfully through client without using Talend Tool?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: TOS 5.1 & 5.6 Oracle Dataguard Conenction

Sorry for my late reply.
Yes it works with others softwares than Talend Smiley Sad   (as the Admins said to me, cause i can't go on Production environment to test. I trust them)