Sqoop list-databases fails with ERROR manager.OracleManager: The catalog view DBA_USERS was not found
(Doc ID 1481040.1)
Last updated on SEPTEMBER 13, 2019
Applies to:Big Data Appliance Integrated Software - Version 220.127.116.11.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 <USER> --password <PASSWORD> --connect jdbc:oracle:thin:@<HOSTNAME>.<DOMAIN>: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!
In this Document