Wednesday 14 January 2015

Error: Oracle Initialization Parameter 'PROCESSES' is too low.



+++++++
Issue 
+++++++
RCU-6083:Failed - Check prerequisites requirement for selected component:WEBCENTER
Please refer to RCU log at /u02/oracle/logdir.2015-01-09_10-41/rcu.log for details.
Error: Oracle Initialization Parameter 'PROCESSES' is too low.
 Cause: The Oracle Initialization Parameter 'PROCESSES' must be at least 200.
 Action: Change the Database Initialization Parameter 'PROCESSES' to 200 or more, then rerun RCU.
RCU-6092:Component Selection validation failed. Please refer to log at /u02/oracle/logdir.2015-01-09_10-41/rcu.log for details.



SQL> show parameter processes

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes                      integer     0
db_writer_processes                  integer     1
gcs_server_processes                 integer     0
global_txn_processes                 integer     1
job_queue_processes                  integer     1000
log_archive_max_processes            integer     4
processes                            integer     150
SQL> show parameter spfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      /u02/oracle/11.2.0/dbs/spfilew
                                                 ebcenter.ora
SQL> alter system set processes=300 scope=spfile;

System altered.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 3223535616 bytes
Fixed Size                  2217672 bytes
Variable Size            1761610040 bytes
Database Buffers         1442840576 bytes
Redo Buffers               16867328 bytes
Database mounted.
Database opened.
SQL> show parameter processes

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes                      integer     0
db_writer_processes                  integer     1
gcs_server_processes                 integer     0
global_txn_processes                 integer     1
job_queue_processes                  integer     1000
log_archive_max_processes            integer     4
processes                            integer     300
SQL>

4 comments: