Oracle: ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit

[ninos-shiba]

I cannot refresh any of my Oracle data sources any longer due to this message:

Oracle: ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit

Is there any fix on the Power BI side or anything I could do on my system to help?

[ninos-shiba · Accepted solution]

I reached out to my IT department and they doubled the total number of database connections. Thanks for the responses.

[EsmaeilYazdani]

You can increase simultaneous sessions in your oracle database. In the following link, you can find the right soloution:

https://docs.oracle.com/cd/B10501_01/server.920/a96525/e2100.htm

Just search for "Oracle: ORA-02391" on the webpage.

Good luck!

[v-deddai1-msft]

Hi @ninos-shiba ,

The total number of database connections to the Oracle Database by the specified user has reached the maximum, and therefore no more connections can be established for the current user. Would you please refer the resolution in https://confluence.atlassian.com/jirakb/how-to-fix-ora-02391-exceeded-simultaneous-sessions_per_user...

If this post help, please consider accept it as the solution to help others find it more  quickly.

Best Regard,

Dedmon Dai

[camargos88]

@ninos-shiba ,

Check this link:

Solved: Power BI Desktop automatic refresh queries one-by-... - Microsoft Power BI Community

Maybe your user has a limit for sessions. So you can try disabling the parallel load and background refresh.