Re: os accounts on windows servers

From: Paul Drake <bdbafh_at_gmail.com>
Date: Thu, 10 Feb 2011 09:02:17 -0500
Message-ID: <AANLkTi=fzubq1uWHg=roRW4BaYKEFY98uDwSEw+xMLui_at_mail.gmail.com>

On Tue, Feb 8, 2011 at 5:07 PM, Joe Smith <joe_dba_at_hotmail.com> wrote:

> Where is there a document on setting up oracle users to administrator the
> database on Windows servers?
>
> Our admin wants to use domain accounts with Active Directory , but that
> does not sound right to me.
>
> I have looked on metalink and the install docs but have not found anything
> yet.
>
> Can somebody point to a document?
>
>

Joe,

Do you want to be able to leverage "large pages" (memory allocation)? [Yes] If so, you're going to have to alter the local security policy such that the account that owns the Oracle services has the privilege of "lock pages in memory" granted to it.
A local service account seems like the best way to go about this, with it belonging to the local Administrators group.

You may be able to have your MS Domain admin enact this at the domain level, but you likely can perform these actions yourself on the local machine/vm.

http://download.oracle.com/docs/html/B13831_01/ap_64bit.htm http://www.stanford.edu/dept/itss/docs/oracle/10gR2/win.102/b14305/tuning.htm

Be careful that the domain group policy doesn't override your local settings the next time that MS SMS rolls out its group policy changes. Migrating to Linux resolves such issues.

Paul

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Feb 10 2011 - 08:02:17 CST