1 oracle user per server or 1 per database

From: D'Hooge Freek <Freek.DHooge_at_uptime.be>
Date: Mon, 1 Feb 2010 14:54:44 +0100
Message-ID: <4814386347E41145AAE79139EAA398980DC63F9E74_at_ws03-exch07.iconos.be>


I'm searching for arguments pro and con the use of a dedicated (os) oracle user per database versus a single oracle user per server. The os platform is Linux. The database versions will probably be a mix of 10gR2 and 11gR2.

Is anyone using the new 11gR2 grid infrastructure with multiple oracle users for the databases? Any known pitfalls with this?


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 Feb 01 2010 - 07:54:44 CST

Original text of this message