Skip to main content
R
rb9594
Participant
June 12, 2008
Question

Database Error ORA-2391

  • June 12, 2008
  • 2 replies
  • 1521 views
We are using a DSN in the CF Admin to access a remote server that has oracle. In our advanced settings there is an option called Maintain connections. No matter if this is checked/unchecked our connections seem to be left open causing another application to error us out because we reach the max SESSIONS_PER_USER limit. This is the error we receive.

ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit

Suggestions on how to solve this problem, its causing me tremendous headaches.
This topic has been closed for replies.

2 replies

P
paross1
Participating Frequently
June 12, 2008
I'm not sure if it would help, but you might want to post what Oracle, ColdFusion, and DataDirect versions you are running in case it might help someone determine the problem. I've never had the problem with any of the various combinations of CF and Oracle that we have worked with over the last 5 years, and we have always had Maintain Connections as UNSELECTED.

We've used CF 4.5 (Enterprise) with Oracle 8, then CF 7.02 (Enterprise) with Oracle 9i and 10g with no problems.

Phil
R
rb9594Author
Participant
June 12, 2008
hey phil

Our system is CF8 with ORACLE 10G. CF8 is on a windows server and ORACLE 10G is on Linux.

Their system is Java 1.4.2_13, Solaris 10, and ORACLE 10G.

thanks for the help
P
paross1
Participating Frequently
June 12, 2008
Have your DBA increase the SESSION_PER_USER limit of the user profile.

Phil
R
rb9594Author
Participant
June 12, 2008
hey phil

the dba has already set it to 5. it seems like the connections are hanging when they should release, some of them were out there for several weeks. they added a 7 min termination to the profile, but it still hangs for 7 minutes also. it seems like the connection is not closing when we quit running the application.
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices