changing init.ora parameters 1

[beechill4]

Hi,

I am working on a rac database.

i need to change some paameters like processes and optimizer mode.

as this is rac, how should i make the changes?

 

[LKBrwnDBA]

1) spfile must be shared.
2) create pfile from spfile and make changes.
3) shutdown both instances.
4) startup pdile=init{sid}.ora (primary)
5) create spfile from pfile
6) startup secondary.

PS: There might be a way to do it swithing to secondary, shutting down primary, change init.ora, startup primary, switching to primary and re-starting secondary; BUT I have not tried it this way.



----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb