Re: How change Spfile parameter?

> alter system set
> spfile='D:\Software\Oracle_Express\PFILES\MIENTRAS_XE_SPFILE'
> *
> ERROR at line 1:
> ORA-02095: specified initialization parameter cannot be modified

This parameter is set when you start the instance. If you want to start the instance with a different SPFILE, then use the following:

STARTUP SPFILE='/directory/spfile'

When the instance has been started, query V$PARAMETER again to see the change.

If you do not specify the SPFILE on startup, then the default is used.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown