Re: modify the location of control files

Harald Maier <maierh_at_myself.com> wrote in message news:<m3adcn3j1a.fsf_at_ate.maierh>...
> 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

Nope ... you get this ....

ORA-02095: specified initialization parameter cannot be modified

the correct answer was given above ... create the pfile, modify it, shutdown, move the files, startup the oracle database using the new pfile, save to the spfile. Received on Thu Jun 12 2003 - 10:54:20 CDT