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

    RAC SPFILE

    950800
      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
          rcc50886
          SPFILE should be shared across all the instances.
          inst_name.<parameter>
          
          *.<parameter>
          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.