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