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

Switch to Plain View
Sqoop, mail # user - FW: Unable to connect to oracle database from sqoop


+
Manickam P 2013-06-20, 13:34
+
Jérôme Verdier 2013-06-20, 14:04
+
Jarek Jarcec Cecho 2013-06-20, 14:55
Copy link to this message
-
RE: Unable to connect to oracle database from sqoop
Manickam P 2013-06-21, 05:54
Hi,
Given below is the scoop script i used.  ./sqoop list-databases --connect jdbc:oracle:thin:@localhost:1521/cp --username scott --password tigerJDBC driver directory - which directory you mean here? i have put ojdbc jar in sqoop lib folder. Is that fine or am i missing anything here?

Thanks,
Manickam P
Date: Thu, 20 Jun 2013 16:04:50 +0200
Subject: Re: FW: Unable to connect to oracle database from sqoop
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]

Hi,

Please send your Sqoop script, and the output of "ls" command on your JDBC driver directory.

Thanks
2013/6/20 Manickam P <[EMAIL PROTECTED]>
Hi,

I am trying to import details from oracle through sqoop but i got the below error.
   13/06/20 09:09:21 ERROR manager.OracleManager: Failed to list databasesjava.sql.SQLException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

I've put an entry into the TNSname.ora file and also added ojdbc jar with sqoop lib folder.
Please help me to resolve the issue.
Thanks,
Manickam P
         

     
+
Michal Taborsky 2013-06-21, 06:47
+
Manickam P 2013-06-21, 07:08
+
Michal Taborsky 2013-06-21, 07:29
+
Manickam P 2013-06-21, 07:39
+
Michal Taborsky 2013-06-21, 07:45
+
Manickam P 2013-06-21, 07:57
+
Michal Taborsky 2013-06-21, 09:13
+
Manickam P 2013-06-21, 09:39
+
Venkat 2013-06-21, 14:20