Re: running oracle on non-install user
Date: Tue, 05 Feb 2008 22:46:11 +1000
I will assume Unix or Linux as you mentioned links, only available in Windows 2008
This isn't as silly as it sounds.
Each user that you wish to run an instance under needs to be added to the DBA group, then they can run the installed binaries. No need for links, just tell the user to use that Oracle_home and run and create the database.
I would however suggest that you dont use the same binaries i.e ORacle_Home for test/development and production. This will limit your ability to apply Oracle patches for testing prior to them going to production
On Tue, 2008-02-05 at 13:16 +0100, Remigiusz Sokolowski wrote:
> I try here to run several instances, every one from different account,
> but using the same installation, which is owned by yet another account.
> I wonder if anyone could share similar experiances?
> Main thing I am really confused is privileges on which an instance works.
> Let's say that installation owner is oracle and there is another account
> oratest from which we would like to run an instance with name ORATEST.
> ORACLE_HOME for oratest is a link to binaries real location.
> The instance starts on oracle privileges. Of course I can manage the
> from oratest account by sqlplus, but I would like to run it on oratest,
> or in case that is impossible, just know the reasons behind that.
> Can anybody explain what decides on which privileges the instance runs?
> Thanks in advance