topic [DataFlux][ODBC Oracle driver][Oracle]ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit in SAS Data Management

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

beamer108 — Fri, 25 Jun 2021 17:23:19 GMT

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

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

jimbarbour — Sat, 26 Jun 2021 05:23:50 GMT

@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

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

VincentRejany — Mon, 28 Jun 2021 13:49:29 GMT

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;