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 1.0.1.1.0 and later
Linux x86-64

Symptoms

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 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.
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.

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms