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 >> >> at com.cloudera.sqoop.mapreduce.db.DBInputFo >> >> >> Thx >> >> Krishnan >> > >
