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 > <http://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 > <http://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.
