Re: Unable to connect to oracle database from sqoop

2013-06-21 Thread Venkat
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

RE: Unable to connect to oracle database from sqoop

2013-06-21 Thread Manickam P
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

Re: Unable to connect to oracle database from sqoop

2013-06-21 Thread Michal Taborsky
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))) >

RE: Unable to connect to oracle database from sqoop

2013-06-21 Thread Manickam P
DDRESS_LIST=(ADDRESS=(PROTOCOL = TCP)(HOST = MyIPAddress)(PORT = 1521)))(CONNECT_DATA=(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 Wel

Re: Unable to connect to oracle database from sqoop

2013-06-21 Thread Michal Taborsky
(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 > >

RE: Unable to connect to oracle database from sqoop

2013-06-21 Thread Manickam P
nect(NSProtocol.java:395)at oracle.jdbc.driver.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 sqo

Re: Unable to connect to oracle database from sqoop

2013-06-21 Thread Michal Taborsky
n > with the following error: > ORA-12514, TNS:listener does not currently know of service requested in > connect descriptor > > at oracle.net.ns.NSProtocol.connect(NSProtocol.java:395) > at > oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1102) > at

RE: Unable to connect to oracle database from sqoop

2013-06-21 Thread Manickam P
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

Re: Unable to connect to oracle database from sqoop

2013-06-20 Thread Michal Taborsky
Hello Manickam, the Oracle connection parameters are a bit confusing sometimes (not a Sqoop problem). The thin client, which you are using, does not support full Oracle*Net client and it does not work with tnasnames.ora. So you either specify the service directly (in your case, the listener runnin

RE: Unable to connect to oracle database from sqoop

2013-06-20 Thread Manickam P
Hi, Given below is the scoop script i used. ./sqoop list-databases --connect jdbc:oracle:thin:@localhost:1521/cp --username scott --password tigerJDBC 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