Re: Oracle Database with Microsoft Active Directory

Andrea wrote:
> hi,
>
> i'll try to install a oracle 10g DB with active directory support for take
> advantage of integrated authentication in the 2003 domain.
>
> I've been read this doc:
> http://www.dizwell.com/prod/node/23
>
> and it describe to register (REGSVR32 SCHMMGMT) dll for alter the microsoft
> Active Directory Schema before create instance of db.
>
> I would like to know if this is a correct procedure and if could be incoming
> problem for AD of microsoft.

Is it a correct procedure - yes. It's one of the few of Howard's articles I don't like much and purely because it rather glosses over what you are doing here and why.

What you are in fact doing is changing the list of types of things that AD knows about and creating a few instances of the new things (listeners, databases, clusters etc). Consequently you will also be changing the list of things that your domain, or trust domains or forest, exchange information about and maintain. Now if your server room is your study (as in the article) that's just fine and dandy. If however you are a multi-national corporation well you may well encounter a few challenges. The basics are the same but the implications - in terms of what is replicated where and who has access to change this sort of thing are a wee bit different.

> Another question, is needed install oracle on windows server domain or also is
> enough on windows server standalone (joined in domain).

Not sure what you mean here, but I couldn't possibly have communicated in italian so that's Ok. If you mean do you do this without an active directory domain - no you don't. If you mean does this action have to be taken on a domain controller - no it doesn't, any workstation will do. If you mean should the oracle services be running on domain controllers - again no, and in fact that would likely be a bad idea

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info/services