Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

sqoop list database error

Solved Go to solution
Highlighted

sqoop list database error

Rising Star

Hi there,

 

I tried to list databse from the remote Oracle and MSsql servers using oracle and jtds driver in sqoop, somehow the Oracle gave me this error:

 

- ERROR manager.OracleManager: The catalog view DBuser was not found. This may happen if the user does not have DBA privileges. Please check privileges and try again. 

 

and MSsql server gave me this error:

 

-  ERROR sqoop.Sqoop: Got exception running Sqoop: java.lang.RuntimeException: java.sql.SQLException: Invalid object name 'SYS.DATABASES'.
java.lang.RuntimeException: java.sql.SQLException: Invalid object name 'SYS.DATABASES'.

 

Anyone has any idea with this?

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions

Re: sqoop list database error

Rising Star

Managed to solve this after given select permission on the database and use ojdbc7.jar for Oracle 12c.

1 REPLY 1

Re: sqoop list database error

Rising Star

Managed to solve this after given select permission on the database and use ojdbc7.jar for Oracle 12c.