My Oracle Support Banner

Oracle Fusion Middleware Infrastructure Domain Creation Fails with "ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit" (Doc ID 2195185.1)

Last updated on JUNE 13, 2023

Applies to:

Oracle HTTP Server - Version to [Release 12c]
Oracle Fusion Middleware - Version to [Release 12c]
Information in this document applies to any platform.


Installing OHS 12.2.1, and it fails on Domain Creation with the following errors:

Steps to Reproduce Issue:

1. Installed Database.

2. Created a new user TMPDBA and assigned SYSDBA Privileges.

   SESSIONS_PER_USER limit is set to unlimited for SYS as well as SYSDBA user.

3. Installed Fusion Middleware Infrastructure.

4. Ran RCU to create Schemas

5. Run to create the Domain.

6.  Domain Creation fails


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.