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 >> TNS: listener does not currently know of SID given in connect descriptor


Copy link to this message
-
Re: TNS: listener does not currently know of SID given in connect descriptor
Hey Nick,

It looks like the connection you've provided is malformated. I think you
want  jdbc:oracle:thin:@bidevrac-scan.main.xxxx.com:1521/BIDEV.

-Abe
On Wed, Sep 18, 2013 at 12:18 PM, Sharath Punreddy <[EMAIL PROTECTED]>wrote:

> check this out:
> http://hortonworks.com/kb/using-apache-sqoop-for-data-import-from-relational-dbs/
>
>
>
>
> On Wed, Sep 18, 2013 at 11:16 AM, Martin, Nick <[EMAIL PROTECTED]> wrote:
>
>>  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****
>>
>
>
>
> --
> Thank you
>
> Sharath Punreddy
> 2264 Shiloh Dr
> Aurora, IL 60503.
> Phone:630-636-1175
>
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