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