PROBLEM:

While modifying the parameter in the database, got below error.

SQL> alter system set processes=1000 scope=both;
alter system set processes=1000 scope=both
*
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified

 

SOLUTION:

First, we need to check whether the parameter is system modifiable or not.

 

SQL> select name,VALUE,ISSYS_MODIFIABLE from SYS.V$PARAMETER where name='processes';

NAME VALUE      ISSYS_MODIFIABLE 
------------- ----------------------- ---------
processes 7680 FALSE

ISSYS_MODIFIABLE is FALSE, Means we can’t use scope=both, We need to use SCOPE=SPFILE.

SCOPE=BOTH, PARAMETER WILL BE CHANGED DYNAMICALLY, No NEED TO RESTART THE INSTANCE/DATABASE.
SCOPE=SPFILE, WE NEED TO RESTART THE INSTANCE/DATABASE, FOR THE PARAMETER TO REFLECT.

 

So to fix this error, use scope=spfile and restart the database.

alter system set processes=1000 scope=SPFILE;


SHUTDOWN IMMEDIATE;
STARTUP;