Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Sqoop >> mail # user >> FW: Unable to connect to oracle database from sqoop


+
Manickam P 2013-06-20, 13:34
+
Jérôme Verdier 2013-06-20, 14:04
+
Jarek Jarcec Cecho 2013-06-20, 14:55
+
Manickam P 2013-06-21, 05:54
+
Michal Taborsky 2013-06-21, 06:47
+
Manickam P 2013-06-21, 07:08
+
Michal Taborsky 2013-06-21, 07:29
+
Manickam P 2013-06-21, 07:39
+
Michal Taborsky 2013-06-21, 07:45
+
Manickam P 2013-06-21, 07:57
+
Michal Taborsky 2013-06-21, 09:13
+
Manickam P 2013-06-21, 09:39
Copy link to this message
-
Re: Unable to connect to oracle database from sqoop
Usernames should be in upper case as mentioned above.   With
list-all-tables, you get the list of tables owned by the user, which is
SCOTT in this case

Thanks

Venkat
On Fri, Jun 21, 2013 at 2:39 AM, Manickam P <[EMAIL PROTECTED]> wrote:

> Hi,
>
> Thanks for your input. It works now.
> Can you please provide me the list table command to see the list of
> tables. i tried the below but not working.
>
> ./sqoop-list-tables --connect jdbc:oracle:thin:@MyIPAddress:1521/cp.TNSNAME
> --username scott --password tiger
>
> how to mention the schema name here?
>
>
> Thanks,
> Manickam P
>
> ------------------------------
> Date: Fri, 21 Jun 2013 11:13:01 +0200
>
> Subject: Re: Unable to connect to oracle database from sqoop
> From: [EMAIL PROTECTED]
> To: [EMAIL PROTECTED]
>
> Hi.
>
> Use complete table name together with schema in upper case (ie.
> SCOTT.EMPLOYEE). Also, specify column names in upper case, if you use the
> --column parameter.
>
> Michal
>
>
> 2013/6/21 Manickam P <[EMAIL PROTECTED]>
>
> Hi Michal,
>
> Thanks for your help. now i'm able to connect with this. when i try to
> import i'm getting error again.
>
> 13/06/21 03:43:15 WARN tool.BaseSqoopTool: Setting your password on the
> command-line is insecure. Consider using -P instead.
> 13/06/21 03:43:15 INFO manager.SqlManager: Using default fetchSize of 1000
> 13/06/21 03:43:15 INFO tool.CodeGenTool: Beginning code generation
> 13/06/21 03:43:17 INFO manager.OracleManager: Time zone has been set to GMT
> 13/06/21 03:43:17 INFO manager.SqlManager: Executing SQL statement: SELECT
> t.* FROM EMPLOYEE t WHERE 1=0
> 13/06/21 03:43:17 ERROR tool.ImportTool: Imported Failed: Attempted to
> generate class with no columns!
>
>
> My script to import table is
>
> ./sqoop-import --connect jdbc:oracle:thin:@MyIPAddress:1521/cp.MYTNSNAME
> --username scott --password tiger --table=EMPLOYEE
>
>
>
> Thanks,
> Manickam P
>
> ------------------------------
> Date: Fri, 21 Jun 2013 09:45:22 +0200
>
> Subject: Re: Unable to connect to oracle database from sqoop
> From: [EMAIL PROTECTED]
> To: [EMAIL PROTECTED]
>
> OK, so either use this connection parameter:
>
> --connect  "jdbc:oracle:thin:scott/tiger@
> (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MyIPAddress)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=CP.MYTNSNAME)))"
>
> or try this:
>
> --connect jdbc:oracle:thin:@localhost:1521/CP.MYTNSNAME --username scott
> --password tiger
>
> Michal Taborsky
>
>
> 2013/6/21 Manickam P <[EMAIL PROTECTED]>
>
> 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)))
>
>
>
> Thanks,
> Manickam P
> ------------------------------
> Date: Fri, 21 Jun 2013 09:29:30 +0200
>
> Subject: Re: Unable to connect to oracle database from sqoop
> From: [EMAIL PROTECTED]
> To: [EMAIL PROTECTED]
>
> 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 different than instance name). Does
> your connection work from sqlplus for example? If you have the contents of
> the tnsnames.ora, just paste the whole connection string from there (just
> compact it so it is on one line). Or post the contents of the tnsnames.ora
> file here and I can give you some more guidance.
>
> Michal
>
>
> 2013/6/21 Manickam P <[EMAIL PROTECTED]>
>
> Hello Michal,
>
> Thanks for your reply. I tried with your input but after that also i'm
> getting the same error. i've given below the script i used.
>
> ./sqoop-list-databases --connect  "jdbc:oracle:thin:username/password@
> (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MyIPAddress)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=cp)))"
>
>
> Do i need to add any jar file in the sqoop lib apart from ojdbc jar?
>
> when i try the above script i got the below exception. I've added the
Regards

Venkat