Init.ora File Points to SPFILE

We run an Oracle RAC system with ASM.  I noticed our init.ora file has a pointer to spfile:

spfile='+DATA'

Assume this means database is not using init.ora, but is using spfile located on ASM?  Is this typical done on RAC implementations where the database uses a SPFILE that lives in the ASM storage path?  Why is this necessary?
LVL 1
sdrussAsked:
Who is Participating?
 
Abhimanyu SuriSr Database EngineerCommented:
In RAC it is always suggested to use common spfile placed at the shared location, so that all instances are identical in terms of memory/parameters.

In RAC with ASM the spfile is placed in the ASM ( shared location maintained by ASM) so all instances can access it.
 init file is local to instance, hence it automatically gets updated with the location of spfile.

Also, Oracle has a preference when it comes to choose spfile over pfile

 spfileSID.ora
 spfile.ora
 initSID.ora
 init.ora

It will look in /dbs for given files and hence gets routed to ASM.

There is further enhancement to it with GPNP profile.
0
 
sdstuberCommented:
it's not necessary but it is common.

the goal with this is to put the spfile on shared storage, which is often implemented with ASM.

if you keep your files in filesystems that are shared, then it's possible to write the spfile there instead of ASM shared storage; but again, that's less common.
0
 
sdrussAuthor Commented:
Exactly what I was looking for. Excellent!
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
Abhimanyu SuriSr Database EngineerCommented:
Please close the thread when you get chance.
0
 
sdrussAuthor Commented:
Nice job.
0
 
sdstuberCommented:
clearly that post was not an answer.

Please close the question accepting the post, or posts that were actually helpful.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.