Re: Dump ldap into tnsnames.ora ? (automatically)

From: Laurenz Albe <invite_at_spam.to.invalid>
Date: 06 Dec 2005 11:43:52 GMT
Message-ID: <1133869431.511439@proxy.dienste.wien.at>

zejeanmi_at_gmail.com wrote:
> We are using ldap naming (oracle internet directory for name
> resolution).
>
> Is there a command to dump the whole ldap into a tnsnames.ora ?
> (we need to generate this file automatically with a batch)

I don't think that there is a single command.

You can however write a shell script that does what you want.

You need a query like:

ldapsearch -h oidserver -b '' -s sub '(objectclass=orclNetService)' orclNetDescString

This will output a list of all entries, first the DN, then the connection string.

Reading that output line for line, a shell script should be able to create a tnsnames.ora file from that.

Yours,
Laurenz Albe Received on Tue Dec 06 2005 - 05:43:52 CST