1 Reply Latest reply: Dec 18, 2012 1:07 PM by rcc50886 RSS


      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
        • 1. Re: RAC SPFILE
          SPFILE should be shared across all the instances.
          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.