Products
  
  
  Crash Magic Online
  
  Intersection Magic
  
  Map Magic
  
  Knowledge Base
  
  
  
  Contact Us
  
  Meeting
  
  Shop
  
  Login
  

 

Knowledge Base Article:CMO254 


Registration keys moved to client area: Select login on the left menu bar.

Knowldegebase:
Search home page  

Crash Magic oracle sessions

Article created: Sep 07 2011, updated: Sep 12 2011

Background:  Users may receive an ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit

Status:  Info - "how to" article
Keywords:  oracle,sessions,limit,user,2391
Categories:   *Related software* *Article - references*

Explanation:

Crash Magic uses at least two connections to a database. This article covers the default connection to the client collision database. 

Each Crash Magic database connection can create multiple sessions. Oracle profiles can be used to limit oracle user sessions. Profiles that are too restrictive can cause the "ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit error from Oracle".

The number of user sessions required depends on how your database and Crash Magic is configured. Users that have individual accounts on the database and use DBVerify will need fewer sessions per user. Databases that grant a single login for Crash Magic will need more sessions for the single Crash Magic user. Pd' Programming recommends a minimum of 5 sessions per Crash Magic Online user.



Solution:

Oracle uses profiles to set resource limits. Query to determine the profile assigned to the oracle Crash Magic user.

SELECT
USERNAME,
PROFILE
FROM DBA_USERS WHERE USERNAME = ''

USERNAME              PROFILE
------------------- --------------
CRASHDATAREADER       DEFAULT

Check the number of sessions per user for the profile in use:

SELECT
PROFILE,
RESOURCE_NAME,
LIMIT
FROM DBA_PROFILES
WHERE PROFILE = 'DEFAULT'
AND RESOURCE_NAME = 'SESSIONS_PER_USER'

PROFILE     RESOURCE_NAME       LIMIT
----------- ---------------     ----------------- DEFAULT     SESSIONS_PER_USER   1

Alter the profile to allow more user sessions:

ALTER PROFILE DEFAULT LIMIT SESSIONS_PER_USER 5

SELECT
PROFILE,
RESOURCE_NAME,
LIMIT
FROM DBA_PROFILES
WHERE PROFILE = 'DEFAULT'
AND RESOURCE_NAME = 'SESSIONS_PER_USER'

PROFILE     RESOURCE_NAME       LIMIT
----------- --------------- ----------------- DEFAULT SESSIONS_PER_USER 5

April 21, 2018 8:35PM

© 1999-2018 Pd' Programming, Inc - Lafayette, CO USA