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

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