ORA-02095: Specified Initialization Parameter Cannot Be Modified - Learnomate Technologies

ANKUSH THAVALI
03 Dec, 2023
0 Comments
36 Secs Read

ORA-02095: Specified Initialization Parameter Cannot Be Modified

PROBLEM:

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

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

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

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

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

alter system set processes=1000 scope=SPFILE;


SHUTDOWN IMMEDIATE;
STARTUP;

Hope it Helps!