-
Hi,
The problem was that normal users could not connect to the database, their clients hanged up, but I could connect using SYSTEM or SYS. After a while Oracle reported the message Max. number of sessions exceeded to the clients that were trying to connect. The actual sessions (from V$SESSION) were 211 but the p[arameter SESSIONS was 283, the parameter PROCESSES was 256. The database is configured for dedicated server processes not MTS. What is the problem? maybe there is some other parametrer that affects the max sessions?
All teh users use DEFAULT profile which has UNLIMITED number of sessions per user.
We are using Oracle v7.3.4 on Digital UNIX.
Thanx
-
Check the parameter
LICENSE_MAX_SESSIONS
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|