Running MetaMatrix setupmm.sh produces the error: "ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit"

Solution Verified - Updated -

Environment

  • MetaMatrix Enterprise Server 5.5.x

Issue

  • Running setupmm.sh produces the error: ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit
  • If it is not possible to ask the database administrator to increase the SESSION_PER_USER limit of the user profile, is there a workaround that will enable setupmm to complete successfully?

Resolution

The resolution is to increase your Oracle SESSIONS_PER_USER limit, you might be able to limit the sessions on setupmm by having the DBA run the create scripts instead of setupmm[1].  But if setupmm succeeded, you would have issues running the server with the database sessions limited.

[1]If you choose to have the DBA's create database, they would want to run the  <installdir>\db\sqlrepository\<database platform>\mm_create.sql.  If you need to rerun the scripts for some reason, there is an associated mm_drop.sql script can be run to clear the database before you run mm_create.sql again.

This solution is part of Red Hat’s fast-track publication program, providing a huge library of solutions that Red Hat engineers have created while supporting our customers. To give you the knowledge you need the instant it becomes available, these articles may be presented in a raw and unedited form.

Comments