SOLVED

ORA-02095: Specified Initialization Parameter Cannot Be Modified

Asked by OracleDba12 viewsoracle
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
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.
#oracle#error

Solutions(1)

Accepted Solution
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
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!
OracleDba

Post Your Solution