sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Abraham Fine <...@abrahamfine.com>
Subject Re: Sqoop Link Creation Issue: Invalid Oracle URL specified
Date Tue, 19 Apr 2016 18:06:20 GMT
Hi-

Try jdbc:oracle:thin:@testqa.com:1785/test <http://jdbc:oracle:thin@testqa.com: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 <games2013.sam@gmail.com> 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:thin@testqa.com:1785/test <http://jdbc:oracle:thin@testqa.com: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.


Mime
View raw message