[DataFlux][ODBC Oracle driver][Oracle]ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit

[beamer108]

Im working in Dataflux 2.8 and the job i have has several sql lookup nodes. 

When running the job I receive the following error message on one of the nodes. What does this mean and how do I correct?

[DataFlux][ODBC Oracle driver][Oracle]ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit

[jimbarbour]

---

@beamer108 wrote:

Im working in Dataflux 2.8 and the job i have has several sql lookup nodes. 

[DataFlux][ODBC Oracle driver][Oracle]ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit

---

Well, I can't say for sure without knowing your environment, but in many cases, a given user may have only so many sessions open at any one time.  If the user tries to open yet another session while already at the limit, the connection will be refused.  

Is there any way you can close session(s) at intermediate points in the processing?  This might keep you under the limit (assuming my surmise is correct).

If not, you might want to talk to the DBA or Sys Admin who has control of the Sessions_Per_User and see if you can persuade him or her to increase the limit or to suggest some type of work-around.

Jim

[VincentRejany]

Not an Oracle expert, but it sounds like you need to increase the number of sessions

alter system set processes=200 scope=spfile;
alter system set sessions=250 scope=spfile;