sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sam Joe <games2013....@gmail.com>
Subject Re: Sqoop Link Creation Issue: Invalid Oracle URL specified
Date Tue, 19 Apr 2016 18:27:01 GMT
Abe, Thanks so much! It worked.


On Tue, Apr 19, 2016 at 2:06 PM, Abraham Fine <abe@abrahamfine.com> wrote:

> 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
> 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
>
> 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