Return-Path: X-Original-To: apmail-hadoop-hdfs-user-archive@minotaur.apache.org Delivered-To: apmail-hadoop-hdfs-user-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 8C3CA10BD8 for ; Sat, 31 Aug 2013 07:01:11 +0000 (UTC) Received: (qmail 61948 invoked by uid 500); 31 Aug 2013 07:01:05 -0000 Delivered-To: apmail-hadoop-hdfs-user-archive@hadoop.apache.org Received: (qmail 61820 invoked by uid 500); 31 Aug 2013 07:01:04 -0000 Mailing-List: contact user-help@hadoop.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hadoop.apache.org Delivered-To: mailing list user@hadoop.apache.org Received: (qmail 61813 invoked by uid 99); 31 Aug 2013 07:01:04 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 31 Aug 2013 07:01:04 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of prameshfrz@gmail.com designates 209.85.192.182 as permitted sender) Received: from [209.85.192.182] (HELO mail-pd0-f182.google.com) (209.85.192.182) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 31 Aug 2013 07:00:57 +0000 Received: by mail-pd0-f182.google.com with SMTP id r10so2728367pdi.13 for ; Sat, 31 Aug 2013 00:00:36 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:date:message-id:subject:from:to:content-type; bh=OU81zo6nPwbYWCN4m1/EPc/vjPwpZSyt7sQdfFHBD3U=; b=rYhqtOsnlz2FgT1RragW/ldCe6u2hg1V+Os7Owyz3ZZ7PiYnR+4/WXZbwJOYplv9x2 6NRT02NyVht24UqI8mAfUd3W1I8M5KjiGmrvC4FELg0ZbY96tUPhiXV+ozDFhaFqedAA dP97xmPb9nJkq2pjOScjg9PgoZ0CGtAqbEfsvg2sTkpltSqZ1iID6vxH4YuxdaKXzw4o 6hzseLHTLxJqITwMbRAGQANzXavzNDIoUpsJjh2WCs1U9QZbEWjKJI2vGphegOKMXoZ6 gETtOvtWroFLJRQKBQI9HMCJcTBPLVA39GUz96au12MyR5nnT09azs/Esp5N5+d4B1Kz fgKA== MIME-Version: 1.0 X-Received: by 10.68.134.133 with SMTP id pk5mr14201338pbb.89.1377932435936; Sat, 31 Aug 2013 00:00:35 -0700 (PDT) Received: by 10.66.218.99 with HTTP; Sat, 31 Aug 2013 00:00:35 -0700 (PDT) Date: Sat, 31 Aug 2013 12:30:35 +0530 Message-ID: Subject: sqoop oracle connection error From: Ram To: "user@hadoop.apache.org" Content-Type: multipart/alternative; boundary=047d7b11190b5e5cf504e538e51a X-Virus-Checked: Checked by ClamAV on apache.org --047d7b11190b5e5cf504e538e51a Content-Type: text/plain; charset=ISO-8859-1 Hi, I am trying to import table from oracle hdfs. i am getting the following error ERROR manager.SqlManager: Error executing statement: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection any work around this. the query is: sqoop import --connect jdbc:oracle:thin:@//ramesh.ops.cloudwick.com/cloud--username ramesh --password password --table cloud.test -m 1 the output is as follows; [root@ramesh ram]# sqoop import --connect jdbc:oracle:thin:@// ramesh.ops.cloudwick.com/cloud --username ramesh --password password --table cloud.test -m 1 Warning: /usr/lib/hbase does not exist! HBase imports will fail. Please set $HBASE_HOME to the root of your HBase installation. 13/08/31 12:27:27 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead. 13/08/31 12:27:27 INFO manager.SqlManager: Using default fetchSize of 1000 13/08/31 12:27:27 INFO tool.CodeGenTool: Beginning code generation 13/08/31 12:27:27 ERROR manager.SqlManager: Error executing statement: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:458) at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:546) at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:236) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521) at java.sql.DriverManager.getConnection(DriverManager.java:571) at java.sql.DriverManager.getConnection(DriverManager.java:215) at org.apache.sqoop.manager.OracleManager.makeConnection(OracleManager.java:313) at org.apache.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:52) at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:605) at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:628) at org.apache.sqoop.manager.SqlManager.getColumnTypesForRawQuery(SqlManager.java:235) at org.apache.sqoop.manager.SqlManager.getColumnTypes(SqlManager.java:219) at org.apache.sqoop.manager.ConnManager.getColumnTypes(ConnManager.java:347) at org.apache.sqoop.orm.ClassWriter.getColumnTypes(ClassWriter.java:1255) at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1072) at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:82) at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:390) at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:476) at org.apache.sqoop.Sqoop.run(Sqoop.java:145) at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65) at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229) at org.apache.sqoop.Sqoop.main(Sqoop.java:238) Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:392) at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:434) at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:687) at oracle.net.ns.NSProtocol.connect(NSProtocol.java:247) at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1102) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:320) ... 24 more Caused by: java.net.ConnectException: Connection refused at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339) at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200) at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) at java.net.Socket.connect(Socket.java:579) at oracle.net.nt.TcpNTAdapter.connect(TcpNTAdapter.java:150) at oracle.net.nt.ConnOption.connect(ConnOption.java:133) at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:370) ... 29 more 13/08/31 12:27:27 ERROR manager.OracleManager: Failed to rollback transaction java.lang.NullPointerException at org.apache.sqoop.manager.OracleManager.getColumnNames(OracleManager.java:744) at org.apache.sqoop.orm.ClassWriter.getColumnNames(ClassWriter.java:1222) at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1074) at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:82) at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:390) at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:476) at org.apache.sqoop.Sqoop.run(Sqoop.java:145) at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65) at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229) at org.apache.sqoop.Sqoop.main(Sqoop.java:238) 13/08/31 12:27:27 ERROR manager.OracleManager: Failed to list columns java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:458) at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:546) at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:236) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521) at java.sql.DriverManager.getConnection(DriverManager.java:571) at java.sql.DriverManager.getConnection(DriverManager.java:215) at org.apache.sqoop.manager.OracleManager.makeConnection(OracleManager.java:313) at org.apache.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:52) at org.apache.sqoop.manager.OracleManager.getColumnNames(OracleManager.java:728) at org.apache.sqoop.orm.ClassWriter.getColumnNames(ClassWriter.java:1222) at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1074) at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:82) at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:390) at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:476) at org.apache.sqoop.Sqoop.run(Sqoop.java:145) at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65) at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229) at org.apache.sqoop.Sqoop.main(Sqoop.java:238) Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:392) at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:434) at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:687) at oracle.net.ns.NSProtocol.connect(NSProtocol.java:247) at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1102) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:320) ... 20 more Caused by: java.net.ConnectException: Connection refused at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339) at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200) at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) at java.net.Socket.connect(Socket.java:579) at oracle.net.nt.TcpNTAdapter.connect(TcpNTAdapter.java:150) at oracle.net.nt.ConnOption.connect(ConnOption.java:133) at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:370) ... 25 more 13/08/31 12:27:27 ERROR tool.ImportTool: Imported Failed: Attempted to generate class with no columns! [root@ramesh ram]# Thanks, Ramesh. --047d7b11190b5e5cf504e538e51a Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable

Hi,
=A0 =A0I am= trying to import table from oracle hdfs. i am getting the following error= =A0

ERROR= manager.SqlManager: Error executing statement: java.sql.SQLRecoverableExce= ption: IO Error: The Network Adapter could not establish the connection
java.sql.SQLRecoverableException: IO Error: The Network Ad= apter could not establish the connection

any work around this.

the query is:=

sqoop import --connect jdbc:oracle:thin:@//= ramesh.ops.cloudwick.com/= cloud --username ramesh --password password --table cloud.test -m 1

the output is as follows;

[root@ramesh ram]# sqoop import --connect jd= bc:oracle:thin:@//ramesh.= ops.cloudwick.com/cloud --username ramesh --password password --table c= loud.test -m 1
Warning: /usr/lib/hbase does not exist! HBase imports will fail.
=
Please set $HBASE_HOME to the root of your HBase installation.
13/08/31 12:27:27 WARN tool.BaseSqoopTool: Setting your password on the = command-line is insecure. Consider using -P instead.
13/08/31 12:27:27 INFO manager.SqlManager: Using default fetchSize of = 1000
13/08/31 12:27:27 INFO tool.CodeGenTool: Beginning code gene= ration
13/08/31 12:27:27 ERROR manager.SqlManager: Error executin= g statement: java.sql.SQLRecoverableException: IO Error: The Network Adapte= r could not establish the connection
java.sql.SQLRecoverableException: IO Error: The Network Adapter could = not establish the connection
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java= :458)
at oracle.jdbc.driv= er.PhysicalConnection.<init>(PhysicalConnection.java:546)
<= span class=3D"" style=3D"white-space:pre"> at oracle.jdbc.driver.T4C= Connection.<init>(T4CConnection.java:236)
at oracle.jdbc.driv= er.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
<= span class=3D"" style=3D"white-space:pre"> at oracle.jdbc.driver.Ora= cleDriver.connect(OracleDriver.java:521)
at java.sql.DriverM= anager.getConnection(DriverManager.java:571)
at java.sql.DriverManager.getConnection(Driv= erManager.java:215)
at org.apache.sqoop= .manager.OracleManager.makeConnection(OracleManager.java:313)
at org.apache.sqoop.manager= .GenericJdbcManager.getConnection(GenericJdbcManager.java:52)
at org.apache.sqoop= .manager.SqlManager.execute(SqlManager.java:605)
at org.apache.sqoop.manager.SqlManager.e= xecute(SqlManager.java:628)
at org.apache.sqoop= .manager.SqlManager.getColumnTypesForRawQuery(SqlManager.java:235)
at org.apache.sqoop.ma= nager.SqlManager.getColumnTypes(SqlManager.java:219)
at org.apache.sqoop= .manager.ConnManager.getColumnTypes(ConnManager.java:347)
at org.apache.sqoop.orm.ClassWr= iter.getColumnTypes(ClassWriter.java:1255)
at org.apache.sqoop= .orm.ClassWriter.generate(ClassWriter.java:1072)
at org.apache.sqoop.tool.CodeGenTool.gen= erateORM(CodeGenTool.java:82)
at org.apache.sqoop= .tool.ImportTool.importTable(ImportTool.java:390)
at org.apache.sqoop.tool.ImportTool.run= (ImportTool.java:476)
at org.apache.sqoop= .Sqoop.run(Sqoop.java:145)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
at org.apache.sqoop= .Sqoop.runSqoop(Sqoop.java:181)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220)
at org.apache.sqoop.S= qoop.runTool(Sqoop.java:229)
at org.apache.sqoop= .Sqoop.main(Sqoop.java:238)
Caused by: oracle.net.ns.NetException= : The Network Adapter could not establish the connection
at oracle.net.nt.ConnStrategy.ex= ecute(ConnStrategy.java:392)
at oracle.net.resol= ver.AddrResolution.resolveAndExecute(AddrResolution.java:434)
at oracle.net.ns.NSProtocol= .establishConnection(NSProtocol.java:687)
at oracle.net.ns.NS= Protocol.connect(NSProtocol.java:247)
at oracle.jdbc.driver.T4CConnection.connect(T4CConn= ection.java:1102)
at oracle.jdbc.driv= er.T4CConnection.logon(T4CConnection.java:320)
... 24 more
Caused by: java.net.= ConnectException: Connection refused
at java.net.PlainSo= cketImpl.socketConnect(Native Method)
at java.net.AbstractPlainSocketImpl.doConnect(Abstr= actPlainSocketImpl.java:339)
at java.net.Abstrac= tPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
at java.net.AbstractP= lainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
at java.net.SocksSo= cketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:579)
at oracle.net.nt.TcpNTAd= apter.connect(TcpNTAdapter.java:150)
at oracle.net.nt.ConnOption.connect(ConnOption.java:= 133)
at oracle.net.nt.Co= nnStrategy.execute(ConnStrategy.java:370)
... 29 more
13/08/31 12:27:27 ERROR = manager.OracleManager: Failed to rollback transaction
java.lang.NullPointerException
at org.apache.sqoop.manager.OracleManager.getColumnNa= mes(OracleManager.java:744)
at org.apache.sqoop.orm.ClassWriter.getColumnNames(ClassWrite= r.java:1222)
at org.apache.sqoop= .orm.ClassWriter.generate(ClassWriter.java:1074)
at org.apache.sqoop.tool.CodeGenTool.gen= erateORM(CodeGenTool.java:82)
at org.apache.sqoop= .tool.ImportTool.importTable(ImportTool.java:390)
at org.apache.sqoop.tool.ImportTool.run= (ImportTool.java:476)
at org.apache.sqoop= .Sqoop.run(Sqoop.java:145)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
at org.apache.sqoop= .Sqoop.runSqoop(Sqoop.java:181)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220)
at org.apache.sqoop.S= qoop.runTool(Sqoop.java:229)
at org.apache.sqoop= .Sqoop.main(Sqoop.java:238)
13/08/31 12:27:27 ERROR manager.Oracl= eManager: Failed to list columns
java.sql.SQLRecoverableException= : IO Error: The Network Adapter could not establish the connection
at oracle.jdbc.driv= er.T4CConnection.logon(T4CConnection.java:458)
at oracle.jdbc.driver.PhysicalConnection.&= lt;init>(PhysicalConnection.java:546)
at oracle.jdbc.driv= er.T4CConnection.<init>(T4CConnection.java:236)
at oracle.jdbc.driver.T4CDriverExte= nsion.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driv= er.OracleDriver.connect(OracleDriver.java:521)
at java.sql.DriverManager.getConnection(Dr= iverManager.java:571)
at java.sql.DriverM= anager.getConnection(DriverManager.java:215)
at org.apache.sqoop.manager.OracleManager.ma= keConnection(OracleManager.java:313)
at org.apache.sqoop= .manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:52)
=
at org.apache.sqoop= .manager.OracleManager.getColumnNames(OracleManager.java:728)
at org.apache.sqoop= .orm.ClassWriter.getColumnNames(ClassWriter.java:1222)
at org.apache.sqoop.orm.ClassWrite= r.generate(ClassWriter.java:1074)
at org.apache.sqoop= .tool.CodeGenTool.generateORM(CodeGenTool.java:82)
at org.apache.sqoop.tool.ImportTool.im= portTable(ImportTool.java:390)
at org.apache.sqoop= .tool.ImportTool.run(ImportTool.java:476)
at org.apache.sqoop.Sqoop.run(Sqoop.java:145)<= /div>
at org.apache.hadoo= p.util.ToolRunner.run(ToolRunner.java:65)
at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:= 181)
at org.apache.sqoop= .Sqoop.runTool(Sqoop.java:220)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229)
at org.apache.sqoop.Sq= oop.main(Sqoop.java:238)
Caused by: oracle.net.ns.NetException: The Network Adapter could not e= stablish the connection
at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:392)
at oracle.net.resol= ver.AddrResolution.resolveAndExecute(AddrResolution.java:434)
at oracle.net.ns.NSProtocol= .establishConnection(NSProtocol.java:687)
at oracle.net.ns.NS= Protocol.connect(NSProtocol.java:247)
at oracle.jdbc.driver.T4CConnection.connect(T4CConn= ection.java:1102)
at oracle.jdbc.driv= er.T4CConnection.logon(T4CConnection.java:320)
... 20 more
Caused by: java.net.= ConnectException: Connection refused
at java.net.PlainSo= cketImpl.socketConnect(Native Method)
at java.net.AbstractPlainSocketImpl.doConnect(Abstr= actPlainSocketImpl.java:339)
at java.net.Abstrac= tPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
at java.net.AbstractP= lainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
at java.net.SocksSo= cketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:579)
at oracle.net.nt.TcpNTAd= apter.connect(TcpNTAdapter.java:150)
at oracle.net.nt.ConnOption.connect(ConnOption.java:= 133)
at oracle.net.nt.Co= nnStrategy.execute(ConnStrategy.java:370)
... 25 more
13/08/31 12:27:27 ERROR = tool.ImportTool: Imported Failed: Attempted to generate class with no colum= ns!
[root@ramesh ram]#=A0



Thanks,
Ram= esh.


--047d7b11190b5e5cf504e538e51a--