Saturday, September 1, 2012

SOA 11g installation issue: DB Init Param Prerequisite failure for: processes

This is a common issue when running RCU on a "fresh" database instance but, I always forget how to deal with this problem:) Therefore, in order to remember the solution I wrote down this small "tutorial":

1. Run sqlplus and  connect to your database as SYS

SQL> CONNECT SYS as SYSDBA
Enter password: sys_password

2. Next you can examine PROCESSES parameter

SQL> show parameters processes;

3. The response should look like shown bellow:

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     100

4. You can also check count of running processes:

SQL> select count(*) from v$process; 

and also number of running background processes:

SQL> select count(*) from v$process where BACKGROUND=1;

5. To increase number of PROCESSES run from sqlplus:

SQL> alter system set processes=200;

6. System changes will be active after restart of database instance. To perform database restart you should stop instance:

SQL> shutdown immediate;

7. To startup instance you have to run:

SQL> startup;

When you examine PROCESSES parameter once again, you should see new updated value.

No comments:

Post a Comment