Re: Init File Question

From: <sybrandb_at_hccnet.nl>
Date: Thu, 06 Sep 2007 23:00:37 +0200
Message-ID: <0fq0e31raug1qn2mq2pkr26qsekdh6jgeq@4ax.com>

On Thu, 06 Sep 2007 13:37:27 -0700, "fitzjarrell_at_cox.net" <fitzjarrell_at_cox.net> wrote:

>I believe this is/was intended for RAC configurations to allow
>one init.ora file to service all nodes, but someone else may correct
>me.

Correct, introduced in 9i with the spfile mechanism. Spfile files in RAC are a RAW device on shared storage. 'Local' spfiles are possible but not preferred.

New syntax
alter system set <parameter>=value scope=both|memory|spfile sid='<instance sid>';

-- 
Sybrand Bakker
Senior Oracle DBA

Received on Thu Sep 06 2007 - 16:00:37 CDT