exadata role separation between gi and dbms
Date: Mon, 26 Mar 2012 11:57:44 +0200
I'm looking for some real world experiences with user separation setups on Exadata.
The default on Exadata setups seems to be to install both the grid infrastructure software and the db software under the same user instead of using a separate grid user for the GI.
On non Exadata RAC setups I normally use 2 separate users for this, but as this is my first Exadata I don't really know what would be the best thing to do.
If it is really the default, I would be inclined to install everything under the oracle user, but then you have to remember to set or modify the environment variables each time you need to work on the asm or the db instance.
So, if you have an Exadata setup, did you use a separate grid user or not and would you do the same if you had to start over again? What are the benefits / drawbacks to use (or not use) different users?
Oracle Database Administrator
tel +32(0)3 451 23 82