RE: exadata role separation between gi and dbms
Date: Mon, 26 Mar 2012 15:44:41 +0200
Yes, I'm using multiple homes on non-exadata systems. But I normally use a different os user for each home and preset the env variables in the bash_profile instead of using oraenv. I have found this minimizes the chance on "oopses" where for instance a database is started under the wrong home.
Oracle Database Administrator
tel +32(0)3 451 23 82
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Andy Colvin Sent: maandag 26 maart 2012 14:52
Subject: Re: exadata role separation between gi and dbms
How do you handle non-Exadata systems with multiple Oracle homes? oraenv is your friend. In most of the installations I've worked on, customers chose to go with everything under the oracle account, as it's easier to set your environment than remember to switch user accounts for every purpose. Andy Colvin
On Mar 26, 2012, at 4:57 AM, D'Hooge Freek wrote:
> 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