Re: os accounts on windows servers
- From: Paul Drake <bdbafh@xxxxxxxxx>
- To: joe_dba@xxxxxxxxxxx
- Date: Thu, 10 Feb 2011 09:02:17 -0500
On Tue, Feb 8, 2011 at 5:07 PM, Joe Smith <joe_dba@xxxxxxxxxxx> 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
Other related posts:
