RCU-6107:DB Init Param Prerequisite failure for: processes Current Value is 100. It should be greater than or equal to 200

log in to oracle database


[oracle@arpit]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Apr 12 14:34:37 2012

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

check the current display process

SQL> show parameter processes

NAME TYPE VALUE
------------------------------------ ----------- --------------------------
aq_tm_processes integer 0
db_writer_processes integer 1
gcs_server_processes integer 0
job_queue_processes integer 4
log_archive_max_processes integer 2
processes integer 40


change the value to 300

SQL> alter system set processes = 300 scope = spfile;

System altered.

Restart the database and issue is gone.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup
ORACLE instance started.

Total System Global Area 348127232 bytes
Fixed Size 1258824 bytes
Variable Size 104860344 bytes
Database Buffers 239075328 bytes
Redo Buffers 2932736 bytes
Database mounted.
Database opened.