Re: How change Spfile parameter?

Mr.EthanHunt wrote:
> Hi Group.....
>
> I am new in oracle and need change the spfile parameter value on
> v$parameter view,

why do you need to change it - not for nefarious spying reasons I hope? The spfile is just the file that contains the initialisation parameters that have explicitly been set. Generally one would leave it in its default location.

> I Looked information and found the following:
> The change must be done with "Alter system".
>
>
> I execute:
>
>
> SQL> alter system set
> spfile='D:\Software\Oracle_Express\PFILES\MIENTRAS_XE_SPFILE';
>
> nevertheless it gives back :
>
>
> alter system set
> spfile='D:\Software\Oracle_Express\PFILES\MIENTRAS_XE_SPFILE'
> *
> ERROR at line 1:
> ORA-02095: specified initialization parameter cannot be modified
>
>
> ¿How change the famous parameter ?

It looks like you are using Express Edition on Windows. Now I haven't tried to do this with XE so it may not be available to you, but in general on Windows there is a utility ORADIM which is used to set the environment for a particular instance. I'd look at the appropriate use of oradim if you really must. On the other hand its a bit difficult to imagine why you would want to change file locations like this in XE, about the only really sensible time to change the default location of an spfile that I can think of is when running RAC and you want just the one on shared storage such as ASM or OCFS.

-- 

Niall Litchfield
Oracle DBA
http://www.orawin.info/services/