CODEWITHSUNDEEP
sqoop
Sumit Khurana
Sumit Khurana

Reputation: 159

Unable to import data from oracle using Sqoop

Unable to import data from oracle to HDFS using Sqoop. Getting the below error:

java.lang.RuntimeException: java.lang.RuntimeException:
java.sql.SQLException: ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit
at org.apache.sqoop.mapreduce.db.DBInputFormat.setDbConf(DBInputFormat.java:170)

The strange thing is that it comes even if I am specifying a single mapper and as per Sqoop docs should only be generating a single connection to Oracle.

The most weird part is at times the same command gets executed successfully as well.

Any insights on the same.

Upvotes: 0

Views: 476

Answers (1)

Rockshell
Rockshell

Reputation: 97

Which version of sqoop are you using? The reason I am asking is SQOOP-2971 is a known issue and is fixed in versions 1.4.6 and higher. Also makes sure to ping your Oracle DBA and ask him to kill all the existing ORA sessions before you launch sqoop import to database. Refer to link https://issues.apache.org/jira/browse/SQOOP-2971

Upvotes: 1

Related Questions