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 12.2.1.0.0 to 12.2.1.2.0 [Release 12c]
Oracle Fusion Middleware - Version 12.2.1.0.0 to 12.2.1.2.0 [Release 12c]
Information in this document applies to any platform.

Symptoms

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 config.sh to create the Domain.

6.  Domain Creation fails

Cause

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
Symptoms
Cause
Solution
References


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