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


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