one instance on my RAC
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: one instance on my RAC

  1. #1
    Join Date
    Mar 2006
    Posts
    176

    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
    Posts
    176
    below is my spfile location, it's sitting on ASM

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

    +DATA1/DB1/spfileDB.ora

  3. #3
    Join Date
    Mar 2006
    Posts
    176
    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
    Location
    England
    Posts
    7,333
    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