Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

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


Copy link to this message
-
Sqoop oracle connection failure:Need help
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
+
Mohammad Tariq 2013-08-30, 20:10
+
Krishnan Narayanan 2013-08-30, 20:44
+
Alexander Alten-Lorenz 2013-08-31, 07:05
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB