ORA-02095: Specified initialization parameter cannot be modified

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
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;

Leave a comment