How to setup spfile for RAC?

[Unna]

Dear all,

We have an Oracle RAC database with two nodes in Windows environment; however, the init.ora/spfile.ora files are stored separately in both two nodes' Oracle_Home\database directory.

I need to setup these spfiles properly, by having all nodes using one spfile and placed this spfile in a shared drive. How will I go by doing that so both nodes will know where to look for this shared spfile instead of Oracle_Home\database directory?


Thanks,
Unna

[stmontgo]

we have a file called initORLHR2.ora in oracle_home\database on every node of the cluster that contains one line - spfile=x:\spfile_PROD.ora where x is a OCFS (shared) drive

[pando]

you create initSID.ora and use SPFILE parameter point to your shared storage SPFILE


If you are using CFS then just use symbolic links

[Unna]

Thanks all! Do I need to put *. in front of spfile for all nodes?

[pando]

Your last question doesnt makes sense. You are not allowed to edit the spfile, if you want to make any changes you should do

alter system set parameter = value scope = spfile sid = '*'

or sid = 'SIDx' if you wanna specify a specific parameter for a specific instance, x in this case will be your instance number, * would apply the new parameter to all your RAC nodes

Thanks

[Unna]

I meant to put *.spfile in the init.ora. Thanks!

[pando]

No, not needed

[Unna]

Thanks. I was able to setup the spfile in shared drive in Windows server and restarted both instances using this spfile file.

However, after rebooting these two production servers, one of the cluster node gave blue screen and constantly reboot itself, while the other node was able to startup without any trouble. The server crashed and gave blue screen when it tried to startup the OracleCRServices. Does anyone has any idea why this happened and what are the solutions?

Any help is appreciated!

[pando]

look at the log files

[mahsnj]

Try to bring one node at a time.i.e.
Bring node 1 first and after node 1 is up bring node 2.
What is a error msg in CRS log.
Regards