sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alexander Alten-Lorenz <wget.n...@gmail.com>
Subject Re: Sqoop oracle connection failure:Need help
Date Sat, 31 Aug 2013 07:05:33 GMT
> 
> aused by: java.lang.RuntimeException: java.sql.SQLRecoverableException: IO Error: The
Network Adapter could not establish the connection
> 
This line in the stack trace looks like it's not able to connect to the database. Either the
URL is wrong or the server is not running. Check both the server and the URL.

- Alex


On Aug 30, 2013, at 10:44 PM, Krishnan Narayanan <krishnan.smile@gmail.com> wrote:

> Hi Tariq,
> 
> Thanks for your information.
> I am able to connect through sqlplus with same connection string..Not sure why its not
connecting from sqoop.
> 
> Thanks
> Krishnan
> 
> 
> On Fri, Aug 30, 2013 at 1:10 PM, Mohammad Tariq <dontariq@gmail.com> wrote:
> Hello Krishnan,
> 
> Please make sure you are using correct URL and you don't have any firewall or port related
issue. And first of all, your DB is running fine.
> 
> Warm Regards,
> Tariq
> cloudfront.blogspot.com
> 
> 
> On Sat, Aug 31, 2013 at 12:24 AM, Krishnan Narayanan <krishnan.smile@gmail.com>
wrote:
> Hi All,
> 
> Please help me fixing the below error.
> Thanks in advance.
> 
> sqoop import -Dmapred.job.queue.name=prd_foundation --connect jdbc:oracle:thin:@pprdapdrs.corp.xxx.net:1526/e9077
--username xxx –password xxx --fields-terminated-by '^' --target-dir /app/apd/sys_user_sl/data/acs_reporting/ACSABC
--table ACS.ABC
> 
>  
>  
> 13/08/29 18:14:07 WARN tool.BaseSqoopTool: Setting your password on the command-line
is insecure. Consider using -P instead.
> 
> 13/08/29 18:14:07 INFO manager.SqlManager: Using default fetchSize of 1000
> 
> 13/08/29 18:14:07 INFO tool.CodeGenTool: Beginning code generation
> 
> 13/08/29 18:14:27 INFO manager.OracleManager: Time zone has been set to GMT
> 
> 13/08/29 18:14:27 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM ACS.ABC
t WHERE 1=0
> 
> 13/08/29 18:14:27 INFO orm.CompilationManager: HADOOP_HOME is /usr/lib/hadoop
> 
> 13/08/29 18:14:27 INFO orm.CompilationManager: Found hadoop core jar at: /usr/lib/hadoop/hadoop-0.20.2-cdh3u4-core.jar
> 
> 13/08/29 18:14:28 INFO orm.CompilationManager: Writing jar file: /tmp/sqoop-sys_apd_sl/compile/42ce82f28dd4edc6cd06ceb451988943/ACS.ABC.jar
> 
> 13/08/29 18:14:28 INFO manager.OracleManager: Time zone has been set to GMT
> 
> 13/08/29 18:14:29 INFO manager.OracleManager: Time zone has been set to GMT
> 
> 13/08/29 18:14:29 INFO mapreduce.ImportJobBase: Beginning import of ACS.ABC
> 
> 13/08/29 18:14:29 INFO manager.OracleManager: Time zone has been set to GMT
> 
> 13/08/29 18:14:31 INFO hdfs.DFSClient: Created HDFS_DELEGATION_TOKEN token 2505324 for
sys_apd_sl
> 
> 13/08/29 18:14:31 INFO security.TokenCache: Got dt for hdfs://pprdda1hn.corp.xxx.net:54310/tmp/hadoop/tmp/hadoop-mapred/mapred/staging/sys_user_sl/.staging/job_201308220054_97333/libjars/ivy-2.0.0-rc2.jar;uri=10.145.10.160:54310;t.service=10.145.10.160:54310
> 
> 13/08/29 18:14:31 INFO db.DataDrivenDBInputFormat: BoundingValsQuery: SELECT MIN(ID),
MAX(ID) FROM ACS.ABC
> 
> 13/08/29 18:14:32 INFO mapred.JobClient: Running job: job_201308220054_97333
> 
> 13/08/29 18:14:33 INFO mapred.JobClient:  map 0% reduce 0%
> 
> 13/08/29 18:15:44 INFO mapred.JobClient: Task Id : attempt_201308220054_97333_m_000000_0,
Status : FAILED
> 
> java.lang.RuntimeException: java.lang.RuntimeException: java.sql.SQLRecoverableException:
IO Error: The Network Adapter could not establish the connection
> 
>         at com.cloudera.sqoop.mapreduce.db.DBInputFormat.setConf(DBInputFormat.java:166)
> 
>         at org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:62)
> 
>         at org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:117)
> 
>         at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:606)
> 
>         at org.apache.hadoop.mapred.MapTask.run(MapTask.java:323)
> 
>         at org.apache.hadoop.mapred.Child$4.run(Child.java:270)
> 
>         at java.security.AccessController.doPrivileged(Native Method)
> 
>         at javax.security.auth.Subject.doAs(Subject.java:396)
> 
>         at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1177)
> 
>         at org.apache.hadoop.mapred.Child.main(Child.java:264)
> 
> Caused by: java.lang.RuntimeException: java.sql.SQLRecoverableException: IO Error: The
Network Adapter could not establish the connection
> 
>         at com.cloudera.sqoop.mapreduce.db.DBInputFo
> 
> 
> 
> Thx
> 
> Krishnan
> 
> 
> 

--
Alexander Alten-Lorenz
http://mapredit.blogspot.com
German Hadoop LinkedIn Group: http://goo.gl/N8pCF


Mime
View raw message