As we know Troubleshooting is the process of identifying, planning and resolving a problem, error or fault within a software or computer system. It enables the repair and restoration of a computer or software when it becomes faulty, unresponsive or acts in an abnormal way.
We are going to know the steps we use to resolve the issue ORA-02095.
While modifying the parameter in the database, got below error.
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
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
So to fix this error, use scope=spfile and restart the database.