Changing the Processes Parameter

How to change the Process Parameter on standby side of a RAC database

Recently we where getting ORA-00020: No more process state objects available one of our Production system. When I looked at the Processes parameter on Primary side it was set to 1000 and on standby side it was set to 200 (default).
So we had to change the Processes Parameter to match the Production system.

1) We will disable the log shipping on the Primary side.


alter system set log_archive_dest_2='DEFER' SCOPE=MEMORY;

2)We will login into standby database and cancel the recovery process(MRP), Once the standby database is out of Recovery Mode, we can proceed with changing the Process parameter.

alter database recover managed standby database cancel;

3) Altering the Processes Parameter


alter system set processes=1000 scope=spfile;

4)Once the Parameter is changed, we would have to bounce the Database as Processes is a static parameter
 
srvctl stop database -d ****


5) Now we can start the standby database in Mount sate and enable to log shipping on Primary Side.

srvctl start database -d **** -o mount

alter system set log_archive_dest_2='ENABLE' SCOPE=MEMORY;

6) Once the log shipping has been started, we can start the recovery Process on the standby side and at this point we should be done.


   Let's check the Dataguard status for any Log Gap.


DGMGRL> show database ****_dg

Database - xxxdb11p_dg

  Enterprise Manager Name: xxxb11p_dg.xxxxxx.com
  Role:                    PHYSICAL STANDBY
  Intended State:          APPLY-ON
  Transport Lag:           0 seconds
  Apply Lag:               0 seconds
  Real Time Query:         OFF
  Instance(s):
    edwdb11p1 (apply instance)
    edwdb11p2
    edwdb11p3
    edwdb11p4
    edwdb11p5
    edwdb11p6
    edwdb11p7
    edwdb11p8

Database Status:
SUCCESS