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 >
