Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
Sqoop >> mail # user >> RE: listener does not currently know of SID given in connect descriptor


Copy link to this message
-
Re: listener does not currently know of SID given in connect descriptor
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" <[EMAIL PROTECTED]> 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) <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED]]
>> Sent: Wednesday, September 18, 2013 9:16 AM
>> To: [EMAIL PROTECTED]
>> 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
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB