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
