Sqoop list-databases fails with ERROR manager.OracleManager: The catalog view DBA_USERS was not found
(Doc ID 1481040.1)
Last updated on JUNE 16, 2017
Applies to:Big Data Appliance Integrated Software - Version 126.96.36.199.0 and later
Trying to use list-databases via SQOOP and connecting with the Oracle JDBC Thin driver and getting the following exception:
sqoop list-databases --username SCOTT --password tiger --connect jdbc:oracle:thin:@myhost.example.com:1521:ORCL
12/08/03 16:06:34 INFO manager.SqlManager: Using default fetchSize of 1000
12/08/03 16:06:36 INFO manager.OracleManager: Time zone has been set to GMT
12/08/03 16:06:36 ERROR manager.OracleManager: The catalog view DBA_USERS was not found. This may happen if the user does not have DBA privileges. Please check privileges and try again.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!