re?
>
>
> Thanks,
> Manickam P
>
> --
> Date: Fri, 21 Jun 2013 11:13:01 +0200
>
> Subject: Re: Unable to connect to oracle database from sqoop
> From: michal.tabor...@gmail.com
> To: user@sqoop.apache.org
>
> Hi.
>
> Use complete table name together with
here?
Thanks,
Manickam P
Date: Fri, 21 Jun 2013 11:13:01 +0200
Subject: Re: Unable to connect to oracle database from sqoop
From: michal.tabor...@gmail.com
To: user@sqoop.apache.org
Hi.
Use complete table name together with schema in upper case (ie.
SCOTT.EMPLOYEE). Also, specify column names in
l Taborsky
>
>
> 2013/6/21 Manickam P
>
> Hi Michal,
>
> Here i have provided the details available in my TNSNames.ora file.
>
> MYTNSNAME=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL = TCP)(HOST =
> MyIPAddress)(PORT = 1521)))(CONNECT_DATA=(SERVICE_NAME = CP.MYTNSNAME)))
>
ubject: Re: Unable to connect to oracle database from sqoop
From: michal.tabor...@gmail.com
To: user@sqoop.apache.org
OK, so either use this connection parameter:
--connect
"jdbc:oracle:thin:scott/tiger@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MyIPAddress)(PORT=1521))(CONNECT_DATA=(S
(SERVICE_NAME = CP.MYTNSNAME)))
>
>
>
> Thanks,
> Manickam P
> --
> Date: Fri, 21 Jun 2013 09:29:30 +0200
>
> Subject: Re: Unable to connect to oracle database from sqoop
> From: michal.tabor...@gmail.com
> To: user@sqoop.apache.org
>
>
: Unable to connect to oracle database from sqoop
From: michal.tabor...@gmail.com
To: user@sqoop.apache.org
Well, it looks that you indeed do not have a service "cp" running on your
listener (service is something different than SID, is something different than
database name and is something
ckam P
>
> Hi,
>
> Given below is the scoop script i used.
>
>
> ./sqoop list-databases --connect jdbc:oracle:thin:@localhost:1521/cp
> --username scott --password tiger
>
> JDBC driver directory - which directory you mean here? i have put ojdbc
> jar in sqoop lib folder.
> Is that fine or am i missi
ver.T4CConnection.connect(T4CConnection.java:1102)at
oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:320)... 16
more
Thanks,
Manickam P
Date: Fri, 21 Jun 2013 08:47:11 +0200
Subject: Re: Unable to connect to oracle database from sqoop
From: michal.tabor...@gmail.com
To: user@sqoop.a
d tiger
>
> JDBC driver directory - which directory you mean here? i have put ojdbc
> jar in sqoop lib folder.
> Is that fine or am i missing anything here?
>
>
> Thanks,
> Manickam P
>
> ----------
> Date: Thu, 20 Jun 2013 16:04:50 +0200
?
Thanks,
Manickam P
Date: Thu, 20 Jun 2013 16:04:50 +0200
Subject: Re: FW: Unable to connect to oracle database from sqoop
From: verdier.jerom...@gmail.com
To: user@sqoop.apache.org
Hi,
Please send your Sqoop script, and the output of "ls" command on your JDBC
driver directory.
Thanks
Hi Manickam,
it's hard to guess what is happening without the additional information that
Jerome has asked for.
But nevertheless, my guestimate would be that your JDBC URL contains wrong
service name and therefore the ORA-12514 is thrown. I would suggest to contact
your database administrator t
Hi,
Please send your Sqoop script, and the output of "ls" command on your JDBC
driver directory.
Thanks
2013/6/20 Manickam P
> Hi,
>
> I am trying to import details from oracle through sqoop but i got the
> below error.
>13/06/20 09:09:21 ERROR manager.OracleManager: Failed to list databa
Hi,
I am trying to import details from oracle through sqoop but i got the below
error.13/06/20 09:09:21 ERROR manager.OracleManager: Failed to list
databasesjava.sql.SQLException: Listener refused the connection with the
following error:ORA-12514, TNS:listener does not currently know of ser
13 matches
Mail list logo
