Oracle RAC init.ora parameters
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Oracle RAC init.ora parameters

  1. #1
    Join Date
    May 2002
    Posts
    19

    Oracle RAC init.ora parameters

    What would you recommend for the following parameters in a 2 node RAC database, should the locations to which they point be on shared storage or not ?
    We are using OCFS Version 1 and a 10.1.0.4 database.
    I am in the process of creating my first RAC database and I am a little confused.

    The parameters in question are:-

    background_dump_dest
    core_dump_dest
    user_dump_dest

    Should each instance have its own location for each of the above as I would view them as being instance specific as opposed tied to the database.

    Reading notes on Metalink it would appear that they have only a single location that is database wide as opposed to instance specific.

    Any advice or help would be much appreciated,
    Cheers,
    ed

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    if you are using ocfs you cant put alert logs, trace files on them - its not posix compliant (yet)

    we keep those directories local to each server, i think it provides a 'cleaner' solution as you can see what instance is producing what easier.

  3. #3
    Join Date
    May 2002
    Posts
    19
    What i think I realised last night whilst musing this over in bed last is that the $ORACLE_BASE/admin//bdump directories are infact using the db_name and not the instance_name - therefore as there will only be one locally mounted disk of the same name visible on each node this is where my confusion arose i believe. Hopefully the Unix guys will get my boxes prepared and i can have a go at installing :-)

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