one instance on my RAC
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:
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?
below is my spfile location, it's sitting on ASM
SELECT name,value FROM v$parameter WHERE name LIKE '%spfile%';
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.
in the init.ora file, you will need to put spfile= 'path to spfile'
Click Here to Expand Forum to Full Width