exadata role separation between gi and dbms

From: D'Hooge Freek <Freek.DHooge_at_uptime.be>
Date: Mon, 26 Mar 2012 11:57:44 +0200
Message-ID: <4814386347E41145AAE79139EAA398981CBE5CCF29_at_ws03-exch07.iconos.be>


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?

Kind regards,

Freek D'Hooge
Oracle Database Administrator
email: freek.dhooge_at_uptime.be
tel +32(0)3 451 23 82
disclaimer: www.uptime.be/disclaimer

Received on Mon Mar 26 2012 - 04:57:44 CDT

Original text of this message