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.

PROBLEM:

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

 

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

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

About The Author

Leave a Reply