ORA-27300 Status 11, ORA-27301 and ORA-27302 After Increasing Processes Parameter (Doc ID 1229767.1)

Last updated on MAY 17, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.3 to 10.2.0.3 [Release 10.2]
Generic UNIX

Symptoms

The below errors are received in alert.log
o Errors received after changing the following:
  - processes parameter from 1200 to 5000
  - parallel_max_servers from  500 to 3072
  - parallel_min_processes increased from  256 to 1024

o Can occur in both stand alone and RAC instances
o Top shows no concerns with memory or CPU.
o You have restarted the database(s) and no effect

 
The following kernel settings were checked:
project.max-lwps is set to default which is 2 billion.

 

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