If we are changing spfile in oracle RAC, then we need to use additional SID parameter in the alter system command.

Here SID is the instance_name.

For changing the parameter in both the instances of the RAC.

alter system set SEC_CASE_SENSITIVE_LOGON=FALSE scope=both sid='*';

For changing the parameter in a specific instance.

alter system set job_queue_processes=500 scope=both sid='ORCL1';

If we don’t mention the SID parameter, then by default it will be configured for the local instance, from where we are executing the command.

There are 3 options for SCOPE parameter:

1. MEMORY – the change is immediate but will not be available post instance restart
2. SPFILE – the changes will be made to spfile, however it will be applied the database, post instance restart
3. BOTH – Changes will be applied to database immediate, And it dont needs database restart