Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: using LDAP for tnsnames.ora repalcement

Re: using LDAP for tnsnames.ora repalcement

From: Niall Litchfield <>
Date: Mon, 24 Oct 2005 06:32:56 +0100
Message-ID: <>

On 10/21/05, Vergara, Michael (TEM) <> wrote:
> Adar, & Everyone:
> It's all well and good to have the view that the Oracle products work, and
> you
> can just install them and it will work.

Although somewhat brave...

However, I have management who says
> (in effect) "Thou shalt have but one directory, and it shall be Active".

I think that, assuming you are a windows clients only shop (not the OPs position) this is sensible.

So I'm in the same boat as these other folks who are required or constrained
> by company policy and management to a single infrastructure. If we cannot
> work with that then we don't do it. Then, of course, they tell us to move
> towards Single-Sign-on.
> The upshot of this is that I too am listening for another member of this
> list
> who has done this, or has tried and failed and here's what tripped them
> up,
> any sort of war story that could help me out.

I went down the getting AD to work as a tnsnames.ora replacement route and failed. Windows 2000 AD and 9i OID (probably 9.0.1 in fairness) didn't play together, at least for names resolution. In the end I was told by someone out of the OID support team that really I needed to use a 10g system to setup and configure because the AD support in 9i wasn't going to be there at all "Thou shalt have only one infrastructure and it shall be Oracle" or something, but then got tagged back in in response to customer demand. Upshot was that as a client 9i was just fine but really wait until 10 to set it all up.

The other thing that may be significant of course is that this was also win2000 AD and not a 2003 domain.

Niall Litchfield
Oracle DBA

Received on Mon Oct 24 2005 - 00:35:01 CDT

Original text of this message