Unable to connect to Oracle database

Roshan_Mahapatra April 22, 2018, 4:03pm #1

On executing:
sqoop list-tables --connect jdbc:oracle:thin:ip address of windows machine where oracle db is installed:1521/db --username xxx --password xxx

Gives error:
ERROR sqoop.Sqoop: Got exception running Sqoop: java.lang.RuntimeException: Could not load db driver class: oracle.jdbc.driver.Orac
leDriver
java.lang.RuntimeException: Could not load db driver class: oracle.jdbc.driver.OracleDriver

Any suggestions?

abhinav April 23, 2018, 10:50am #2

Hi @Roshan_Mahapatra,

Are you running this command on CloudxLab?

Roshan_Mahapatra April 23, 2018, 6:57pm #3

Yes, from the web console

Madana_Sekhar July 18, 2018, 1:11pm #4

I am also facing the same issue. Can you please some one help on sqoop import with oracle RDBMS table in cloudxlab…?

Thanks in advance.