Re: modify the location of control files

Harald Maier <maierh_at_myself.com> writes:

> Brian Peasland <oracle_dba_at_remove_spam.peasland.com> writes:
>
>> I haven't tried it myself, but it appears to me that the procedure
>> would be as follows:
>>
>> 1. Issue ALTER SYSTEM SET
>> control_files=/newdir/control01.ctl,.....,/newdir/control03.ctl
>> SCOPE=SPFILE;
>> This changes the parameter in the SPFILE, but not for the active
>> instance.
>
> This produces the following error:
>
> 02095, 00000, "specified initialization parameter cannot be modified"
> // *Cause: The specified initialization parameter is not modifiable

The filenames need to be quoted. The following works fine now:

  SQL> ALTER SYSTEM SET control_files='/newdir/control01.ctl','/newdir/control02.ctl','/newdir/control03.ctl'   SCOPE=SPFILE;   System altered.

Harald Received on Thu Jun 12 2003 - 01:29:53 CDT