Getting Exception with SQOOP and Oracle JDBC Thin Driver- 'manager.OracleManager: Failed to list databases java.sql.SQLException: ORA-01017: invalid username/password; logon denied' (Doc ID 1481041.1)

Last updated on JULY 20, 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 system --password badPassword --connect jdbc:oracle:thin:@myhost.example.com:1521:ORCL

12/08/03 15:15:59 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.
12/08/03 15:15:59 INFO manager.SqlManager: Using default fetchSize of 1000
12/08/03 15:16:03 ERROR manager.OracleManager: Failed to rollback transaction
java.lang.NullPointerException
        at com.cloudera.sqoop.manager.OracleManager.listDatabases(OracleManager.java:641)
        at com.cloudera.sqoop.tool.ListDatabasesTool.run(ListDatabasesTool.java:51)
        at com.cloudera.sqoop.Sqoop.run(Sqoop.java:146)
        at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
        at com.cloudera.sqoop.Sqoop.runSqoop(Sqoop.java:182)
        at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:221)
        at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:230)
        at com.cloudera.sqoop.Sqoop.main(Sqoop.java:239)
12/08/03 15:16:03 ERROR manager.OracleManager: Failed to list databases
java.sql.SQLException: ORA-01017: invalid username/password; logon denied
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:389)
        at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:382)
        at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:600)
        at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:445)
        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
        at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:380)
        at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:760)
        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:401)
        at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:546)
        at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:236)
        at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
        at java.sql.DriverManager.getConnection(DriverManager.java:582)
        at java.sql.DriverManager.getConnection(DriverManager.java:185)
        at com.cloudera.sqoop.manager.OracleManager.makeConnection(OracleManager.java:311)
        at com.cloudera.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:53)
        at com.cloudera.sqoop.manager.OracleManager.listDatabases(OracleManager.java:630)
        at com.cloudera.sqoop.tool.ListDatabasesTool.run(ListDatabasesTool.java:51)
        at com.cloudera.sqoop.Sqoop.run(Sqoop.java:146)
        at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)
        at com.cloudera.sqoop.Sqoop.runSqoop(Sqoop.java:182)
        at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:221)
        at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:230)
        at com.cloudera.sqoop.Sqoop.main(Sqoop.java:239)

 

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