Number of Sessions Exceeded While Executing SYS.UTL_RECOMP
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
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