Number of Sessions Exceeded While Executing SYS.UTL_RECOMP (Doc ID 749359.1)

Last updated on AUGUST 07, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 to 11.1.0.7 [Release 10.1 to 11.1]
Oracle Database - Enterprise Edition - Version 9.2.0.1 to 9.2.0.8 [Release 9.2]
Information in this document applies to any platform.
***Checked for relevance on 07-Aug-2017***



Symptoms

During the installation of  Oracle 11G, selected the option to create a new "General" database.  During the database creation,  encountered the following:

# pg postDBCreation.log
Database closed.
Database dismounted.
ORACLE instance shut down.
ORACLE instance started.
Total System Global Area 801939456 bytes
Fixed Size 2099064 bytes
Variable Size 197589128 bytes
Database Buffers 524288000 bytes
Redo Buffers 77963264 bytes
Database mounted.
Database opened.
utl_recomp_begin: 10:55:57
BEGIN utl_recomp.recomp_serial(); END;

*
ERROR at line 1:
ORA-12801: error signaled in parallel query server P023
ORA-00018: maximum number of sessions exceeded
ORA-06512: at "SYS.UTL_RECOMP", line 629
ORA-06512: at "SYS.UTL_RECOMP", line 671
ORA-06512: at line 1


It is also possible to receive ORA-00020 errors in this scenario as well.

It is possible to encounter this issue while executing OH/rdbms/admin/utlrp.sql script manually  as well as while upgrading the database.

 

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