Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
HDFS >> mail # user >> sqoop oracle connection error


Copy link to this message
-
Re: sqoop oracle connection error
Hi ,
   Can you check if you are able to ping or telnet to the ip address and
port of Oracle database from your machine.  I have a hunch that Oracle
Listener is stopped . If so , start it.
The commands to check the status and start if the listener isn't running.

$ lsnrctl status
$ lsnrctl start

Regards

Ravi Magham
On Sat, Aug 31, 2013 at 2:05 PM, Krishnan Narayanan <
[EMAIL PROTECTED]> wrote:

> Hi Ram,
>
> I get the same error.If you find an answer pls dp fwd it to me. I will do
> the same.
>
> Thx
> Krish
>
>
> On Sat, Aug 31, 2013 at 12:00 AM, Ram <[EMAIL PROTECTED]> wrote:
>
>>
>> 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.<init>(PhysicalConnection.java:546)
>> at oracle.jdbc.driver.T4CConnection.<init>(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)