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