sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Martin, Nick" <NiMar...@pssd.com>
Subject Re: TNS: listener does not currently know of SID given in connect descriptor
Date Wed, 18 Sep 2013 22:53:01 GMT
That did the trick thanks Abe!

Sent from my iPhone

On Sep 18, 2013, at 6:36 PM, "Abraham Elmahrek" <abe@cloudera.com<mailto:abe@cloudera.com>>

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<http://scan.main.xxxx.com:1521/BIDEV>.


On Wed, Sep 18, 2013 at 12:18 PM, Sharath Punreddy <srpunreddy@gmail.com<mailto:srpunreddy@gmail.com>>
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 <NiMartin@pssd.com<mailto:NiMartin@pssd.com>>
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<http://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,

Thank you

Sharath Punreddy
2264 Shiloh Dr
Aurora, IL 60503.

View raw message