It is recommended that the SPFILE is shared between all nodes within the cluster, but it is possible that each instance can have its own SPFILE. I would like to know why it is recommended? Is it because shared SPFILE simplifies administration or anything else?
Thanks in advance
We can set parameters to a particular instance by specifing the instance name.
If we specify "*" then it applies to all the instances.
instance specific parameter value overwrites the global parameter.