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 Threaded View
Sqoop >> mail # user >> Sqoop oracle connection failure:Need help


Copy link to this message
-
Re: Sqoop oracle connection failure:Need help
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)
>>
>>         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
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