Database Error ORA-2391

[rb9594]

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.

[paross1]

Have your DBA increase the SESSION_PER_USER limit of the user profile.

Phil

[rb9594]

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.

[paross1]

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

[rb9594]

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