ORA-02095 MisLeading and its not true always

We used to get ORA-02095 error, if we are trying to alter a STATIC parameter when issuing ALTER SYSTEM command with Scope=both.

I have tried to alter control_files parameter with SCOPE=SPFILE when database is using SPFILE. I was confused why its throwing error when i use scope=spfile option.

Later Found that ORA-02095 error is misleading. Check below for the scenario i faced.

##########################
#   Error
##########################

##########################

#   Error Occurred
##########################

Error occurs when tried to alter control_files parameter using Alter system command with scope=spfile option

##########################
##  Cause
##########################

 ORA-02095 error is misleading, the actual problem is the Brackets '( )' i used in Alter system Command 

##########################

##  Solution
##########################

When setting Controlfiles parameter dont use Brackets, multiple control files can be given using Single Quotes and commas.

Alter system set control_files='/u01/app/oracle/oradata/mydb/control01.ctl','/u01/app/oracle/oradata/mydb/control02.ctl' scope=spfile;

See Below, when we issue the Command without Brackets it worked like a charm, but the Error which gave was misleading and confusing us.

For ORA-02095 Error, Please look into,

http://stepintooracledba.blogspot.com/2013/01/ora-02095-specified-initialization.html