Hi All
I am new to RAC and am finding my feet in this new waters.. I have actually set up one 10.2.0.3 RAC instance with ASM.. it was great... but in the process, all the datafiles were created in one asm diskgroup dg1 as i specified.. but the dbca never asked me about spfile..... I thought it would place in the shared OCFS
%ORACLE_HOME%\dbs. But instead one sp file is created in the second disk group I had another disk group created.. dg2 .. show parameter pfile shows me the location as
+dg2/orcl1/spfileorcl.ora
I started the db on one node with startup no mount pfile=<pfile i created from above spfile> .. and then later created spfile from this pfile.. shut down.. next time when I start the database with srvctl start database -d orcl.. its picking the spfile from the diskgroup... how can I guide the srvctl to start picking the spfile from the oracle_home/dbs ?
thanks
Chandra.