DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2006

    one instance on my RAC

    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.

  2. #2
    Join Date
    Mar 2006
    below is my spfile location, it's sitting on ASM

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


  3. #3
    Join Date
    Mar 2006
    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,

  4. #4
    Join Date
    Sep 2002
    in the init.ora file, you will need to put spfile= 'path to spfile'

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.