One Star

Exadata Migration issue

HI,
We are migrating from oracle 11g to Exadata , but we are facing a very peculiar scenario which is mentioned below,
Job: 21 toracleinput components parallely run and fetch data from exadata and dump the data into files.
Issue: out of 21 toracleinput components some of the toracleinput components extract the data properly and rest fail giving the error
Exception in component tOracleInput_2
java.sql.SQLException: Io exception: Got minus one from a read call
wierd part is out 21 toracleinputs, the number of toracleinputs that extract the data is not constant sometimes 10 get extracted properly sometimes 15.
We are using Talend version 5.3.1.
Note: The code was working properly on oracle 11g.
Thanks,
6 REPLIES
Four Stars

Re: Exadata Migration issue

Hi,
Whether these 21 inputs are for different tables in Oracle?
Whether data is consistent in all these tables with target metadata defined for flat files?
What is mean by Code was working properly on oracle 11g. You are doing migration activity from oracle to exadata. So what is the relation with above statement?
Can you please explain?
Thanks
Vaibhav
One Star

Re: Exadata Migration issue

Whether these 21 inputs are for different tables in Oracle?
Ans:Yes 21 different tables.
Whether data is consistent in all these tables with target metadata defined for flat files?
Ans:Yes it is consistent.
What is meant by Code was working properly on oracle 11g. You are doing migration activity from oracle to exadata. So what is the relation with above statement?
Ans:This particular code has been working fine since june2013, last week the source database was moved from 11g to exadata, typically our code should work fine by just changing the connection parameters right but it is not happening.

Thanks,
Koustubh Avadhani
Four Stars

Re: Exadata Migration issue

Hi Koustubh,
Have you checked the java versions between old and new machines?
drivers required for the connectivity on new machine for oracle?
I think this is related to jdbc drivers or similar issue.
Vaibhav
One Star

Re: Exadata Migration issue

Hi Vaibhav,
thanks for your answers.

Have you checked the java versions between old and new machines?
We are running talend from windows server with java version "1.7.0_01" which has not changed (so only one machine not two old and new),only the source db has changed to exadata.
drivers required for the connectivity on new machine for oracle?
I think this is related to jdbc drivers or similar issue.
ya we thought so too ,so we dowloaded the latest jdbc drivers from oracle site and have placed in the talends lib folder.
still didnot work.
Thanks,
Koustubh Avadhani
One Star

Re: Exadata Migration issue

Hi All,
Can we extract data from Oracle Exadata using talend 5.3.1??

Thanks,
Koustubh Avadhani
One Star

Re: Exadata Migration issue

Hi all,
Are there any specific changes you need to do when connecting to exadata through talend 5.3.1 .
Thanks,
Koustubh Avadhani