- 03 Dec, 2023
- 0 Comments
- 36 Secs Read
ORA-02095: Specified Initialization Parameter Cannot Be Modified
PROBLEM:
1 2 3 4 5 6 | 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.1 2 3 4 5 | 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.
1 2 3 4 5 | alter system set processes=1000 scope=SPFILE;SHUTDOWN IMMEDIATE;STARTUP; |