The Number Of Oracle Sessions Exceeded The Max Limit (ORA-00018) (Doc ID 960530.1)

Last updated on JUNE 23, 2016

Applies to:

Oracle Communications ASAP - Version 4.7.1 to 7.2.0 [Release 4.7 to 7.2]
Information in this document applies to any platform.

Symptoms

Maximum number of Oracle sessions (1200) exceeded.

NEP Diag:

>033403.457:72:PROG:checkerr :1830:ocilib.c
Error - ORA-00604: error occurred at recursive SQL level 1
ORA-00018: maximum number of sessions exceeded
errcode[604]
>033403.457:72:SANE:DBLogon_oci8 :1635:ocilib.c
Error: Failed OCISessionBegin,status[0]
>033403.457:72:PROG:System Event :83 :ocilib.c
ASAP System Event: SYS_ERR
Error: Unable to open OCI connection
>033403.457:72:PROG:System Event :309 :ctlib.c
ASAP System Event: SYS_ERR
Error: Unable to open OCI connection
>033403.481:72:PROG:checkerr :1830:ocilib.c
Error - ORA-00018: maximum number of sessions exceeded
errcode[18]
>033403.481:72:SANE:DBLogon_oci8 :1635:ocilib.c
Error: Failed OCISessionBegin,status[0]
>033403.481:72:PROG:System Event :83 :ocilib.c
ASAP System Event: SYS_ERR
Error: Unable to open OCI connection
>033403.481:72:PROG:System Event :309 :ctlib.c
ASAP System Event: SYS_ERR
Error: Unable to open OCI connection
>033403.481:72:PROG:System Event :828 :cmd_utils.c
ASAP System Event: SYS_ERR
Error: Cannot Create Core Pool of Client Library Connections
>033403.482:72:PROG:System Event :2461:main.c
ASAP System Event: SYS_ERR
Initialization Function [Core Database Initialization] Failed, Terminating Server


.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms