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!

set spfile location

252122Mar 29 2007 — edited Mar 30 2007

Hi,

My initial parameter doesn't show spfile's location using
SQL>show parameters;

Can I use following to make a change?
SQL> alter system set spfile='D:\oracle\product\10.1.0\Db_1\database\SPFILEORCL.ORA';

The error I got is:
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified

How to define spfile's location in initcial parameter?

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 27 2007

Added on Mar 29 2007

#general-database-discussions

7 comments

3,775 views