Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ora-02095

3192671Mar 8 2016 — edited Mar 10 2016

I want to add a new control file in the existing one.I copy the existing control file and rename it and then paste it in the same location.But when I use this commands-

ALTER SYSTEM SET control_files=/u01/app/oracle/oradata/orcl/control01.ctl, /u01/app/oracle/fast_recovery_area/orcl/control02.ctl, /u01/app/oracle/oradata/orcl/control03.ctl SCOPE=SPFILE,

It shows an error that

ORA-02095: specified initialization parameter cannot be modified

What to do?

This post has been answered by AndrewSayer on Mar 9 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 7 2016

Added on Mar 8 2016

#general-database-discussions

8 comments

2,097 views