Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Sqoop, mail # user - Sqoop oracle connection failure:Need help


+
Krishnan Narayanan 2013-08-30, 18:54
Copy link to this message
-
Re: Sqoop oracle connection failure:Need help
Mohammad Tariq 2013-08-30, 20:10
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 <
[EMAIL PROTECTED]> 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
>
+
Krishnan Narayanan 2013-08-30, 20:44
+
Alexander Alten-Lorenz 2013-08-31, 07:05