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.

 

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.