Abe, Thanks so much! It worked.
On Tue, Apr 19, 2016 at 2:06 PM, Abraham Fine <[email protected]> wrote: > Hi- > > Try jdbc:oracle:thin:@testqa.com:1785/test > <http://jdbc:oracle:[email protected]:1785/test> (notice the extra colon > between thin and @). > > In an effort to determine if the issue is Sqoop or Oracle jdbc related > would you be able to try a tool like SQuirreLSQL and see if you can connect > to the database? > > Thanks, > Abe > > On Apr 19, 2016, at 10:50 AM, Sam Joe <[email protected]> wrote: > > Hi, > > > I'm facing some issues while trying to create a link in Sqoop 1.99.6. > > sqoop:000> update link --lid 1 > Updating link with id 1 > Please update link: > Name: OracleLinkqa > > Link configuration > > JDBC Driver Class: oracle.jdbc.driver.OracleDriver > JDBC Connection String: jdbc:oracle://testqa.com:1785/test > Username: samuid > Password: *********** > JDBC Connection Properties: > There are currently 1 values in the map: > protocol = tcp > entry# > > There were warnings while create or update, but saved successfully. > Warning message: Can't connect to the database with given credentials: > Invalid Oracle URL specified > link was successfully updated with status WARNING > > > I've tried with the following: > > - using ip address instead of hostname > - using service name and sid > - jdbc:oracle:[email protected]:1785/test > > I've placed the ojdbc6.jar in > /usr/lib/sqoop/sqoop-1.99.6-bin-hadoop200/server/lib and > /usr/lib/sqoop/sqoop-1.99.6-bin-hadoop200/shell/lib locations. > > Please help. > > Thanks. > > >
