sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Martin, Nick" <NiMar...@pssd.com>
Subject Re: listener does not currently know of SID given in connect descriptor
Date Thu, 19 Sep 2013 23:13:14 GMT
That makes sense. Using Abe's suggestion got it working but thanks for the additional details.


Sent from my iPhone

On Sep 18, 2013, at 7:52 PM, "Kathleen Ting" <kathleen@apache.org> wrote:

> Nick, to follow-up with something Vikash pointed out re:  I think
> currently sqoop cannot support direct mode for Oracle.
> 
> Vikash is correct as the --direct parameter is ignored when no direct
> connector is available for a given database.
> 
> As shown in https://github.com/apache/sqoop/blob/trunk/src/java/org/apache/sqoop/manager/DefaultManagerFactory.java#L51
> - there is no direct connector for Oracle at this time. This means
> that using the --direct parameter with Oracle is harmless. The root
> cause, as Abe pointed out on a separate thread, is that the connection
> URL was malformed (should be
> jdbc:oracle:thin:@bidevrac-scan.main.xxxx.com:1521/BIDEV).
> 
> Regards, Kate
> 
> On Wed, Sep 18, 2013 at 9:47 AM, Vikash Talanki -X (vtalanki - INFOSYS
> LIMITED at Cisco) <vtalanki@cisco.com> wrote:
>> “Not all databases have available native utilities. Direct mode is not
>> available for every supported database. Out of the box, Sqoop has direct
>> support only for MySQL and PostgreSQL”
>> 
>> 
>> 
>> Above line is copied from Sqoop Cookbook.
>> 
>> I think currently sqoop cannot support direct mode for Oracle.
>> 
>> 
>> 
>> Also try replacing bidevrac-scan.main.xxxx.com with IP address of it. Also
>> make sure that this has an entry in /etc/hosts file on the machine where you
>> are running sqoop import
>> 
>> 
>> 
>> Regards
>> 
>> -----------------------
>> 
>> Vikash T
>> 
>> +1 (408)506 2024
>> 
>> 
>> 
>> From: Martin, Nick [mailto:NiMartin@pssd.com]
>> Sent: Wednesday, September 18, 2013 9:16 AM
>> To: user@sqoop.apache.org
>> Subject: TNS: listener does not currently know of SID given in connect
>> descriptor
>> 
>> 
>> 
>> Hi all,
>> 
>> 
>> 
>> I’ve stood up a new Hadoop cluster and am ready to use Sqoop to import some
>> data from our Oracle databases. This is the Sqoop command I’m attempting to
>> use, and the error is “TNS: listener does not currently know of SID given in
>> connect descriptor”.
>> 
>> 
>> 
>> sqoop-import --direct --connect
>> jdbc:oracle:thin:@bidevrac-scan.main.xxxx.com:1521:BIDEV --table DI_CALENDAR
>> –username xxx –password xxx --target-dir data
>> 
>> 
>> 
>> We’ve checked and re-checked the TNS/Oracle side and wondering if anyone
>> could help nudge us in the right direction.
>> 
>> 
>> 
>> Thanks in advance,
>> 
>> Nick

Mime
View raw message