Database Administration (MOSC)

MOSC Banner

Question about going back to Shared SPFILE from Local SPFILE in RAC

edited Feb 12, 2013 9:38AM in Database Administration (MOSC) 4 commentsAnswered
We have a two node RAC Database where each node is using a separate, local SPFILE.  I 'think' this is due to a mistake where someone created a PFILE from SPFILE and then SPFILE from PFILE without specifying the shared location.  I need to change it back to both nodes using a shared SPFILE as recomended.  We are not using ASM.

Is this the correct procedure?

1.  Create PFILE from SPFILE

2.  On node 1, create SPFILE from PFILE to shared location:  create spfile='O:\oradata\dbname\spfileCLUSTER.ora' from pfile='O:\oradata\dbname\PFILE_NODE.ora'

2.  On node 2, create SPFILE from PFILE to shared location: create spfile='O:\oradata\dbname\spfileCLUSTER.ora' from pfile='O:\oradata\dbname\PFILE_NODE.ora'

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center