one instance on my RAC

[matthew00]

Hi all;

I have RAC two node cluster, and one of my instance goes down. when I tried to startup the instance below is what I got:

SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/oracle/v1020/dbs/initDB1.ora'


1. why is it looking at the initDB1.ora to start up the DB, I thought it suppose to use the spfile to start up the instance.

2. what step I need to do in order to bring up the first instance now?

Thanks all.

[matthew00]

below is my spfile location, it's sitting on ASM

SELECT name,value FROM v$parameter WHERE name LIKE '%spfile%';

+DATA1/DB1/spfileDB.ora

[matthew00]

I was able to find the init.ora and put it in the $ORACLE_HOME/dbs and I was able to startup the instance. Now, I have different question. Based from what I see now is someone make the change the first instance, so rather than to dig into each parameter to find out the change, I would like to use my second instance as a GOOD resource b/c it goes down.

Since my second instance is good, what can I do to insure that the first instance will use whatever the second instance had via SPFILE.

thanks all,

[davey23uk]

in the init.ora file, you will need to put spfile= 'path to spfile'